Hi All I have a desktop box that is set up with drawers where I can install different operating systems and work on configuration and setup as time permits without disrupting normal operations during the day. Thank goodness other wise I would be reallypulling my hair out.
Oh thanks for the copy of "How-to Configure ODBC on Linux with MySQL and OpenOffice.org 1.1.x. I also have a book about MySQL which has given me a number of MySQL test for operation verification. Currently I have the following: For MySQL I have MySQL Server working. I have created a database called 'testdb' with user 'testuser' and password 'testpw'. I can access my 'testdb' from a user terminal by: mysql -utestuser -ptestpw. I have created a table 'testtable' in 'testdb'. I have manually configured /etc/odbcinst.ini and /etc/odbc.ini. /etc/odbcinst.ini contains the following: ---------- [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/libodbcpsql.so.2 Setup = /usr/lib/libodbcpsqlS.so.1 FileUsage = 1 [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libodbc.so Setup = /usr/lib/libodbc.so FileUsage = 1 [MySQL ODBC 3.51 Driver] Description = ODBC for MySQL DRIVER = /usr/lib/libmyodbc3S.so SETUP = /usr/lib/libmyodbc3S.so FileUsage = 1 /etc/odbc.ini contains the following: ---------- [MySQL-test] Description = MySQL database test Driver = MySQL Server = localhost Database = test Port = 3306 Socket = Option = Stmt = [MySQL-testdb] Description = MySQL database testdb Driver = MySQL Server = localhost Database = testdb Port = 3306 Socket = Option = Stmt = ---------- Even though I had configured the above files manually I stillentered Graphics Configuration of ODBC using ODBCConfig by going to a root terminal and issuing the command ODBCCongig. I got the configuration window with User DSN, System DSN, File DSN, Drivers et. The appearance was much the same for the opening window and following the Howto I switched to the Drivers window which appeared to function as per the Howto so I will not linger here. Switching to the System SSN window the appearance was much the same but with 3 entres instead of 2 as one would suspect from the /etc/odbcinst.ini file. Following instructions I then clicked 'Add' and got the screen to select a driver to use or add a new one. I highlighted MySQL and clicked OK. I got an error message: Could not construct a property list for MySQL ---------- I next went to Open Office database Wizard to see what would hoppen. Connect to an existing database ODBC Chose MySQL-testdb Set User Name to 'testuse' Checked Pass Word Required Clicked 'Test Connection' Entered Password 'testpw' Clicked OK Got Error Message:: Error while connecting to source [unixODBC][Driver Manager] Driver' SQLAllocation Handler on SQL_HANDLER_HENV failed ---------- Went back to Graphics Configuration of ODBC using ODBCConfig and revisited 'System DSN' 'Select the Driver to use or Add a new one' and reselected MySQL and clicked OK. Graphic Configuration window closed. I did not get the window that described the MySQL driver either time. ---------- Assistance would be appreciated. Thanks SOTL PS: My appologies if I am posting on the wrong list as I am confused as to this being an OpenOffice issue, a MySQL issue, or a Mandrake issue. If this is the wrong list please advise . --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
