Sql driver issue
Moderators: chulett, rschirm, roy
Sql driver issue
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
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
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 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)
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)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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)
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)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: