Hi All,
I am trying to connect SQL Server 2005 from DataSatge server. But I am not able to connect and giving the below error:
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('SRDNAVEEN','sa')):
BCI Error:SQLSTATE=77,CODE=0,[DataStage][SQL Client][ODBC]523 76
I have added 'SRDNAVEEN' as ODBS string and added in odbc.ini (in /home/dsadm/Ascential/DataStage/branded_odbc), and uvodbc.config and odbc.ini (in path /home/dsadm/Ascential/DataStage/DSEngine)
Can you please help me what should I do to solve the problem?
Regards,
Pksahu
SQL Server 2005 Connection Error
Moderators: chulett, rschirm, roy
Thanks Craig.
I added the ODBC connection string in the Project dorectory now. Sitll I am getting the same problem.
The mesage is
"DSR.MetaGeta(GET.DSNINFO)(SQLConnect('SRDNAVEEN','sa')): BCI Error:SQLSTATE=77,CODE=0,[DataStage][SQL Client][ODBC]523 76"
Is there any other setup required for this?
Thanks a lot.
Regards,
Pksahu
I added the ODBC connection string in the Project dorectory now. Sitll I am getting the same problem.
The mesage is
"DSR.MetaGeta(GET.DSNINFO)(SQLConnect('SRDNAVEEN','sa')): BCI Error:SQLSTATE=77,CODE=0,[DataStage][SQL Client][ODBC]523 76"
Is there any other setup required for this?
Thanks a lot.
Regards,
Pksahu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The token GET.DSNINFO suggests that DataStage is having a problem finding the DSN named in your job. Is the DSN properly configured and is the DSN properly recorded in the uvodbc.config file for the project?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.