[unixODBC-support] Cannot create table with iqsl & informix driver

Stefan Radman Stefan.Radman at CTBTO.ORG
Thu Mar 17 10:39:57 GMT 2005


Try without a ";" at the end

"create table test" instead of "create table test;"

In isql you don't need the semi-colon

Stefan

> -----Original Message-----
> From: unixodbc-support-bounces at easysoft.com 
> [mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of Brainstorm
> Sent: Tuesday, 08 March, 2005 22:08
> To: unixodbc-support at easysoft.com
> Subject: [unixODBC-support] Cannot create table with iqsl & 
> informix driver
> 
> $ isql -v table user password
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL> create table test;
> [37000][unixODBC][Informix][Informix ODBC Driver][Informix]A 
> syntax error has 
> occurred.
> [ISQL]ERROR: Could not SQLPrepare
> SQL> create database test;
> [37000][unixODBC][Informix][Informix ODBC Driver]General error.
> [ISQL]ERROR: Could not SQLPrepare
> SQL> create database test with log mode ansi;
> [37000][unixODBC][Informix][Informix ODBC Driver]General error.
> [ISQL]ERROR: Could not SQLPrepare
> 




More information about the unixODBC-support mailing list