I recently (last week) accomplished exactly what you are trying to do.
It's important that the DSN for your database be a System DSN, and
nothing else. I ran into various ODBC errors otherwise. Also, remember
that the default username is 'root' with an empty password. It is not
necessary to enter this in the ODBC setup.
Summarize:
You have two machines, the MySQL machine and the Access machine.
1. Install the myOdbc drivers on the Access machine.
2. Open ODBC manager and remove any previous DSNs you created to the
MySQL db.
3. Click 'System DSN' and 'Add'. Choose MySQL driver, of course.
4. Make up a Windows DSN name and enter the IP address [and possibly
port] and the database name of the mysql db.
> ----- Original Message -----
> From: Doug Evans <hermit09@stripped>
> To: <win32@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
> said
> > 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
> that
> > 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.
> I
> > have the other driver available, if I should replace it.
> >
> > Regardless, this is where I run into trouble. I am assuming
> something
> should
> > 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.
> >
> > Doug
> >
> > Phil said:
> >
> > First off what you are trying works beautifully, eventually.
> >
> > Step1:
> > Get the mysql odbc drievrs from www.mysql.com
> >
> > Step 2:
> > Install said drivers.
> >
> > Step3:
> > Create the DSN
> >
> > Step4
> > 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.
> >
> >
>
>
>
> ---------------------------------------------------------------------
> Please check
> "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail
> win32-thread396@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.
>
