MyODBC 3.51.12 automatically resetting connection parameters

Mailing List

Home

Forum Home

MySQL General - General MySQL discussion

MySQL++ - Programming with the C++ API to MySQL

MaxDB - Everything about MaxDB, formerly known as SAP DB

ODBC - ODBC with the MySQL Connector/ODBC driver

MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP

Java Help - Mostly related to the MySQL Connector/J driver

Perl - Perl support for MySQL with DBI and DBD::mysql

GUI - MySQL GUI Tools

Announcement

Subjects

•	mysql openssl Question
•	mysql:it 's a db not a dbms how it 's possible?!
•	Does the binary log enabling affect the MySQL performances?
•	Strange behavior, Table Level Permission
•	FULLTEXT query format question
•	Preventing Duplicate Entries
•	Comparing and writing out BLOBS
•	Executing MySQL Commands From Within C Program
•	Can 't access mysql after kernel upgrade
•	Mysql 4 0 Oracle Stored Procedure Trigger Conversion
•	Downgrade Mysql from 4 to 3 23
•	MySQL Cluster Software
•	mysql test 4 1 fails with the gis test
•	ERROR 2002: Can 't connect to local MySQL server through socket
•	Getting Identity after INSERT
•	Update one field with more fields from another table
•	ERROR 1045: Access denied for user: 'root@localhost ' (Using password: NO)
•	mysql have same function mthod as Oracle decode()

MyODBC 3.51.12 automatically resetting connection parameters

MyODBC 3.51.12 automatically resetting connection parameters

2006-07-03 - By Onno Broekmans

Back

Reply: 1 2 3 4

Hello,

Today, I installed MyODBC 3.51.12 on a Windows XP computer to access a
*remote* MySQL database through Microsoft Access 2002 (XP). Testing the
connection works perfectly.

However, when I try to access the database through Access, MyODBC pops up
a login form. On this login form (which is the same as the "Configure Data
Source Name" dialog) everything is grayed out, except the username and
password. The strange thing is, that on the login form, the "host"
parameter is reset to "localhost"! Pressing OK makes MyODBC fail to
connect --- which makes sense, since there's no MySQL installed on
localhost.

Summarizing: it seems that MyODBC automatically resets "host" to
"localhost", instead of the original setting, upon Access trying to
initiate the connection.

Is this a bug? Is there a workaround?

Thanks in advance!

Yours sincerely,

Onno

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)