Hi People,
I'm trying to connect to Mysql server using Access2k, VBA and DSN less
connection, and mysql v3.23.36.
All queries sent to the server exceute or returns records just fine except
one simple query.
"DESCRIBE Employees" Employees is a table in my database. the server
responds by :
"Data provider or other service returned an E_Fail status "
The connection string is :
con.Open "Driver={mySQL};" & _
"Server=myserver;" & _
"Port=3306;" & _
"Option=16402;" & _
"Stmt=;" & _
"Database=Inventory;" & _
"Uid=myser;" & _
"Pwd=mypassword;"
Then openning the recorset by :
rst.Open "show columns from Employees;", con
When moving into the recordset , i'm able to move through the first record
and get the first field , but when I
rst.MoveNext
I get the E-Fail error .
I tried "SHOW Columns ..." but same result.
"show datbases ..." is OK
"describe database" is Ok
"Describe table ... --> E_Fail error.
Please note if I use DSN, then everything works fine.
Did Anybody tried this at home?
Regards,
Randy,
-----
\______________ \|/
Hellooooo \ (@ @)
---------------------------------oo0( ^ )0oo-------
Nader Shehayed <\=/>
Senior Application engineer /*\
IAR Systems Inc.
Email : [EMAIL PROTECTED]
---------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
