Good Day, Doug.
Let me some note.
DSN is just link to some database.
System, User and File DSN difference is the database link storage.
System - Locale machine registry tree, User - current user registry tree,
File - file
I have installed MyODBC 2.50.21. There are no problem on Access 97 SR-2
So, DSN is database link.
Thats why you have to create MySQL database first. What DB wish you link to
----- Original Message -----
From: Doug Evans <hermit09@stripped>
Sent: Wednesday, August 25, 1999 3:52 PM
Subject: RE: Is there anyone here
> Thanks to both of you for trying to help. I thought I did what you guys
> to do, but I must be doing something wrong.
> Steve... Are you implying that I need to do this on two machines, and that
> it can't be done on one? I have two machines that are networked, so if
> is the case I have no problem, there.
> Phil... Regarding the the drivers. I run Windows98. Should I be using
> "MyODBC 2.50.24 for Windows95 (full setup)", and then replace the ".dll"
> with 2.50.25?
> Right at the moment, I have 2.50.24 installed in both System and User DSN.
> have the other driver available, if I should replace it.
> Regardless, this is where I run into trouble. I am assuming something
> be in "File DSN". When I try to install "MySQL" into this area I am asled
> for the name of the data sourse. I am lost here. Any suggestions.
> Details: My machine is named Localhost, and I have a permanent DSL
> connection to the internet, with a constant IP address. When I try to link
> Access to my MYSQL database, called Comptronics, I am lost as to what goes
> into which fields.
> Hope you can straighten me out.
> Phil said:
> First off what you are trying works beautifully, eventually.
> Get the mysql odbc drievrs from www.mysql.com
> Step 2:
> Install said drivers.
> Create the DSN
> Connect Access to mysql.
> Steve said:
> From there all you need to do is install MyODBC on the machine that
> Access97 is on, setup the proper datasource in the controlpannel
> and then link it via ODBC
> see http://www.mysql.com/download_win.html
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread395@stripped
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.