Re: mySQL and SQLDriverConnect
Nick Gorham <[email protected]>
| Newsgroups | gmane.comp.db.unixodbc.devel |
|---|---|
| Message-ID | <[email protected]> |
Igor Korot wrote:
>Hi, Nick,
>
>
>1.
>retcode = SQLDriverConnect( m_hdbc, parentWnd, (SQLTCHAR FAR *)"DSN=test;", (SWORD) connectStr.length(), (SQLTCHAR FAR *) outConnectStr, WXSIZEOF( outConnectStr ), &outConnectStrLen, SQL_DRIVER_NOPROMPT );
>
>2.
>retcode = SQLDriverConnect( m_hdbc, parentWnd, (SQLTCHAR FAR *)"Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=test;User=root;Password=wasqra;Option=3;", (SWORD) connectStr.length(), (SQLTCHAR FAR *) outConnectStr, WXSIZEOF( outConnectStr ), &outConnectStrLen, SQL_DRIVER_NOPROMPT );
>
>Both calls fails, returning -1 in the "retcode".
>
>Again connecting using isql works, which means that the driver works and it's something wrong with the SQLDriverConnect logic.
>Maybe in the first case it's looking for the global (system) DSN only, and does not fallback to the user one?
>And for the second case I don't even know.
>
>Can you or someone else confirm?
>
>Thank you.
>
>
What error is returned from SQLDriverConnect, I think it might be worth
asking the question of the driver writers, as I think thats where the
problem might lie.
--
Nick
_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev