MySQL 5.1 Connector, Vista and bugs.

[Artem Shubin]

Hi evryone!

I am programming in Turbo Delphi Explorer, using ADO (ODBC connector) components.
My first problem is that my program can`t connect to remote server under vista (on local PC). Under XP SP2 (My working OS) evrything works great!
I was truying to install new connector version (5.1) and it fails even under XP.
I can only connect to database, but i cant SELECT something.
I clean my database and create one simple table, but all my SELECT commands fails with E_FAIL error;
I am not even try to connect under Vista :)

Who can help me? :)
My connecttion string is like:
Driver={MySQL ODBC 5.1 Driver};Server=server.name;Port=3306;Database=db_test;User=db_1; Password=123;Option=3;

or

Driver={MySQL ODBC 3.51 Driver};Server=server.name;Port=3306;Database=db_test;User=db_1; Password=123;Option=3;

Provider name is MSDASQL.1;

P.S. Sorry for my english.



Edited 1 time(s). Last edit at 12/06/2007 11:19AM by Artem Shubin.