Page 1 of 1
Interface Not Support
Posted: 25.08.2008, 16:47
by klchin
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
Posted: 28.08.2008, 08:13
by klchin
Hi,
I used Zeos ver 6.6.3 having the same problem.
any help?
Regards,
KL Chin
Posted: 28.08.2008, 09:07
by klchin
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
Posted: 28.08.2008, 09:19
by mdaems
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
Posted: 28.08.2008, 11:05
by klchin
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