Sql driver issue

deva · Post by **deva** » Wed Dec 23, 2009 1:50 pm

Hi I am running one job. oracle is the source and I am using ODBC_Connector as lookup. I used around 8 odbc connects as lookup in different placess in that job. This job will take around 4 hours. After two hours I am getting the following error. I didn't see any fatal errors. but job aborted with following error.

sql_IPS_UOM2,0: [IIS-CONN-ODBC-000105] Connected to Microsoft SQL Server, version 09.00.4053 through driver VMmsss23.so.
[IIS-CONN-ODBC-000099] The driver does not support quoted identifiers in SQL statements.

Can any one suggested me the issue.

Thanks

chulett · Post by **chulett** » Wed Dec 23, 2009 2:00 pm

If Oracle is the source, how are you "Connected to Microsoft SQL Server"? Regardless, it doesn't like the fact that you have quoted identifiers as noted in the error message.

Sreenivasulu · Post by **Sreenivasulu** » Sat Dec 26, 2009 11:07 am

Is your source 'Oracle' and target is 'SQL Server' /
You can ignore the message. Definitely this message is not the 'cause for abort'

Regards
Sreeni

oacvb · Post by **oacvb** » Mon Jun 14, 2010 8:00 am

I am also facing the same problem. I am extracting it from Db2 database and inserting the data into SQL Server 2000. I modified the job to write into a dataset and it work fine, so there were no issues with Source. I am using ODBC Connector Stage only to connect SQL Server Database. Using DataStage V 8.0.1 in AIX.

Please see the below error message and appreciate your help to resolve the issue.

ODBC_Connector_41: [IIS-CONN-ODBC-000105] Connected to Microsoft SQL Server, version 08.00.12803 through driver VMmsss22.so.
[IIS-CONN-ODBC-000099] The driver does not support quoted identifiers in SQL statements
[IIS-CONN-DAAPI-000361] Generated INSERT statement: INSERT INTO POS_Storage.dbo.POS_LineItems(BUSINESSDATE,STORE,ID,ITEM_NUM,UPC,BUSINESSGROUP,DEPT,QTY,UOM,EXTPRICE,RTLPRICE,VOID,STARTDT,REASON,BUSINESSTIME,PROCESS_DAY,TND_CODE,CARDNO,NETEXTPRICE) VALUES(ORCHESTRATE.BUSINESSDATE,ORCHESTRATE.STORE,ORCHESTRATE.ID,ORCHESTRATE.ITEM_NUM,ORCHESTRATE.UPC,ORCHESTRATE.BUSINESSGROUP,ORCHESTRATE.DEPT,ORCHESTRATE.QTY,ORCHESTRATE.UOM,ORCHESTRATE.EXTPRICE,ORCHESTRATE.RTLPRICE,ORCHESTRATE.VOID,ORCHESTRATE.STARTDT,ORCHESTRATE.REASON,ORCHESTRATE.BUSINESSTIME,ORCHESTRATE.PROCESS_DAY,ORCHESTRATE.TND_CODE,ORCHESTRATE.CARDNO,ORCHESTRATE.NETEXTPRICE)

ODBC_Connector_41: [IIS-CONN-ODBC-000031] Unexpected character found at offset 15 parsing table name POS_Storage.dbo.POS_LineItems (CC_OdbcTableNameParser::parse, file CC_OdbcTableNameParser.cpp, line 293)
main_program: Could not check all operators because of previous error(s)

ray.wurlod · Post by **ray.wurlod** » Mon Jun 14, 2010 5:40 pm

Have you configured a data source name to use the Microsoft SQL Server driver rather than the appropriate Oracle driver?

oacvb · Post by **oacvb** » Fri Jun 18, 2010 10:54 am

Hello,

I have configured in ODBC.ini and .uvobdc config files. Please let me know if i need to configure in other places.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 18, 2010 4:55 pm

You need to configure .odbc.ini in the engine directory.

You also need to configure the DSNs correctly.

oacvb · Post by **oacvb** » Sun Jun 20, 2010 1:51 pm

I don't think it is a problem with .odbc.ini or DSN's because the same parameter is working fine through ODBC stage but not able to connect to same DSN by using ODBC Connector stage.

ray.wurlod · Post by **ray.wurlod** » Sun Jun 20, 2010 2:29 pm

Are you able to do anything at all with Connectors (such as import a table definition)? If not it might be an issue with the Connector Access Service, rather than with the DSN definition.

Connectors use a "funky method using Java and XML" (to quote a very knowledgable IBM support analyst) whereas simpler stage types, such as ODBC Enterprise or Dynamic RDBMS, use the database client software directly or through a driver.

oacvb · Post by **oacvb** » Mon Jun 21, 2010 10:27 am

Hi,

I modified all the configuration files, now i could able to connect to database. I am receiving the following error.

ODBC_Contr_PoS_Baskets: [IIS-CONN-ODBC-000031] Unexpected character found at offset 19 parsing table name POS_Storage_ITF.dbo.POS_Baskets (CC_OdbcTableNameParser::parse, file CC_OdbcTableNameParser.cpp, line 293)

oacvb · Post by **oacvb** » Mon Jun 21, 2010 11:19 am

The issue is fixed. I have mentioned both Schema name and Table name which was giving erro, so i modified to have only the table name. It is working fine. Thanks for your help.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 21, 2010 5:20 pm

Your next task, then, is to mark this thread as Resolved using the green button at the top of the page.

chulett · Post by **chulett** » Mon Jun 21, 2010 5:54 pm

... that or someone can push the button for them. <click>

ray.wurlod · Post by **ray.wurlod** » Mon Jun 21, 2010 5:56 pm

... and absolute power corrupts absolutely.

chulett · Post by **chulett** » Mon Jun 21, 2010 5:58 pm

Come over to the dark side, we have cookies! :D