SQL Server - OLEDB - Access query: How open as read-only?

[TomasDill]

Hi!

We have SQL Server stored procedure that query Access database. We used OLEDB/Jet connection to Access database.
The problem is that OLEDB/Jet try to lock database when querying data, so we get error when other users opened database.
Question: How we should configure OLEDB, configure Jet or setup connection parameters for OLEDB in SQL Server to tell it to open database in read-only mode?



Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[culshaja]

One possible way is to use a DSN and use the ODBC driver. When creating the DSN on the client/server you can specify to open in exclusive mode.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[TomasDill]

We created DSN and seems no luck. Any other suggestions?

Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs