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.
|
|