Interface Not Support

klchin · Post by **klchin** » 25.08.2008, 16:47

Hi,

Does anyone know what could be the possible reason why the ADO
protocol have the error of "Interface Not Support" with MySQL
either version 4.x or 5.x. It can login but even with a very
query "SELECT * FROM abc" also had problem.

Regards,
KL Chin

klchin · Post by **klchin** » 28.08.2008, 08:13

Hi,

I used Zeos ver 6.6.3 having the same problem.
any help?

Regards,
KL Chin

klchin · Post by **klchin** » 28.08.2008, 09:07

Hi,

I added ZSQLMonitor, just show 2 lines

>> 2008-08-28 16:04:11 cat: Connect, proto: ado, msg: CONNECT TO "table" AS USER "root"
>> Interface not supported <-- catch exceptional

What else I can do?

Regards,
KL Chin

Post by **mdaems** » 28.08.2008, 09:19

Seems like there's a problem in the ADO->mysql connection. How's that organised? Never used ADO. Is it using ODBC? What MyODBC version are you using then?

Mark

klchin · Post by **klchin** » 28.08.2008, 11:05

I had tested
a) MySQL version 4.0.x, 4.1.x and 5.0.x, (with/without --old_password)
b) MySQL ODBC ver 3.51 and 5.1,
c) Zeos 6.1.5 and 6.6.3
d) Win2kSP SP2 and SP4.

BTW, I had deployed about 10 similar setup, with Win2k and 2003,
this is the very 1st time having this problem.

Also, had verifed from the other PC connect to his PC MySql,
everything work fine with ODBC.

The PC also having same problem when connect to other
working PC.

Regards,
KL Chin