Hi Venu, > It doesn't depend upon OPTION value. Can you change the following > parameters and try it out. > > 1. UID instead of USER NAME > 2. DATABASE or DB instead of DATABASE NAME > 3. PWD instaed of PASSWORD
I assume USER NAME and PASSWORD are right since the parser recognizes them correctly when I use a dsn connection. If the driver wasnt loaded properly shouldn't it crash also on a DSN connection? Like I said it works fine for a DSN connection but not for a DSN-LESS connection. I also assume my program is ok since it works with an Access97 database. I also assume DATABASE NAME is the right keyword since I tried it with said Access97 connection. The only thing left is the SERVER keyword since PORT 3306 is the default one and therefore that item need not be specified. One thing I am curious about is where are these keywords defined? I mean at first I thought these where standards across all implementations but I have encountered many different syntax like UID instead of USER or USER NAME, etc.... Is there a way to check this out? To ensure I have the right syntax? As for log, I'm not at work right now but will shoot it as soon as I get my hands on it. Thx a lot for the help Venu. Syl ----- Original Message ----- From: "Venu" <[EMAIL PROTECTED]> To: "Sylvain Hamel" <[EMAIL PROTECTED]>; "MySQL Mailing list" <[EMAIL PROTECTED]> Sent: Friday, October 05, 2001 6:12 PM Subject: RE: DSN-Less connections using MyODBC? > Hi !!! > > > -----Original Message----- > > From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] > > Sent: Friday, October 05, 2001 2:26 PM > > To: MySQL Mailing list > > Subject: Re: DSN-Less connections using MyODBC? > > > > > > Thx for the quick response... > > > > Here's my connection parameters. I always get invalid parameter. > > > > DRIVER={MySQL}; > > USER NAME=myusername; > > PASSWORD=mypassword; > > SERVER=10.10.10.45; > > DATABASE NAME=DatabaseName; > > PORT=3306; > > > > I am pretty sure of the driver name since "MySQL" is the > > exact string > > Windows98 ODBC manager shows me. > > > > I put the port param there just in case but I think 3306 is > > the default port > > number and therefore is not necessary. > > > > Could it be possible it is because I did not set any options? > > > > It doesn't depend upon OPTION value. Can you change the following > parameters and try it out. > > 1. UID instead of USER NAME > 2. DATABASE or DB instead of DATABASE NAME > 3. PWD instaed of PASSWORD > > Here is the simple DSN-less connection string: > "DRIVER={MySQL};SERVER=localhost;DATABASE=test;UID=monty;PWD=monty;" > > If you are still facing the problem means, then check whether the > driver > is loaded or not by the DM. If it is, then send the ODBC log. > > Regards, venu > -- > For technical support contracts, go to https://order.mysql.com > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer > /_/ /_/\_, /___/\___\_\___/ California, USA > <___/ www.mysql.com> > > ----- Original Message ----- > > From: Venu <[EMAIL PROTECTED]> > > To: Sylvain Hamel <[EMAIL PROTECTED]>; MySQL Mailing list > > <[EMAIL PROTECTED]> > > Sent: Friday, October 05, 2001 5:07 PM > > Subject: RE: DSN-Less connections using MyODBC? > > > > > > > Hi !!! > > > > > > > -----Original Message----- > > > > From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] > > > > Sent: Friday, October 05, 2001 1:36 PM > > > > To: MySQL Mailing list > > > > Subject: DSN-Less connections using MyODBC? > > > > > > > > > > > > Anyone ever tried a MySQL dsn-less connection (I am working > > > > in Borland C++ > > > > Builder)? > > > > > > > > I can do it with a dsn but can't seem to make connection in > > > > dsn less. > > > > > > > You need to specify the exact name of the driver in the connect > > > string as: > > > > > > DRIVER={MySQL Driver}; > > > or > > > DRIVER={MySQL}; > > > > > > based on the driver name configured in your system. > > > > > > Regards, venu > > > -- > > > For technical support contracts, go to https://order.mysql.com > > > __ ___ ___ ____ __ > > > / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> > > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer > > > /_/ /_/\_, /___/\___\_\___/ 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 > > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
