Odbc Error Ora-12514
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring ora-12154 tns could not resolve service name developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask ora-12154 tns could not resolve the connect identifier specified windows 7 Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join
Ora-12154 Tns Could Not Resolve Service Name Oracle 11g
them; it only takes a minute: Sign up Oracle ORA-12154: TNS: Could not resolve service name Error? up vote 11 down vote favorite 5 I am a SQL Server user . I am on a project that is using
Ora 12154 Tns Could Not Resolve Service Name Oracle 9i
oracle (which I rarely use) I need to create an ODBC connection so I can access the some data via MS Access I have a application on my machine called oraHome90. It seems to allow a configuration of something called a listener in a “net configuration utility”, I think that a “Local Net Service Name Configuration” needs to also be done. The IT support gave me this information to set up the ODBC connection . I have tried every tns could not resolve the connect identifier specified oracle 10g combination that I can think of. I can get past a test that successfully passes a test to “login“ to the oracle server database. When I try to create the ODBC connection I get the following error: ORA-12154: TNS: Could not resolve service name. Assuming that I want to start from scratch and the following information is supposed to allow for me to connect to the database….. Any suggestions or comment ? Note: ultimately the project will have a website .ASP page query the data, but I have to first prove that I can see the data using the ODBC connection via MS Access Service name: SERVICENAME HOST = HOST.XYZi.com User Id: MYUSERID Password: MYPASSWORD ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 'Oracle Connection Dim ocst Dim oconn ocst = "Provider=OraOLEDB.Oracle;" & _ "Data Source=DATASOURCE;" & _ "User ID=CHIJXL;" & _ "Password=password;" set oconn = CreateObject("ADODB.Connection") oracle odbc tns share|improve this question edited Oct 15 '08 at 19:26 David Basarab 35.4k38105145 asked Oct 15 '08 at 19:23 Joe 4164811 add a comment| 19 Answers 19 active oldest votes up vote 8 down vote from http://ora-12154.ora-code.com ORA-12154: TNS:could not resolve the connect identifier specified Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You
Ora 12154 Error In Oracle 10g
can not post a blank message. Please type your message and try error while trying to retrieve text for error ora-12154 again. More discussions in ODBC All PlacesDatabaseDatabase Application DevelopmentWindows and .NETODBC This discussion is archived 7 Replies Latest reply ora-12154 tns could not resolve service name windows 7 on Sep 9, 2009 5:57 PM by vijay polsani ORA-12514: TNS:listener does not currently know of service requested 569109 Mar 27, 2007 4:54 AM I'm currently trying to set up a reporting http://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error data source in VS2005 in a Reporting project. Now when I try to create a new report using my Oracle based data source I get the following: A connection cannot be made to the database. Set and test the connection string. ERROR [NA000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's https://community.oracle.com/thread/491837 SQLSetConnectAttr failed ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). I've installed the data tools for VS2005 as well as the 10g client. I can tsnping the database, as well as connect to it using the SQLPlus tool. I only seem to have an issue when connecting through VS2005. Anyone able to shed some light?? Greg P.S. I'm using XP Pro. 35579Views Tags: none (add) This content has been marked as final. Show 7 replies 1. Re: ORA-12514: TNS:listener does not currently know of service requested 580406 Jun 12, 2007 8:39 AM (in response to 569109) Hi Greg, I am experiencing the same problem. I have found a lot of links in internet with different solutions but so far nothing works. Have you found a solution for this issue or a workaround? Josue Like Show 0 Likes(0) Actions 2. Re: ORA-12514: TNS:listener does not currently know of service requested 583990 Jun 19, 2007 9:02 PM (in response to 580406) Check your tnsnames.ora file on the Reporting Server. Make sure you can tnsping the database. Then try creat
XenDesktop 7.x Evaluations SysTools Export Notes Software Testdrive What is Software TestDrive? PowerShell Basic Question and Answers http://www.gunnalag.com/2014/03/20/fix-oracleodbcoraora-12514-tnslistener-could-not-resolve-service_name-given-in-connect-descriptor/ Deleting Files and Folders Copying File/Folder(s) Listing only Files/Folder(s) http://www.dba-oracle.com/t_ora_12514_tns_listener_service_name.htm Executing Commands Unix like Head & Tail Implementing detailed logging Mapping a Free Drive Letter Convert PS script into an Exe Process Explorer Password Generator SQL List all active connections List all DBs Sizes in MBs List tns could all DB names in Oracle Kill all sessions connected to SQL DB Search a complete SQL DB Convert UTC Time to Local Time Saving each row from SELECT results set dbo vs. db_owner Others Php - What is my IP Address? ASP - What is my IP tns could not Address? Password Generator - Simple String Compiling Perl Modules FIX: [Oracle][ODBC][Ora]ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor gunnalagMarch 20, 2014 You encounter below error while connecting to Oracle DB instance, which was working before ------------------ ODBC 32Bit Test Program ------------------ SQLSTATE: S1000 Native Error Code:12514 Driver Message:[Oracle][ODBC][Ora]ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor Need Any suggestions to avoid error ? ------------------ Yes No ------------------ Troubleshooting: TNS Listener shows its status as running: [root@ProdDB01 ~]# lsnrctl status LSNRCTL for Linux: Version 8.1.6.0.0 - Production on 20-MAR-2014 10:48:58 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.21.201.217)(PORT=1521))) STATUS of the LISTENER ---------------- Alias LISTENER Version TNSLSNR for Linux: Version 8.1.6.0.0 - Production Start Date 20-MAR-2014 10:45:55 Uptime 0 days 0 hr. 3 min. 3 sec Trace Level off Securi
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ORA-12514: TNS: listener could not resolve SERVICE_NAME Question: Here's my issue, causing a ORA-12514: TNS: listener could not resolve SERVICE_NAME error: CODE SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor I'm using Oracle 10g on Windows 2000. What's cause of this error and how to resolve it? Answer by Edward Stoever: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener. Action: - Wait a moment and try to connect a second time. - Check which services are currently known by the listener by executing: lsnrctl services