Re: mySQL and SQLDriverConnect

Hi,

-----Original Message-----
>From: Nick Gorham <[email protected]>
>Sent: Jun 18, 2008 11:40 PM
>To: Igor Korot <[email protected]>
>Cc: Development issues and topics for unixODBC <[email protected]>
>Subject: Re: [unixODBC-dev] mySQL and SQLDriverConnect
>
>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.

Before I go ask this on mySQL site, I want to confirm one thing:

My application compiled with the UNICODE support on.
But I explicitly call non-UNICODE ODBC API function, and the driver I installed is not UNICODE aware.

What's going to happen in this case? Will the app call non-UNICODE function from DM? And if not, how DM
and the driver will communicate?

Thank you.

>
>-- 
>Nick

_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev