Page 1 of 1
Unable to use update only in ODBC stage
Posted: Tue Sep 01, 2009 1:20 am
by ksudhir466
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
Posted: Tue Sep 01, 2009 10:07 am
by Sreenivasulu
Hi
Looks like your ODBC drivers are not installed.
"go to server/branded_odbc" and check whether the odbc drivers are installed
Regards
Sreeni
Unable to use update only in ODBC stage
Posted: Thu Sep 03, 2009 12:59 am
by ksudhir466
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.
Posted: Thu Sep 03, 2009 3:08 pm
by ray.wurlod
He did. Check whether ODBC drivers are installed.