October 20, 2011 at 1:34 am
Hi,
I am facing a problem to connect oracle using ODBC while creating SSIS package. My OS is Windows Server 2008 R2 which is 64 bit only.
October 20, 2011 at 3:49 am
Can you give more info? Any error messages?
Does the 'Test connection' work in the Oracle ODBC configuration?
October 20, 2011 at 5:57 am
Thanx for ur Reply.
yes, its work tnsping is working fine. Right now i installed ODAC (Oracle provider for OLEDB). While using SSIS provider shows but error occurs "ORA-12154: TNS:could not resolve the connect identifier specified (OraOLEDB) ------------------------------ Program Location: at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) "
Link server is worked fine....
October 20, 2011 at 7:04 am
This sounds like a problem with your Oracle client configuration. I'm no expert with Oracle but I kow that if you Oracle client isn't right your SSIS isn't going to work. I would remove SSIS from the equation and try to prove you can connect directly to your Oracle database using one of the Oracle tools\utilities like SQLPlus. Once your have proved a connection to your database can be made move on to SSIS.
This sounds lke a fairly common Oracle issue and a quick search online should provide you with the Oracle expertise. For example see below.
http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm
Good luck.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply