OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Strange Calc + database + different user Problem

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
sleepymish
Newbie
Newbie


Joined: 15 Jan 2004
Posts: 4

PostPosted: Tue Feb 03, 2004 12:19 pm    Post subject: Strange Calc + database + different user Problem Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group