Allow other host

2006-08-24 Thread Andreas Moroder
Hello, I have a mysql DB running on a Windows XP machine. I can access it locally via mysql command, I have also a ODBC driver installed and the test says it works ok. When I try to connect from a remote host via JDBC I get the error message that this host is not allowed to access the db.

#deleted records in access

2006-08-24 Thread Andreas Moroder
Hello, when I open mysql table with access 97 using the latet mysql-odbc driver ( 3.51.12 ) I see only deleted records. What is happening ? I found many posts about this problem, but I can not, as told in this posts, add timestamp or other fields because this tables are used by a

Re: #deleted records in access

2006-08-24 Thread Andreas Moroder
Daniel Kasak schrieb: Andreas Moroder wrote: Hello, when I open mysql table with access 97 using the latet mysql-odbc driver ( 3.51.12 ) I see only deleted records. What is happening ? I found many posts about this problem, but I can not, as told in this posts, add timestamp or other fields

Re: #deleted records in access

2006-08-24 Thread Andreas Moroder
Daniel Kasak schrieb: Andreas Moroder wrote: Daniel Kasak schrieb: You won't break anything by adding a timestamp field. Trust us :) And no, there is no way around this problem other than adding a timestamp field. From the 'mysql' command-line client, do: ... where DATABASE_NAME