Re: Setting up Access 2000 to work using a mySQL db...

2001-02-16 Thread John Jensen

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




Re: Setting up Access 2000 to work using a mySQL db...

2001-02-15 Thread kentj

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