PDA

View Full Version : Solved: Unable to connect to Oracle



gnod
07-30-2008, 08:42 AM
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..


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



pls :help

gnod
08-01-2008, 05:45 PM
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..