>>>>> "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]

Reply via email to