v**m 发帖数: 242 | 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*****a 发帖数: 438 | 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**m 发帖数: 242 | 3 got the same error message
【在 a*****a 的大作中提到】 : how about change UID=; to "UID=Admin;"
|
a*****a 发帖数: 438 | 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**m 发帖数: 242 | 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*****a 发帖数: 438 | 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**m 发帖数: 242 | 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*****a 发帖数: 438 | 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) 的大作中提到: 】
|