On the contrary, I use MyODBC and NEVER use a DSN, hate the things.
Here is the connection string I use:
DRIVER={MySQL ODBC 3.51
Driver};SERVER=123.456.789.100;DATABASE=mysqldatabase;UID=sampleuser;PWD=123
45; OPTION=16427
It works great, sometimes I add 2048 to the options value to use the
compressed protocol(producing OPTION=18475), it is especially useful when
dealing with blobs.
Mike Hillyer
http://www.dynamergy.com/mike
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 8:43 AM
To: Tamayo, Nelson
Cc: '[EMAIL PROTECTED]'
Subject: Re: Connection String?
Quoting "Tamayo, Nelson" <[EMAIL PROTECTED]>:
> I am trying to connect to MySQL without using a DSN entry, this is my
> connection string
>
> DRIVER={MySQL ODBC 3.51
> Driver};SRVR=159.113.44.49;DB=csapps;UID=user;PWD=password
>
> The error I get is
>
> "Invalid connection string attribute"
>
> Any ideas?
>
>
> Nelson Tamayo
> Claims Automation
> (800) 237-7767 x3520
> [EMAIL PROTECTED]
>
> The information contained in this transmission is legally privileged and
> confidential information intended only for the use of the individual or
> entity named above. If the reader of this message is not the intended
> recipient, you are hereby notified that any dissemination, distribution,
or
> copy of this transmission is strictly prohibited. If you have received
this
> transmission in error, please contact the sender immediately.
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
Nelson,
It sounds like you are trying to connect to MySQL via ADO using a
connection string. ADO connection in that manner requires an OLE-DB driver
for
the database platform if you wish to avoid using an ODBC DSN. I don't think
that there's an OLE-DB (at least not a free one) for MySQL yet. Therefore,
you
will have to use a DSN.
Regards,
--
Barry C. Hawkins
Systems Consultant
All Things Computed
[EMAIL PROTECTED]
404-795-9147 voice/fax
---------------------------------------------------------------------
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
