VB connection to Oracle 9i

[spicysudhi]

Hi
i am getting the followin error when i try to open a ADO connection to oracle 9i database
"Oracle error occurred, but error message could not be retrieved from Oracle."
the same source works fine on 8i database.

ConnectionString = "Provider=MSDAORA.1;Password=myUser;User ID=myPassword;Data Source=myTNSEntry"

can someone help me how to resolve this.
thanks,
sudhi

 

[williamu]

Hi,

The implication here is possible one of a driver issue, or a badly configured tnsnames.ora file.

Try a tnsping to see if you can contact the server. If you can't then check your tnsnames.ora file.





William
Software Engineer
ICQ No. 56047340

 

[spicysudhi]

tnsnames is fine, i am able to connect to oracle from sqlplus. if i hav tns error, the message should be available from oracle (say TNS or protocol error).

abt driver error... can u please explain,

thanks
sudhi

 

[chiph]

You might also want to check that you have the 9i client installed on your machine.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[spicysudhi]

i am running VB on the same server where oracle is installed and i am able to connect to oracle using sqlplus (means client installed).
thanks
sudhi

 

[williamu]

The same really as chiph said, make sure you have the latest client software installed. This should (IMSMC) install the appropriate drivers.

Also ideally you want to use the Oracle OLEDB drivers as well, and not the one supplied by MS.



William
Software Engineer
ICQ No. 56047340

 

[spicysudhi]

many thanks to all.

regards,
sudhi

 

[ToeJamNEarl]

Try making the provider OraOleDB.Oracle