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
