Kentj,
I have a setup that differs in just a few ways. My server is Redhat7
Linux, on the Internet. It appears from the IP address that you gave,
that yours in on an intranet. Judging by a lot of messages I have
seen here, and by my own experience, a similar connection on the
Internet is far less reliable, even if correctly configured. Access97
appears to be less of a problem, but I solved my problem by
eliminating Access and using PhpMyAdmin.
On 15 Feb 2001, at 14:35, kentj wrote:
> I have an Access 2000 Db on a Win98 system with tables linked to a
> MySql23.32-1 database on Suse Linux 7.0 using the latest MyODBC with a
> System DSN specifying anyname.dsn, the IP of 192.168.2.5 for the host,
> the database name of "metrics" and port 3306. I had to setup the
> privileges very carefully in the MySQL user table and to spell my
> database name correctly in order to make it work.
>
> Rodrigo Antonio Reyes Cabrera wrote:
>
> > Hi
> > I am using Access 2000 and I would like to configure it in order to
> > use it as a interface to a mySQL db. Is this possible? I think it
> > is, but I haven't been able to get it done so far. I am using the
> > myODBC driver, but I get error messages when I try to import or link
> > a table from my db into Access. Nevertheless, I can connect from PHP
> > using the same ODBC connection. What could be wrong?
> >
> > Rodrigo
> >
> > --------------------------------------------------------------------
> > - Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
> > before posting. To request this thread, e-mail
> > [EMAIL PROTECTED]
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail [EMAIL PROTECTED] instead.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
John Jensen
520 Goshawk Court
Bakersfield, CA 93309
661-833-2858
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php