ABT DRS STAGE

[Saama]

hi gurus,
i wanted to show my team lead how DRS works, i used DRS stage as source and DRS stage as target.
in the DRS STAGE iam extracting data from SQL SERVER.
given DATABASE TYPE AS - mssql server.
connection- defined new dsn by selecting the drivers for SQL SERVER.
i have tested the connection when defining DSN it was correct.
when iam using DRS- as source ans trying to view the data.
iam getting error as DSBROWSER-RDBMS-0:[MICROSOFT ODBC DRIVER MANAGER INVALID].
shall i need some other drivers inorder to work with RDS STAGE.
i will appreciate if any guru can help me out.

cheers;
saama

[I_Server_Whale]

It is better to use the DataDirect drivers provided by Ascential.

[Saama]

Hi,
i dont have ascential drivers.
is that the drivers problem, iam getting few other errors too.
iam getting DS BROWSER: DYNAMIC_RDBMS:SQL BIND COL:FAILED TO BIND THE RESULT SET COLUMN.
DSBROWSER: DYNAMIC_RDBMS:DS LINK1:DSP.OPEN GCI $DSP.OPEN ERROR.
i would appreciate if anyone helps me out.

cheers;
saama

[narasimha]

You dont need any any additional drivers in order to work with the DRS stage.
Check your ODBC connection set up again.
Also, do you get the same error when you try using the ODBC stage?

[narasimha]

Hi,
i dont have ascential drivers.
is that the drivers problem, iam getting few other errors too.
iam getting DS BROWSER: DYNAMIC_RDBMS:SQL BIND COL:FAILED TO BIND THE RESULT SET COLUMN.
DSBROWSER: DYNAMIC_RDBMS:DS LINK1:DSP.OPEN GCI $DSP.OPEN ERROR.
i would appreciate if anyone helps me out.

cheers;
saama

Does not look like a driver problem, it looks more like a permission problem. Can you copy and paste the "exact" error messages.

[Saama]

Hi gurus,
Thanks very much my DSN was not properly configured.
thanks again.


cheers;
saama

[narasimha]

Nice!

If its done, mark the post as Resolved