A universe on another server?

[flaviooooo]

Hi,

I don't know much about BO, but I'll try to explain my problem.
We have a BO server that we can reach through a webinterface. We would like to query on Accessdatabases.

Now we have an ODBC connection named 'clients local'. This points to a database that we copied to the harddrive of the server. This ODBC is connected in a universe 'clients local'

When we open this universe through the webinterface, the queries run smoothly.

Now I've created another ODBC connection named 'clients common'. This points to a database on our file server.
Another universe is created with that ODBC 'clients common'

When I try to run a query on this universe though, it runs extremely slow and just before it's about to reach the end, throws me this error:
Database error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view it's data. Contact your administrator or database supplier for more information (Error: WIS 10901)


HELP

 

[nimmy99]

Use the following ODBC driver for DSN (CONTROL panel)
MicroSoft Access driver(*.mdb)
I think you are using
Driver do MicroSoft Access(*.mdb)

Delete the existing Data Source Name and recreate it using the MicroSoft Access driver(*.mdb)

 

[flaviooooo]

No, sorry...

It has Microsoft Access Driver specified

 

[skrandel]

How are you mapping to it. Are you using a drive letter or UNC.

Also, let's face it, Access is not a very good database for sharing. The message you are getting could be due to someone locking the database. Are you using id's and passwords with it?

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[flaviooooo]

Hi,

I tried both with mapping letter and UNC, both give me the same error.

I use a test-database, so no one is locking the mdb.

 

[skrandel]

Take BO out of the picture. Can you access the database successfully from any other application running on the server. Try MSQuery.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[flaviooooo]

hehe, I think we can better discuss this further in the Business Objects Board. Else we are just talking in doubles