[dba-SQLServer]RE: Access connecting to MySQL

Oh yeah, I don't think I have anything in my database from you -- except for
the MySQL front-end and the follow up using the command buttons to limit a
form's underlying recordset. I'll leave them in my database and continue to
try to sell them -- if I do, you're free to tackle them alone -- however, if
you sell them, let me know so I can take them out, OK?


----- Original Message -----
From: "Arthur Fuller" <artful at rogers.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Tuesday, February 11, 2003 10:42 AM
Subject: RE: [dba-SQLServer]RE: Access connecting to MySQL


> It's not difficult at all, but there are a couple of potential gotchas.
> 1. Install MySQL. Decide whether you want it set up as a service. If so,
> start winMySQLAdmin and set it up to start automatically.
> 2. Ensure that you can hit the server with the mysql client.
> 3. Install MyODBC. This will add two data sources to your list of ODBC
data
> types.
> 4. Create a new DSN that points to the mysql database called test.
> 5. Create a new MDB, then File/Get External Data/Link and point to your
DSN.
> The test database contains no tables, so you won't actually be able to
link
> anything, but you'll know whether everything is set up correctly.
> 6. If you're planning on moving existing Access data to MySQL, and said
data
> uses ANPKs, then you can sidestep a potential issue by adding a timestamp
> column to every table prior to moving the data. If you don't do this, you
> may find that every time you insert a row, all its columns say
"#deleted#".
> You won't see the actual data until you move off the new row and return.
The
> timestamp column gets around this problem.
> 7. There are a number of MySQL GUI front ends that can easily import data
> from SQL Server or Access or other ODBC sources. dbTools is a good one. So
> is MySQLyog. Another good one is MySQLFront, but its author no longer
> supports it.
> Hth,
> Arthur
> -----Original Message-----
> From: dba-sqlserver-admin at databaseadvisors.com
> [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Jim
Lawrence
> (AccessD)
> Sent: February 11, 2003 2:27 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer]RE: Access connecting to MySQL
>
> Hi All:
>
> How difficult is it to connect MySQL to Access. Can it be done directly
> through a connection string like you would do with MSSQL and Oracle or do
> you have to use 'gasp' :-( an ODBC DNS.
>
> TIA
> Jim
>
> PS Access 2002
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
>