Post reply

Connecting to Oracle 9i Server using ODBC from an SSIS package

  • September 8, 2006 at 12:08 pm

    #114327

     

    I am trying to connect to a Oracle 9i Server to execute a sql task, but the connection when tested seems to fail with the following error from the Integration Services Project:

    Test connection failed because of an error in initializing provider.  ERROR [NA000][Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener

    ERROR[IM006][Microsoft ODBC Driver Manager] Driver's SQLSetConnectAttr failed

    ERROR[0100][Microsoft ODBC Driver Manager] The driver does not support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

    The connection was configured and tested from Oracle's SQLPlus session.  Please note that the port that the TNS Server is listening is not the default.  Is there somewhere I can specify the port in the SSIS connection manager to resolve the issue.

    I have tried OLEDB connection and that does not work either.

    Any inputs will be appreciated.

    Thanks,

    Monisha

  • September 10, 2006 at 10:53 am

    #659536

    Hi Monisha,

    To me it sounds as though the ODBC source needs configuring rather than SSIS. Have you tried changing the port number in the ODBC DSN configuration to the port required (it defaults to 1433)?

    Hope it helps!

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply