>>>>> "Uwe" == Uwe Brauer <[EMAIL PROTECTED]> writes:
Hello
I just want to let you know that I solved my problem. Since it might
occur to other Debian users, a short summary.
- The main problem is that there are *two* problems, on in
the mysql setting the other in the libmyodbc driver. (I was
aware of the second not on the first).
- The libmyodbc driver and the R/O problem: Using the macro
mentioned in earlier mails (inserting the Name of the data
base one has chosen in OO's data source) works after
restarting OO, if I am root.
- the problem is that for other users this does not work. The
reason for this (strange) behaviour has to do with the
mysql setting. In older version, it was possible for _any_
user to have anonymous access to the default data base,
called test. So the following .odbc.ini setting was fine:
--8<------------------------schnipp------------------------->8---
[MySQL-test]
Description = MySQL database test
Driver = MySQL
Server = localhost
Database = test
Port = 3306
Socket =
Option =
Stmt =
--8<------------------------schnapp------------------------->8---
However in recent version of mysql, the anynomous access
was taken away. However, and that was the problem, none of
the users had access to the default data base.
This can be checked by the command mysqlaccess user database.
- So all I had to was to give myself the access to the data
base I wanted (and created) user the command
mysql_setpermission and mysqladmin for creating new data
base.
Then of course the .odbc.ini file has to be something like this,
--8<------------------------schnipp------------------------->8---
[MySQL-test]
Description = MySQL database test
Driver = MySQL
Server = localhost
user = oub
Database = test
Port = 3306
Socket =
Option =
Stmt =
[MySQL-MatIQ]
Description = MySQL database test
Driver = MySQL
Server = localhost
user = oub
Database = MatIQ
Port = 3306
Socket =
Option =
Stmt =--8<------------------------schnapp------------------------->8---
Thats all.
Regards
Uwe Brauer
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
