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
ABT DRS STAGE
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
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
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 wrote: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 Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.