------_=_NextPart_001_01C50887.63BF8B6D
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I installed the latest myodbc version (.10 I believe) and when I test my
connection in odbc, it doesn't seem to use the port I specified. It's
on another computer and can't get this to work. I know it's using the
default port because I have a mysql server on that port also and when I
give it a valid id/pwd for that one, it works.



Lance Johnson
DOCS, Inc.
Lead Programmer
www.SOAPware.com
(800)455-7627




------_=_NextPart_001_01C50887.63BF8B6D--

Hi Lance,

> I installed the latest myodbc version (.10 I believe) and
> when I test my connection in odbc, it doesn't seem to use the
> port I specified. It's on another computer and can't get
> this to work. I know it's using the default port because I
> have a mysql server on that port also and when I give it a
> valid id/pwd for that one, it works.

got the same on Win2k Pro SP2 and MyODBC .10-x (sorry, i already
deleted the file). The port is not correctly written to the registry
and also not correctly read from it.
I use MyODBC-3.51.06 now where assigning a port different to 3306 works
as expected.

Regards,

TomH

--
PROSOFT EDV-Loesungen GmbH & Co. KG phone: +49 941 / 78 88 7 - 121
Ladehofstrasse 28, D-93049 Regensburg cellphone: +49 174 / 41 94 97 0
Geschaeftsfuehrer: Axel-Wilhelm Wegmann Tom.Horstmann [at] proSoft-Edv.de
AG Regensburg HRA 6608 USt.183/68311 http://www.proSoft-Edv.de
--


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

I think this is a problem that has been recently fixed. The MySQL DSN
was forgetting the port number and defaulting to the standard one.

Try a newer version of MyODBC.

John Bonnett

-----Original Message-----
From: Lance Johnson [mailto:ljohnson [at] DOCS.com]
Sent: Wednesday, 2 February 2005 4:23 AM
To: myodbc [at] lists.mysql.com
Subject: odbc port

I installed the latest myodbc version (.10 I believe) and when I test my
connection in odbc, it doesn't seem to use the port I specified. It's
on another computer and can't get this to work. I know it's using the
default port because I have a mysql server on that port also and when I
give it a valid id/pwd for that one, it works.



Lance Johnson
DOCS, Inc.
Lead Programmer
www.SOAPware.com
(800)455-7627




--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg