SQLDriverConnect (level one only)

SQLDriverConnect is an alternative to SQLConnect.

It supports data sources that require more connection information than the three arguments in SQLConnect dialog boxes to prompt the user for all connection information and data sources that are not defined data source names.

SQLDriverConnect provides the following connection options:
  • You can establish a connection by using a connection string that contains the data source name, one or more user IDs, one or more passwords, and other information that the data source requires.
  • You can establish a connection by using a partial connection string or no additional information; in this case, HCL OneDB™ ODBC Driver can prompt the user for connection information.

After a connection is established, SQLDriverConnect connection string is completed. The application can use this string for subsequent connection requests.

SQLSTATE Error value Error message
01000 -11001 General warning
01004 -11003 Data truncated
01S00 -11005 Invalid connection string attribute
08001 -11015 Unable to connect to data source
08002 -11016 Connection in use
08S01 -11020 Communication-link failure
28000 -11033 Invalid authorization specification
IM002 -11041 Data source not found and no default driver specified
IM003 -11042 Specified driver could not be loaded
IM004 -11043 Driver's SQLAllocEnv failed
IM005 -11044 Driver's SQLAllocConnect failed
IM006 -11045 Driver's SQLSetConnectOption failed
IM007 -11046 No data source or driver specified; dialog prohibited
IM008 -11047 Dialog failed
IM009 -11048 Unable to load translation shared library
IM010 -11049 Data-source name too long
IM011 -11050 Driver name too long
IM012 -11051 DRIVER keyword syntax error
S1000 -11060 General error
S1001 -11061 Memory-allocation failure
S1090 -11071 Invalid string or buffer length
S1110 -11090 Invalid driver completion
S1T00 -11094 Time-out expired
08S01 -11301 A protocol error has been detected. Current connection is closed.
S1000 -11302 Insufficient connection information was supplied
S1000 -11303 Input connection string too large
S1000 -11317 Invalid connectdatabase value specified
S1000 -11318 Invalid vmbcharlenexact value specified
S1000 -11320 Syntax error
S1000 -11323 The statement contained an escape clause not supported by this database driver