Hi,

I am trying to connect to an oracle database using code from my .net application, but I keep getting the error "TNS cannot resolve service name". I can connect to the database using all my other tools and the .net ide even connects to the database using the server tool bar. The connection string I am using is
"Data Source=[tns];user id=[user];password=[pword]"
where [tns] is the tns name; [user] is the user name and [pword] is the password.

I thought it was just my connection string that was incorrect, but then I tried using the OO4O objects which dont use connection strings and this returns the same error. If I run the same code from vb6, it connects no problem.....

HELP PLEASE!