Page 1 of 1

error with DRS stage

Posted: Wed Oct 21, 2009 4:28 pm
by abha.kalra
Hi
I am trying to insert data in sql server database using dynamic rdbms stage.
I am getting the followoing error "Could not load drsodbc.so".

I have some before and after sql statement to run using the DRS stage. However, when I have removed these sql statement and running the datastage job it is still giving the same error while doing the insert.
I have insert permission on the table

Please advise.

Posted: Wed Oct 21, 2009 4:50 pm
by chulett
Have you been able to use the DRS stage successfully before (SQL Server or others) and just have a problem in this one job, or is this your first attempt to use it?

Posted: Thu Oct 22, 2009 8:02 am
by abha.kalra
For this project this is the first time I am using drs stage. however for a another project we have used the drs stage. both project has server on different Unix box

Posted: Thu Oct 22, 2009 3:27 pm
by us1aslam1us
Hello Abha,

We went through the same Issue couple of days ago and found that there is bug fix (patch) available for this. Talk to you Serive Provider.

sAM