Cannot create database with odbc connection

2
votes

Im connected to the sysmaster database with odbc. Now i want to execute an "create database" statement, but im getting an general error while SQLExecDirect.

sqlret = SQLExecDirect( stmt, (SQLCHAR*)"CREATE DATABASE testing", SQL_NTS );

this fails (sqlret is -1) and SQLGetDiagRec gives the following: HY00 -11060 [Informix][Informix ODBC Driver]General error.

I have even tried to use SQLPrepare and SQLExecute and then the SQLPrepare is showing this error. Is it not possible to create a new Database with odbc? In an JDBC program this works.

1
databaseodbcinformix

1 Answers

2
votes

You can use 'CREATE DATABASE' from within ODBC but only if there is no implicit connection to an existing database.

Try adding 'CONNECTDATABASE=NO' to your connection string.