how to link to remote access database? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

how to link to remote access database?

how to link to remote access database?# Database - 数据库

v*m2001-05-11 07:05

1 楼

My web page is in server1. The access database is in
server2.
How can I connect to the database on server2.
Now I am doing is:
objConn.Open "DSN=testDB;UID=;PWD="
and the error message is:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e4e'
Operation was canceled."
Any idea, how to solve it. Thanks so..... much!!!
BTW, the DSN is system DSN.

a*a2001-05-11 07:05

2 楼

how about change UID=; to "UID=Admin;"

【在 v**m 的大作中提到】

: My web page is in server1. The access database is in
: server2.
: How can I connect to the database on server2.
: Now I am doing is:
: objConn.Open "DSN=testDB;UID=;PWD="
: and the error message is:
: "Microsoft OLE DB Provider for ODBC Drivers error '80040e4e'
: Operation was canceled."
: Any idea, how to solve it. Thanks so..... much!!!
: BTW, the DSN is system DSN.

v*m2001-05-11 07:05

3 楼

got the same error message

【在 a*****a 的大作中提到】

: how about change UID=; to "UID=Admin;"

a*a2001-05-11 07:05

4 楼

how about use JET provider instead of "OLEDB Provider for
ODBC"?
your connection string would be
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\server2\someshare\test.mdb"

【在 v**m 的大作中提到】

: got the same error message

v*m2001-05-11 07:05

5 楼

now I got the different error message:
Microsoft JET Database Engine error '80004005'
The Microsoft Jet database engine cannot open the file
'\\server2\someshare\test.mdb'. It is already opened
exclusively by another user, or you need permission to view
its data.
any clue?

【在 a*****a 的大作中提到】

: how about use JET provider instead of "OLEDB Provider for
: ODBC"?
: your connection string would be
: "Provider=Microsoft.Jet.OLEDB.4.0;Data
: Source=\\server2\someshare\test.mdb"

a*a2001-05-11 07:05

6 楼

JET db can only be used by one process at any time.
Try to close any program using this access file. Then run ur
web page again.

【在 v**m 的大作中提到】

: now I got the different error message:
: Microsoft JET Database Engine error '80004005'
: The Microsoft Jet database engine cannot open the file
: '\\server2\someshare\test.mdb'. It is already opened
: exclusively by another user, or you need permission to view
: its data.
: any clue?

v*m2001-05-11 07:05

7 楼

I don't think there is any other program is using this
access file.
My web page is on server1, database on server2. And in order
to access to
server2, I assign a new user named IUSR_Server1, plus a
password(it's required).
However, when user visit server1 anonymously, they don't
have password at all.
So do you think that's the problem? Thank you so....much!!!
【在 amnesia (Hua Hi Lo Ho) 的大作中提到: 】

a*a2001-05-11 07:05

8 楼

I am out of clue now:( try posting your question to some
newsgroups?

【在 v**m 的大作中提到】

: I don't think there is any other program is using this
: access file.
: My web page is on server1, database on server2. And in order
: to access to
: server2, I assign a new user named IUSR_Server1, plus a
: password(it's required).
: However, when user visit server1 anonymously, they don't
: have password at all.
: So do you think that's the problem? Thank you so....much!!!
: 【在 amnesia (Hua Hi Lo Ho) 的大作中提到: 】