On Fri, Jun 10, 2005 at 12:18:32PM +0000, Uwe Brauer wrote: > >>>>> "Steve" == Steve Langasek <[EMAIL PROTECTED]> writes:
> 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? With or without the macro. > 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. And which version is that? I have no problems with the current version of mysql-server in etch. > I would highly appreciate if you could just tell me about my > .odbc setting, which I obviously have to change. Not necessarily. You can also set username and password for your ODBC connection from within OOo's "Administrate Data Sources" dialog. > 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--- > - anonymous connection is now disabled, does this mean I have > to set in my odbc.ini user = oub? So, this doesn't appear to be an anonymous connection anyway (it's not anonymous if you specify a username), so I don't know what the problem is that you're describing. > - is the name conflict of [MySQL] in odbcinst.ini and > [MySQL-test] a problem. No. > [ISQL]ERROR: Could not SQLConnect > What can I do now? Why are you specifying a port number for a connection to a server on localhost? (The preferred connection method is to use a socket instead.) Why do you believe this has anything to do with anonymous connections, when you're specifying a username in the odbc.ini? What happens when you try to connect with the mysql commandline client? -- Steve Langasek postmodern programmer
signature.asc
Description: Digital signature