Solved: Unable to connect to Oracle

[gnod]

Hi,

On my computer it doesn't have problem connecting to oracle but when i test it to user's pc it prompts an error which i don't understand

Error:
"Runtime error '-2147467259 (80004005)';
Oracle error occured, but error message could not be retrived from oracle."

i already install the oracle 9i client to user's pc and also we have the same MDAC version 2.8..

[VBA]
Set Conn = CreateObject("ADODB.Connection")
With Conn
.ConnectionString = "Provider=MSDAORA;" & _
"Data Source=dbname;" & _
"User ID=username;Password=pword;"
.Open
End With
[/VBA]


pls

[gnod]

hi,

i already solved the other computer.. i edit the PATH environment variable to include the directory/folder of other oracle product installed on that computer..


thanks..