v**m
发帖数: 242 | 1 【 以下文字转载自 Database 讨论区,原文如下 】
发信人: vbnm (小兔不乖), 信区: Database
标 题: how to link to remote access database?
发信站: The unknown SPACE (Fri May 11 15:42:20 2001) WWW-POST
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 D | a*p
发帖数: 62 | 2 The simpliest way to make it working is mounting server2's
driver virtually as like G: in server1, and configure ODBC
on server1
this will cost lots of resources and it is very very slow.
Another way, I know there're some third part ODBC connecting
server which you might be able to use. Or maybe you can use
mySQL or something like SQL server.
【在 v**m 的大作中提到】
: 【 以下文字转载自 Database 讨论区,原文如下 】
: 发信人: vbnm (小兔不乖), 信区: Database
: 标 题: how to link to remote access database?
: 发信站: The unknown SPACE (Fri May 11 15:42:20 2001) WWW-POST
: 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:
| v**m
发帖数: 242 | 3 I try to use the first method, but always some error message pops up.
Do you know where I can find some examples? Thank you very much!
【在 a*p 的大作中提到】
: The simpliest way to make it working is mounting server2's
: driver virtually as like G: in server1, and configure ODBC
: on server1
: this will cost lots of resources and it is very very slow.
: Another way, I know there're some third part ODBC connecting
: server which you might be able to use. Or maybe you can use
: mySQL or something like SQL server.
|
|
