[unixODBC-support] SQL_INVALID_HANDLE error

Nick Gorham nick.gorham at easysoft.com
Fri Apr 21 09:18:34 BST 2006


Marshall Wood wrote:

>What is it?????
>
>I think it might have something do with my connection string, but I am
>unsure if that is true.
>
>
>char szDSN[] = "ODBC:FILETDS";
>retcode = SQLConnect(hDbConn, (UCHAR *)szDSN, SQL_NTS, (UCHAR *)szUID,
>SQL_NTS, (UCHAR *) szAuthStr, SQL_NTS);
>
>I have tried
>
>char szDSN[] = "FILETDS";
>retcode = SQLConnect(hDbConn, (UCHAR *)szDSN, SQL_NTS, (UCHAR *)szUID,
>SQL_NTS, (UCHAR *) szAuthStr, SQL_NTS);
>
>I'm running out of places to ask :)
>
>_______________________________________________
>unixODBC-support mailing list
>unixODBC-support at easysoft.com
>http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>
>
>  
>
Turn on ODBC tracing, that may give a better idea whats going on.

in odbcinst.ini

[ODBC]
Trace = Yes
Tracefile = /tmp/sql.log

-- 
Nick Gorham
Easysoft Limited



More information about the unixODBC-support mailing list