Strange Calc + database + different user Problem

[sleepymish]

Hi,

I have a linux box w/ RedHat 7 and OpenOffice.org 1.1. I'm trying to use Calc to access a MySQL database through ODBC.

OpenOffice.org is installed with the network version and each user of the linux box installed their own client version. I believe every user uses the same odbc.ini and odbcinst.ini file for the data sources and/or drivers. Sorry if I dont' make sense, I'm new to the database world. Anyway, when I select data source URL under tools -> data source, different database comes up depending upon what user account I'm logged in the linux box.

Here's my odbc.ini file:

#
# odbc.ini configuration for MyODBC and MyODBC 3.51 Drivers
#

[ODBC Data Sources]

myodbc = MySQL ODBC 2.50 Driver DSN
myodbc3 = MySQL ODBC 3.51 Driver DSN
MySQL-test = MySQL ODBC 3.51 Driver DSN


[myodbc]
Driver = /usr/local/lib/libmyodbc.so
Description = MySQL ODBC 2.50 Driver DSN
SERVER = localhost
PORT =
USER = root
Password =
Database = test
OPTION = 3
SOCKET =


[test]
Driver = /usr/local/lib/libmyodbc3.so
Description = MySQL ODBC 3.51 Driver DSN
SERVER = localhost
PORT =
USER = root
Password =
Database = test
OPTION = 3
SOCKET =

[MySQL-test]
Description = MySQL database test
Driver = myodbc3
Server = localhost
Database = test
Port =
user = root

[Default]
Driver = /usr/local/lib/libmyodbc3.so
Description = MySQL ODBC 3.51 Driver DSN
SERVER = localhost
PORT =
USER = root
Password =
Database = test
OPTION = 3
SOCKET =

Here's the list of data sources my account see:
Default
myodbc
MySQL-test
test

Here's the list of data sources my coworker's account see:
Default
myodbc
myodbc3

It's strange b/c my coworker's OpenOffice.org doesn't see the updated/modified odbc.ini file. Anybody has any idea why? The root user see the same list as my account.

A second strange thing is that my account can't use the [default] data source while my coworker's account could use it. Anybody has any ideas?


Regards,

Michelle