By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,847 Members | 2,321 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,847 IT Pros & Developers. It's quick & easy.

Help, Connection to Access Database

P: n/a
Hi,all
I met one problem of connecting Access database in asp.net web program.
I use ODBC link to Access, the connection string like
"PWD=12345;DSN=QADLinkMDB;DriverId=25;MaxBufferSiz e=2048;FIL=MS
Access;PageTimeout=5;UID=apiprogram"

while runing program, system prompt error: the workgoup file is missing
or open exculsive by anthor user.

My access database located in another server,if I copy the Access
database to my local place, the program run without problem, but now always
display above error.

Then what's the problem? Anyone could give me a hand? Thanks!
May 11 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Randy" <ra******@cn.vptech.comwrote in message
news:uD****************@TK2MSFTNGP04.phx.gbl...
I met one problem of connecting Access database in asp.net web program.
I use ODBC link to Access, the connection string like
"PWD=12345;DSN=QADLinkMDB;DriverId=25;MaxBufferSiz e=2048;FIL=MS
Access;PageTimeout=5;UID=apiprogram"
Firstly, why are you still using ODBC to connect to a Jet database and not
OleDb...?
while runing program, system prompt error: the workgoup file is missing
or open exculsive by anthor user.
That almost certainly means exactly what it says...

If you browse the remote folder containing the Jet database, does the
workgroup file actually exist...?

If so, hs the Jet database been opened exclusively by someone else...?

--
http://www.markrae.net

May 11 '07 #2

P: n/a
Mark
My condition is:
my actual data stored in Progress database on server1, I use Access
database links to Progress database by linked table through ODBC manner,
Access database located on server2, then I run web application to read
data from Access database.

I tried to connect database using both Jet OLEDB and ODBC method.
For ODBC, it will not work while the databae located on another server,
and prompt "workgroup file is missing" error.
For Jet OLEDB, it works well when executing simple query, but failed
when doing complicated query, and prompt "ODBC call failed",

So, now neither of the above two link method do not works perfect.
I wonder, what shall I do?

"Mark Rae" <ma**@markNOSPAMrae.net>
??????:eo**************@TK2MSFTNGP04.phx.gbl...
"Randy" <ra******@cn.vptech.comwrote in message
news:uD****************@TK2MSFTNGP04.phx.gbl...
> I met one problem of connecting Access database in asp.net web
program.
I use ODBC link to Access, the connection string like
"PWD=12345;DSN=QADLinkMDB;DriverId=25;MaxBufferSi ze=2048;FIL=MS
Access;PageTimeout=5;UID=apiprogram"

Firstly, why are you still using ODBC to connect to a Jet database and not
OleDb...?
>while runing program, system prompt error: the workgoup file is missing
or open exculsive by anthor user.

That almost certainly means exactly what it says...

If you browse the remote folder containing the Jet database, does the
workgroup file actually exist...?

If so, hs the Jet database been opened exclusively by someone else...?

--
http://www.markrae.net

May 15 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.