Home » Infrastructure » Windows » how to get connectivity between sql server and oracle (oracle on IBM AIX 5.2 ,SQL server on window 2003)
how to get connectivity between sql server and oracle [message #454385] Wed, 05 May 2010 06:20 Go to next message
Messages: 86
Registered: June 2009
Location: india

Hi all,

We are using Oracle Database 10g Enterprise Edition Release on AIX 5.2. and sql server 2005 on windows 2003. so we need to get some tables from oracle to sql server database . i intsalled oracle client on windows 2003 where the SQL Server is reside and configre TNSNAMES.ora and its pinging but when i get data from Sql server 2005 by following navigation it gives me below error. there si attached file please check it

DATABASESE---- databasename-- right click on it

task---- import data--- welcome to SQL Server import and export wizard---next----Microsoft OLE DB provider for oracle ---properties---the enter server name username and password . then it will give below error

ORa-12514:TNS:could not resolve the connect identifier specified (MIcorsoft OLE DB provicder for Oracle)

quick response will higle appreciated. thanks a lot in advance.

Re: how to get connectivity between sql server and oracle [message #454387 is a reply to message #454385] Wed, 05 May 2010 06:24 Go to previous message
Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Previous Topic: Date Format In VB Code
Next Topic: How to delete Source file used by Oracle external table
Goto Forum:

Current Time: Thu Mar 23 09:03:24 CDT 2023