OK fixed.

I replaced double quotes by single quotes and the command worked.

Now the issue is: I am still able to create a new database (first radio button on the wizzard).

The resulting database allows the creation of tables. Interesting, the tables have limited data types (VARCHAR, CHAR, DECIMAL, BOOLEAN, LONGVARCHAR, DATE). Looks like Base is using a strange engine there...

What I am looking for (and it looks like I am asking to go back to OO 1.x), is to let the user create only databases that must access an external RDBMS...

I am not sure that this can be achieved...

Thank you

Olivier


Olivier Hallot escreveu:
Hi Frank

Thank you for your attention.

However here is the output of the commands suggested:

[EMAIL PROTECTED] program]# ../../ure/bin/regcomp -revoke -r /opt/openoffice.org/basis3.0/program/services.rdb -c "vnd.sun.star.expand:$OOO_BASE_DIR/program/libhsqldb2.so"

vnd.sun.star.expand:/program/libhsqldb2.so
revoke component 'vnd.sun.star.expand:/program/libhsqldb2.so' from registry '/opt/openoffice.org/basis3.0/program/services.rdb' succesful!

[EMAIL PROTECTED] program]# ../../ure/bin/regview services.rdb | grep hsqldb2
Data = "vnd.sun.star.expand:$OOO_BASE_DIR/program/libhsqldb2.so"


looks it did't worked... I tested and Base still has HSQLDB active.

It looks like $OOO_BASE_DIR get replaced in the first command but not in the rdb file...

Regards
Olivier


Frank Schönheit - Sun Microsystems Germany escreveu:
Hi Olivier,

So, is there a way to remove HSQLDB from Base and leave it only with the drivers for external access (JDBC, ODBC, etc...)? For instance, a switch in a config file that will nuke it?

The cleanest solution is to de-register the library which implements the
database driver for embedded HSQLDB (named libhsqldb2.so resp. hsqldb2.dll):

  > cd "OpenOffice.org/Basis 3.0/program"
  > ../../URE/bin/regcomp -revoke -r <full_path_to_services.rdb>
    -c "vnd.sun.star.expand:$OOO_BASE_DIR/program/libhsqldb2.so"

<full_path_to_services.rdb> is the full path to the services.rdb located
in the "Basis 3.0/program" folder (*not* the one in URE/misc!).

A subsequent

  > regview services.rdb | grep hsqldb2

(regview is also to be found in URE/bin) should not yield any output then.

After that, restart OOo, and your users won't be able to use embedded
HSQL anymore.

Ciao
Frank



------------------------------------------------------------------------

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

--
Olivier Hallot
Scinergy Consulting
Tel (021) 2224-3224, (021) 8822-8812
Rio de Janeiro, Brasil
http://www.scinergy.com.br
OpenOffice.org L10N project leader for Brazil


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to