connecting oracle DB using ODBC

[Mahesh.V]

Hi All
I get the following error while connecting to the oracle database using
ODBC. in my VB.NET application. Can any one help me out solving this problem

server message (if any):
"ORA-12154:TNS:could not resolve service name

Thank in Advance
Mahesh.V

 

[Steve Planck]

Is there a specific reason why you aren't just using the Oracle adapter for
..NET instead of ODBC? You will receive better performance with the Oracle
adapter and it integrates much more nicely than ODBC.

 

[Carlos J. Quintero [.NET MVP]]

It could be that your TNSNAMES.ORA file is not properly configured or that
your connect string is wrong (which is it?), but the first step to solve
Oracle connectivity problems is to test with SQL*Plus, the native Oracle
tool. Does it work?

Once solved, it is better to use the native .NET providers for Oracle from
Microsoft or from Oracle (ODP.NET).

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com