Unable to use update only in ODBC stage

ksudhir466 · Post by **ksudhir466** » Tue Sep 01, 2009 1:20 am

Following error message comes when ODBC stage is used for update only query

Fatal Error: Could not connect to datasourcereturn code -1 from SQLConnect(handle, 'Userid', 'password', 'Database') with message [DataDirect][ODBC lib] Specified driver could not be loaded

Can anyone help , please

Sreenivasulu · Post by **Sreenivasulu** » Tue Sep 01, 2009 10:07 am

Hi
Looks like your ODBC drivers are not installed.
"go to server/branded_odbc" and check whether the odbc drivers are installed

Regards
Sreeni

ksudhir466 · Post by **ksudhir466** » Thu Sep 03, 2009 12:59 am

Sreenivasulu wrote:Hi
Looks like your ODBC drivers are not installed.
"go to server/branded_odbc" and check whether the odbc drivers are installed

Regards
Sreeni

Hi, Thx for replying

Actually before ODBC stage sort and remove duplicates are used.

when job is run with dataset inplace of ODBC stage it runs fine.

and then in another job if this dataset is used as source and ODBC as target, then it runs fine.

But in a single job its giving the mentioned error.

pls suggest for solution.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 03, 2009 3:08 pm

He did. Check whether ODBC drivers are installed.