SQL Server 2005 Connection Error

pksahu · Post by **pksahu** » Wed Jun 17, 2009 4:49 am

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

chulett · Post by **chulett** » Wed Jun 17, 2009 7:01 am

Nothing needs editing in the 'branded' directory. Plus you need to edit the uvodbc.config file in each Project directory you want to leverage the connection from.

pksahu · Post by **pksahu** » Wed Jun 17, 2009 8:23 am

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

chulett · Post by **chulett** » Wed Jun 17, 2009 8:52 am

Problem is I have no idea what "BCI Error:SQLSTATE=77,CODE=0" denotes. Perhaps it would help if you posted your driver entry details.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 17, 2009 4:17 pm

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?