By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,610 Members | 1,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,610 IT Pros & Developers. It's quick & easy.

connecting oracle DB using ODBC

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.