error with DRS stage

abha.kalra · Post by **abha.kalra** » Wed Oct 21, 2009 4:28 pm

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.

chulett · Post by **chulett** » Wed Oct 21, 2009 4:50 pm

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?

abha.kalra · Post by **abha.kalra** » Thu Oct 22, 2009 8:02 am

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

us1aslam1us · Post by **us1aslam1us** » Thu Oct 22, 2009 3:27 pm

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