-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I want to access to a mysql-db stored on a linuxsystem from a access
2003-Client.
On trying to access I get the following error: Could not find driver in
systeminformation.

Diagnoseinfos: Can't connect To MySQL serveer on 192.168.0.4


This are the entries tor the myodbc/connector under windows

Data Source Name: Test
Description : Testdatenbank
Server : 192.168.0.4
User : linux
Passwort : <none>


Properties in the mysql-db in table User:

Host: <IP des Accessclients>
User: linux
div. Rechte: alle Y
Connectionangaben: 0


What is going wrong in the myodbc-driver 3.51 on ms-access-side?

Regards,
Ruprecht Helms
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFEw6lRRyjqIZhNjDcRAty4AJ9PheV3XhEEljGwawbt1T wi7VriOwCg8zTX
e6srF92ry4RLMFR2J6ivBd8=
=N9LT
-----END PGP SIGNATURE-----

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=...ie.nctu.edu.tw

There are several things that can cause this.

Does your Access client have network access to 192.168.0.4? Use ping to
check.
Is there anything, like a firewall, that might block access to the MySQL
port (usually 3306) on the host?
Is user "linux" with no password defined on the MySQL server?
Is that user allowed to connect to the server from the client IP
address?

There may be other reasons, but these are the common ones.

John B.

-----Original Message-----
From: Ruprecht Helms [mailto:rhelms (AT) mymail (DOT) ch]=20
Sent: Monday, 24 July 2006 2:23 AM
To: myodbc (AT) lists (DOT) mysql.com
Subject: ODBC-Zugriff von Access 2003 auf mysql (linux)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I want to access to a mysql-db stored on a linuxsystem from a access
2003-Client.
On trying to access I get the following error: Could not find driver in
systeminformation.

Diagnoseinfos: Can't connect To MySQL serveer on 192.168.0.4


This are the entries tor the myodbc/connector under windows

Data Source Name: Test
Description : Testdatenbank
Server : 192.168.0.4
User : linux
Passwort : <none>


Properties in the mysql-db in table User:

Host: <IP des Accessclients>
User: linux
div. Rechte: alle Y
Connectionangaben: 0


What is going wrong in the myodbc-driver 3.51 on ms-access-side?

Regards,
Ruprecht Helms
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFEw6lRRyjqIZhNjDcRAty4AJ9PheV3XhEEljGwawbt1T wi7VriOwCg8zTX
e6srF92ry4RLMFR2J6ivBd8=3D
=3DN9LT
-----END PGP SIGNATURE-----


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=...ie.nctu.edu.tw

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

jbonnett (AT) sola (DOT) com.au wrote:
Ok now the port 3306 is open while running the mysql-daemon.

Now I get the error: is not allowed to connect to this MySQL server.
It seams to me that I have to modify the grantentry for accessing to the
table. I want to use the testdatabase of mysql.

Regards,
Ruprecht
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFExNnvOAckbBgiIFcRAv8YAKCEDWa35d4nBbmu29yeMF wn/vxs9QCglbw6
xKc2vyJ0uQ5Xs+5Us6+H6Gc=
=pVz+
-----END PGP SIGNATURE-----

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=...ie.nctu.edu.tw