)-----Original Message-----
)From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 5:35 AM
)To: [EMAIL PROTECTED]
)Cc: [EMAIL PROTECTED]
)Subject: Re: DSN-Less connection Strange error!
)
)
)[EMAIL PROTECTED] 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 : [EMAIL PROTECTED]
)> ---------------------------------------------------
)>
)
)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.
Regards, Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <mailto:[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ Woodside, California USA
<___/ www.mysql.com
---------------------------------------------------------------------
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
