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 :


Properties in the mysql-db in table User:

Host:
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

iD8DBQFEw6lRRyjqIZhNjDcRAty4AJ9PheV3XhEEljGwawbt1Twi7VriOwCg 8zTX
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=gcdmo-myodbc@m.gmane.org

RE: ODBC-Zugriff von Access 2003 auf mysql (linux)

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@mymail.ch]=20
Sent: Monday, 24 July 2006 2:23 AM
To: myodbc@lists.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 :


Properties in the mysql-db in table User:

Host:
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

iD8DBQFEw6lRRyjqIZhNjDcRAty4AJ9PheV3XhEEljGwawbt1Twi7VriOwCg 8zTX
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=3Dgcdmo-myodbc@m.gmane.o rg

Re: ODBC-Zugriff von Access 2003 auf mysql (linux)

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

jbonnett@sola.com.au wrote:
> There are several things that can cause this.
>
> Is there anything, like a firewall, that might block access to the MySQL
> port (usually 3306) on the host?

Ok now the port 3306 is open while running the mysql-daemon.

> 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?

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

iD8DBQFExNnvOAckbBgiIFcRAv8YAKCEDWa35d4nBbmu29yeMFwn/vxs9QCg lbw6
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=gcdmo-myodbc@m.gmane.org