When you execute a query to select data from an Oracle-linked server by using OLE.
#Oracle odbc manager driver
: ERROR ORA-12170: TNS:Connect timeout occurred ERROR Driver's SQLSetConnectAttr failed ERROR ORA-12170: TNS:Connect timeout occurred at .HandleError(OdbcHandle hrHandle RetCode retcode) at .ctor(OdbcConnection connection OdbcConnectionString constr OdbcEnvironmentHandle environmentHandle) at .ctor(OdbcConnection outerConnection OdbcConnectionString connectionOptions) at .CreateConnection(DbConnectionOptions options Object poolGroupProviderInfo DbConnectionPool pool DbConnection owningObject) at .CreateNonPooledConnection(DbConnection owningConnection DbConnectionPoolGroup poolGroup) at .GetConnection(DbConnection owningConnection) at .OpenConnection(DbConnection outerConnection DbConnectionFactory connectionFactory) at . I have the odbc driver set up on the server that has the SQL database. it also executed successfully when I run it from Package store on the server but the problem is when I run the package as sql job I got this error: After setup odbc.ini and odbcinst. I have set up ODBC connection successfully on my local machine and on the server, I can connect to Oracle database using sqlplus on both environments.Īnd my package run fine on my local machine. 1 Folks, We installed unixODBC-2.3.7 on Aix 7.1 to connect to Oracle 11g.
I created a SSIS package to pull data from Oracle database to SQL server database.
0 kommentar(er)
