List:General Discussion« Previous MessageNext Message »
From:Venu Date:October 5 2001 10:12pm
Subject:RE: DSN-Less connections using MyODBC?
View as plain text  
Hi !!!

> -----Original Message-----
> From: Sylvain Hamel [mailto:sylvain@stripped]
> 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 <venu@stripped>
 / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/ California, USA
       <___/ www.mysql.com>
> ----- Original Message -----
> From: Venu <venu@stripped>
> To: Sylvain Hamel <sylvain@stripped>; MySQL Mailing list
> <mysql@stripped>
> Sent: Friday, October 05, 2001 5:07 PM
> Subject: RE: DSN-Less connections using MyODBC?
>
>
> > Hi !!!
> >
> > > -----Original Message-----
> > > From: Sylvain Hamel [mailto:sylvain@stripped]
> > > 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 <venu@stripped>
> >  / /|_/ / // /\ \/ /_/ / /__ 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 <mysql-thread87236@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-venu_mysql=yahoo.com@stripped>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>

Thread
DSN-Less connections using MyODBC?Sylvain Hamel5 Oct
  • RE: DSN-Less connections using MyODBC?Venu5 Oct
    • Re: DSN-Less connections using MyODBC?Sylvain Hamel5 Oct
      • RE: DSN-Less connections using MyODBC?Venu6 Oct
        • Re: DSN-Less connections using MyODBC?Sylvain Hamel6 Oct
          • RE: DSN-Less connections using MyODBC?Venu6 Oct