>>>>> "Steve" == Steve Langasek <[EMAIL PROTECTED]> writes:
[snip] Steve> Right, this does seem to be trivially reproducible in Steve> sarge. It looks like there's been a change in OpenOffice Steve> that triggered it, rather than a regression in libmyodbc Steve> itself; even installing the woody version of libmyodbc Steve> doesn't get me read/write table access with the sarge Steve> version of OOo. Your are talking about using the macro, no? [snip] >> Sorry, what I meant, I could *NOT* install 2.50 from oldstable >> the command >> apt-get install -t oldstable libmyodb >> installed version 3.51.09 sorry for the typo. Steve> # apt-get install libmyodbc=2.50.39-3 Thanks for that one. Steve> works for me. It appears that the Release file for woody still says Steve> "stable" instead of "oldstable", so selecting by release doesn't work Steve> currently. [snip] Steve> And downgrading to anything earlier than 3.51.09 would also break Steve> compatibility with MySQL server 4.1. Ok I was afraid of that, I could try the MySQL server which would work for the 2.50 driver though, but maybe this would not work neither (maybe I should start to use pinning.....) Now it turns out that I have a serious connection problem. The latest upgrade of mysql which I downloaded yesterday, does not allow anonymous connection anymore. So right now I can't do any testing anymore on the Laptop with the most recent Debian version. I would highly appreciate if you could just tell me about my .odbc setting, which I obviously have to change. I am asking you this since I am in a state of desperation (strictly speaking that question is a little off topic). In recent years I followed the instructions found in www.unixodbc.org/doc/OOoMySQL.pdf so I used the following .odbc.ini (in my home dir) and --8<------------------------schnipp------------------------->8--- [MySQL-test] Description = MySQL database test Driver = MySQL Server = localhost user = oub Database = test Port = 3306 Socket = Option = Stmt = --8<------------------------schnapp------------------------->8--- ocbcinst.ini files in /etc --8<------------------------schnipp------------------------->8--- Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup = /usr/lib/odbc/libodbcmyS.so FileUsage = 1 --8<------------------------schnapp------------------------->8--- Now debian overwrites the file in /etc by --8<------------------------schnipp------------------------->8--- [MySQL] Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup = /usr/lib/odbc/libodbcmyS.so CPTimeout = CPReuse = FileUsage = 1 --8<------------------------schnapp------------------------->8--- - anonymous connection is now disabled, does this mean I have to set in my odbc.ini user = oub? - is the name conflict of [MySQL] in odbcinst.ini and [MySQL-test] a problem. I changed [MySQL-test] to [MySQL] in my .odbc.ini file but still I get the message: [ISQL]ERROR: Could not SQLConnect What can I do now? Thanks Uwe -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]