Hi Group:
I am having an issue using the ODBC datasource connection within data
stage to SQL Server.
I am able to connect to the database through SQL Server client using
its IP address. I am also able to ping the server using its ip address.
I have the necessary entry in ODBC.ini and uvodbc.conifg files.
If you try to use the above data source name to establish connection
within datastage, we get the error as "Datastage Repository Interface:
DSR. MetaGeta[GET.DSNINFO][SQLConnect] BCI Error: SQLSTATE=S1000,
CODE=80,[DataStage]{SQL Client][ODBC].
I also get the same error while connecting to Oracle database through
the ODBC driver.
Could you please let me know if you have any solution to resolve the
above problem.
Thanks
Jaick
ODBC connect issue
ODBC connect issue
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
ODBC connect issue
Check that you really do have the correct entries in .odbc.ini (and that the environment variable ODBCINI is correctly set).
Your error message is coming from the ODBC driver manager, and implies that the correct ODBC driver cannot be loaded. This could be a library path issue, too, but usually you get other, different, messages in this case.
You may need to use the test facilities within the branded_odbc directory. These were discussed here recently; scan the archives (at www.dsxchange.com).
----- Original Message -----
From: Jaick Joseph
Date: Thu, 15 Jan 2004 12:16:20 -0500
To: datastage-users@oliver.com
Subject: ODBC connect issue
> Hi Group:
>
> I am having an issue using the ODBC datasource connection within data
> stage to SQL Server.
> I am able to connect to the database through SQL Server client using
> its IP address. I am also able to ping the server using its ip address.
> I have the necessary entry in ODBC.ini and uvodbc.conifg files.
>
> If you try to use the above data source name to establish connection
> within datastage, we get the error as "Datastage Repository Interface:
> DSR. MetaGeta[GET.DSNINFO][SQLConnect] BCI Error: SQLSTATE=S1000,
> CODE=80,[DataStage]{SQL Client][ODBC].
>
> I also get the same error while connecting to Oracle database through
> the ODBC driver.
>
> Could you please let me know if you have any solution to resolve the
> above problem.
>
> Thanks
> Jaick
>
>
>
Your error message is coming from the ODBC driver manager, and implies that the correct ODBC driver cannot be loaded. This could be a library path issue, too, but usually you get other, different, messages in this case.
You may need to use the test facilities within the branded_odbc directory. These were discussed here recently; scan the archives (at www.dsxchange.com).
----- Original Message -----
From: Jaick Joseph
Date: Thu, 15 Jan 2004 12:16:20 -0500
To: datastage-users@oliver.com
Subject: ODBC connect issue
> Hi Group:
>
> I am having an issue using the ODBC datasource connection within data
> stage to SQL Server.
> I am able to connect to the database through SQL Server client using
> its IP address. I am also able to ping the server using its ip address.
> I have the necessary entry in ODBC.ini and uvodbc.conifg files.
>
> If you try to use the above data source name to establish connection
> within datastage, we get the error as "Datastage Repository Interface:
> DSR. MetaGeta[GET.DSNINFO][SQLConnect] BCI Error: SQLSTATE=S1000,
> CODE=80,[DataStage]{SQL Client][ODBC].
>
> I also get the same error while connecting to Oracle database through
> the ODBC driver.
>
> Could you please let me know if you have any solution to resolve the
> above problem.
>
> Thanks
> Jaick
>
>
>
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.