Am Freitag, den 10.06.2005, 18:02 +0200 schrieb Uwe Brauer:
> >>>>> "Marc" == Marc Santhoff <[EMAIL PROTECTED]> writes:
>
>
> Marc> What macro? However, normally if you use somthing like:
>
> To be found in
> http://dba.openoffice.org/howto/IgnoreDriverPrivileges.html
>
> Since this is or seems to be well known bug in the myodbc driver.
Ah, I see.
> Marc> oEnv = createUnoService("com.sun.star.sdb.DatabaseContext")
> Marc> oConnection =
> Env.getByName(sDBName).getConnection("uwe","secret")
>
> Marc> the name is the display name in the database browser (the
> Marc> window opening on F4).
>
> Ok which is not the same of my mysql database, which is MySQL-test,
> right, then the macro *DOES* not work and I will send a bug report. I
> just don't get any write access to my MySQL data base.
In your case "MySQL-test" is the odbc-name which is called DSN in the
Microsoft world. The name in OOo is something else (although you can put
the same name there for simplicity). I'm talking about OOo1.1.x now, in
1.9.x this may have changed:
Select Menu "View" and then "Datasources". The strings in the left part
of the appearing Window are registered Databases in OOo. For the macro
setting the IgnoreDriverPrivileges stuff you should use that name, too.
So the first steps are:
- Menu "Tools", "Data Sources"
- create a new database in OOo
- if your version needs it, run the macro
>
> Marc> If you have made a permanent connection shown as "Uwes Big
> Marc> Data Barrel" you have to do this before calling the liones
> Marc> above:
>
> Marc> sDBName = "Uwes Big Data Barrel"
>
>
> I am now totally confused that seems to me a OO macro language, this
> is supposed to be executed where?
No, not at all. I did not know what macro you were talking about and
showed some sample code.
HTH,
Marc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
