Home > Default > Unable to connect SQLState=08004 Oracle ODBC Ora-12154

Unable to connect SQLState=08004 Oracle ODBC Ora-12154

November 30Hits:0
Advertisement
Hi Sir/Madam,
I am Wayne, I need your help to resolve my issue in oracle database 11g.
1. I installed Oracle 11g Personal Edition, Release 11.2.0.10, 64bits,
2. Test connection(oracle in oradb11g_home1) is successed in data source, odbc,
2. Then, I tried to connect this with Visual Basic(Visual Studio 2010), data connections, add connections, .net framework data provider for oracle,
3. but I received an error message as "Attempt to load Oracle client libraries threw BadImageFormatException."
4. Then, I download the ODAC(11.2.0.3.0) for 64bits, and installed,
5. I tried to test the connection, but failed with error message as stated above,
"Unable to connect SQLState=08004 Oracle ODBC Ora-12154: TNS:could not resolve the connect identifier specified"
Could you please give me a help on this, do I need to install ODAC for 11g Personal Edition ? Please advice accordingly, thanks.

Answers

Hi;
Please review:
https://kr.forums.oracle.com/forums/thread.jspa?threadID=2309520
http://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error
Regard
Helios

Read other 2 answers

Tags:

Related Articles

  • Unable to connect SQLState=08004 Oracle ODBC Ora-12154November 30

    Hi Sir/Madam, I am Wayne, I need your help to resolve my issue in oracle database 11g. 1. I installed Oracle 11g Personal Edition, Release 11.2.0.10, 64bits, 2. Test connection(oracle in oradb11g_home1) is successed in data source, odbc, 2. Then, I t

  • 08004:[oracle][odbc][ora]ora-12154: TNS: could not resolve the connect ....November 30

    This error has just recently started happening, and i cannot figure out why, i have not changed anything in tnsnames.ora file. i am always able to "test connection" in ODBC. even when i get the error in crystal. so i restart Crystal, and i am ab

  • ODBC - ORA-12154: TNS:could not resolfe service nameNovember 30

    I am receiving the following error when doing a Test Connection on an System DSN (Oracle ODBC Driver Configuration). Unable to connect SQState=08004 [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolfe service name I am using the Oracle 9.02 ODBC driv

  • Oracle][ODBC][Ora]Ora-12154:November 30

    Following Proplem ODBC Version 3.520.6XXX when I test a connection I got the message SQLState=08004 [Oracle][ODBC][Ora]Ora-12154: TNS:could not resolve the connect identifier specified. I use a Oracle 10 g Database and Oracle 9.x When I try to connec

  • Unable to connect SQL State=S1000 [Oracle][ODBC][Ora]ORA-12170:October 11

    Hi all, I have an Windows XP OS with SP3. I have installed the Oracle 11g server. On trying to connect to the ODBC connection, i get the following error message: Unable to connect SQL State=S1000 [Oracle][ODBC][Ora]ORA-12170: TNS: Connect timeout occ

  • Unable to connect to my Oracle Database with Microsoft's ODBC for Oracle driverNovember 30

    I am unable to connect to my Oracle Database with Microsoft's ODBC for Oracle driver vers.2.573.4202.00 on a Win98 computer. First, I create a "Net Service Name" in order for the ODBC Driver to find the Oracle server. I then created a System DSN

  • [S1000][unixODBC][Oracle][ODBC][Ora]ORA-03134: Connections to this server version are no longer supportedNovember 30

    Hello, I'm using  unixODBC with ODBC Oracle client 11 (Debian 7) to connect to Oracle database version 9.2.0.6 (Solaris 10),  but show me this message: [S1000][unixODBC][Oracle][ODBC][Ora]ORA-03134: Connections to this server version are no longer su

  • Unable to connect SQLState=IM004 ODBC Driver Manager] Driver's SQLAllocHandNovember 30

    Hi All, When I have tried to create dsn connection it start throwing the following error, do you have any idea how to resolve this.. Unable to connect SQLState=IM004 ODBC Driver Manager] Driver's SQLAllocHandInstall an updated version of the Microsof

  • [Oracle][ODBC][Ora]ORA-03114 not connectedNovember 30

    I' have oracle 10g express edition. I use a c++ windows service administration connections and a Visual Basic program. Vb invoke to c++ service, this create the connection and keep. Vb invoke the interface exposed to c++ service to execute sentence a

  • Unable to connect SQLState=IM003November 30

    Hi all am new to OBIEE. I have Installed OBIEE and oracle 10g and when am trying to create Datasource connection its giving following error. 'Unable to connect SQLState=IM003 specified driver could not able to load due to system error 998(oracle in o

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 1.013 s.