[AccessD] Converting to MySql

If you do an install on the client's PC for the front end, you can easily
make the DNS entries as part of it. Most of it is registry entries; take a
working one and duplicate it. I did a set of DSNs for a local Access
database, an AS400 and an SQL server and was able to change the SQL and
AS400 DSNs on the fly to flip between production and testing databases.


Bruce H. Johnson
Sylmar, CA
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Monday, July 09, 2007 4:53 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Converting to MySql

Hi Rocky,

I can't advise on doing this without a DSN, as I have never tried it.

If you use a DSN, is has to be created on the PC.  You would get the 
MySQL ODBC driver, and install it on the PC.  This driver is free, and 
easily found on the internet.  On a Windows XP PC, you create the DSN via:
Start
Control Panel
Administrative Tools
Data Sources (ODBC)
(tab) System DSN
Add...
MySQL ODBC 3.51 Driver

I would say that yes, this would probably need to be done by an admin, 
or on advice by someone who knows what to do.  You need the name of the 
server.  In my case, the MySQL databases are on hosted web servers, and 
I got the details of server name, user, password, and database name, 
from the web hosting service.  Your situation may be different, in which 
case I am unable to advise, I've only done this a couple of times, it 
was easy and works sweet.

Regards
Steve

Rocky Smolin at Beach Access Software wrote:
> Steve:
> 
> Thanks for the snip.  Raises a few more questions than it answers.  Like
how
> does the user know the Server Name.  San with the DNS.  And I suppose I'd
> have to prompt for those values.
> 
> Most of my users are not very  adept with computers, although in a company
> using MySql would I expect to find a DBA on staff?
> 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.10.2/891 - Release Date: 7/8/2007
6:32 PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.10.2/891 - Release Date: 7/8/2007
6:32 PM