)-----Original Message----- )From: Sinisa Milivojevic [mailto:sin...@mysql.com] )Sent: Wednesday, September 05, 2001 5:35 AM )To: ran...@calitel.com )Cc: mys...@lists.mysql.com )Subject: Re: DSN-Less connection Strange error! ) ) )ran...@calitel.com writes: )> 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. )> ) )<cut> )> )> "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 : ran...@calitel.com )> --------------------------------------------------- )> ) )Our ODBC driver still requires DSN. ) )There is a new version in the works that will work without it. )

Also, when you are using DSN-less connection, you need to supply the OPTION flag in the connection string itself. When you said it is working fine with DSN connection, that means you have set some options in the connection dialog, might be "Don't optimize column width". So when you are using other way, provide OPTION=1 (Check which one you need to supply) with the connection string, and everything will work fine.

Also, there waa a bug in the driver, even when application is using DSN-less connection, driver always displays the connection dialog and waits for the DSN to be entered (atleast you need to insert space). I fixed this couple of days back, and the fix will be available for .39 version.