Oracle error occurred, but error message could not be retrieved from O

[Largefry]

Help.

I am running a oracle 9I database and trying to connect to it via a vb6 .exe.

When running i get

Oracle error occurred, but error message could not be retrieved from Oracle

Tns names are ok registry files used to pick up specific parts of the connection string are ok.

I can connect via setting up a system DSN and connecting to it via oracle in Orahome92

i cant think what else might be wrong.

Operating system is xppro

Connection string looks like

Provider=MSDAORA.1;Password=" & DBPWD & ";User ID=" & DBUID & ";Data Source=" & DBSRV & ";Persist Security Info=False"

Any ideas??

 

[HarleyQuinn]

Where in your code does it throw up the error?

Cheers

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.