469,907 Members | 2,184 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,907 developers. It's quick & easy.

connecting oracle DB using ODBC

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
Nov 21 '05 #1
2 3455
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.

"Mahesh.V" <ma****@ewaksoft.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
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

Nov 21 '05 #2
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

"Mahesh.V" <ma****@ewaksoft.com> escribió en el mensaje
news:%2****************@TK2MSFTNGP14.phx.gbl...
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

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by va | last post: by
1 post views Thread by yahibble | last post: by
2 posts views Thread by msnesw.microsoft.com | last post: by
3 posts views Thread by Andrew McGregor | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.