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

Attachment: signature.asc
Description: Digital signature

Reply via email to