Connecting to a remote MySQL instance using ODBC?

G'day all,

I'm trying to connect to a MySQL 4.1.10a instance hosted on a remote =
Windows
XP Pro platform using MyODBC 3.51.11 and for some reason the linked =
tables
created in MS Access appear to be in read-only mode. I cannot therefore
update or insert to the necessary tables from the Access interface to =
the
remote MySQL instance. The ODBC connection has been set up using the
standard Windows DSN control panel with what I would assume is out of =
the
box type "default" settings. The MySQL user has been assigned all
appropriate privileges and whilst trying to resolve this issue I've also
used the stock standard root user credentials with the same results.

What am I doing wrong? Is there something in the ODBC connection
configuration that needs to be set in order to attain full read/write =
access
for the linked tables?

Any help would be greatly appreciated.

Cheers.
Dave.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: Connecting to a remote MySQL instance using ODBC?

Make sure the tables have a PRIMARY KEY defined or Access will make them
read-only.

-Kevin

> -----Original Message-----
> From: Adrian Beech [mailto:a.beech@bigpond.net.au]=20
> Posted At: Wednesday, April 06, 2005 2:54 AM
> Posted To: MySQL
> Conversation: Connecting to a remote MySQL instance using ODBC?
> Subject: Connecting to a remote MySQL instance using ODBC?
>=20
>=20
> G'day all,
>=20
> I'm trying to connect to a MySQL 4.1.10a instance hosted on a=20
> remote Windows
> XP Pro platform using MyODBC 3.51.11 and for some reason the=20
> linked tables
> created in MS Access appear to be in read-only mode. I=20
> cannot therefore
> update or insert to the necessary tables from the Access=20
> interface to the
> remote MySQL instance. The ODBC connection has been set up using the
> standard Windows DSN control panel with what I would assume=20
> is out of the
> box type "default" settings. The MySQL user has been assigned all
> appropriate privileges and whilst trying to resolve this=20
> issue I've also
> used the stock standard root user credentials with the same results.
>=20
> What am I doing wrong? Is there something in the ODBC connection
> configuration that needs to be set in order to attain full=20
> read/write access
> for the linked tables?
>=20
> Any help would be greatly appreciated.
>=20
> Cheers.
> Dave.
>=20
>=20
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: =20
> http://lists.mysql.com/win32?unsub=3Dml.mysql@in-genius.com
>=20

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org