[DataStage][SQL Client]An illegal configuration option Error

gr17 · Post by **gr17** » Thu Oct 13, 2005 3:05 pm

Hello,

I am getting this warning when I run my job

DSD.BCIConnect connecting to SQL_ABC, call to SQLConnect failed.
SQLSTATE=IM997, DBMS.CODE=0
[DataStage][SQL Client]An illegal configuration option was found

Initially the job was working fine, but now I am getting this error.

any feedback is appreciated.
Thanks,
GR

ray.wurlod · Post by **ray.wurlod** » Thu Oct 13, 2005 3:39 pm

Welcome aboard! :D

Initially the job was working fine, but now I am getting this error.

Tell us what changed. "Nothing" is not the correct answer.

gr17 · Post by **gr17** » Thu Oct 13, 2005 8:31 pm

Hi Ray,
Thank You. I am a big fan of your replies, I have been following this Forum since long time but this is my first post.. Well coming to the error

I have 10 different jobs where some jobs have Database tables as targets with Sequential files as sources and some jobs have database tables as source and sequential files as targets.
Initially when the source tables were connected I was able to view the data in the table in the datastage job, But after running the job the job got aborted giving the above warning. I dont know what the problem is.
The database is connected as I am able to view the other tables.
Thank You.
Ruthika

ameyvaidya · Post by **ameyvaidya** » Thu Oct 13, 2005 8:53 pm

Hi Ruthika,

I tried searching google for your error message; No DB-Specific stuff popped up However 1 page of interest popped up:

http://www.progressivenation.net/UVDocs ... ex-44.html

(Search for "illegal configuration option" on the page)

Since that page talks about "uvodbc.config";

Please confirm if your datastage server is on windows or UNIX.

Thanks,

ray.wurlod · Post by **ray.wurlod** » Fri Oct 14, 2005 4:11 am

Check for any changes in the uvodbc.config file in the project and the ODBC data source definitions.