Oninit cdi / Archive
Talk to an expert →

ODBC 3.30.0010139 Error

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Versions, Editions & End-of-Life

Reinhard Habichtsberg — — source: Informix-list mailing list archive (1991-1998)

Hi ODBC - specialist, we have to ask the IDS 7.31UC2 with MS-Access and MS-Excel. We normally use SCO Vision SQL-Retriever 4.17. I wished to migrate to Informix ODBC 3.30. I have two problems: 1. Informix ODBC 3.30 doesn´t support 16-Bit apps :-(. 2. Is it possible that this ODBC-driver has the bug that it cannot work with table names including underscores, for example: a_table_name. If I want to bind such tables to a query I get the error: [Informix][Informix ODBC Driver][Informix]An illegal character has been found in the statement.(#-202) With SQL-Retriever the error does not appear. BTW: Synonyms don´t help. Any experience or ideas? Reinhard

↪ replying to Reinhard Habichtsberg
mars1972@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

In article <80etg2$3lf$1@news07.btx.dtag.de>, "Reinhard Habichtsberg" <Reinhard.Habichtsberg@unilux.de> wrote: > Hi ODBC - specialist, > > we have to ask the IDS 7.31UC2 with MS-Access and MS-Excel. > We normally use SCO Vision SQL-Retriever 4.17. I wished to > migrate to Informix ODBC 3.30. > > I have two problems: > 1. Informix ODBC 3.30 doesn't support 16-Bit apps :-(. > 2. Is it possible that this ODBC-driver has the bug that it cannot > work with table names including underscores, for example: > a_table_name. If I want to bind such tables to a query I get the > error: [Informix][Informix ODBC Driver][Informix]An illegal > character has been found in the statement.(#-202) > With SQL-Retriever the error does not appear. > > BTW: Synonyms don't help. > > Any experience or ideas? > > Reinhard > > I have tables with underscores and haven't had any problems. You might want to call Informix Tech support to find out if they still have copies of older ODBC drivers for 16 bit support. -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to mars1972@my-deja.com
Reinhard Habichtsberg — — source: Informix-list mailing list archive (1991-1998)

<mars1972@my-deja.com> wrote: >Reinhard wrote: >> 2. Is it possible that this ODBC-driver has the bug that it cannot >> work with table names including underscores, for example: >> a_table_name. If I want to bind such tables to a query I get the >> error: [Informix][Informix ODBC Driver][Informix]An illegal >> character has been found in the statement.(#-202) > > I have tables with underscores and haven't had any problems. > I have still this problem. Has anybody an idea? Reinhard

Glossary