ColdFusion 8连接到远程访问MDB [英] ColdFusion 8 connect to remote access MDB

问题描述

我有一个Access MDB文件在不同的服务器，而不是我的ColdFusion服务器，有没有任何方式，我可以让ColdFusion 8能够通过网络连接到它？

I have an Access MDB file on a different server than my ColdFusion server, is there any way I can get ColdFusion 8 to be able to connect to it over the network?

推荐答案

您需要访问其他服务器的文件。然后，您可以以通常的方式连接到数据库。或者您可以制作数据库的副本，并通过网络将其传输到ColdFusion服务器。

You need file access to the other server. You can then connect to the database in the usual way. Or you can make a copy of the database and transfer it over the network to your ColdFusion server.

Jet MDB是基于文件访问的。您不能将它们作为数据库服务器AFAIK运行。要做到这一点，你需要将数据库扩大到一个实际的数据库服务器，如SQL Server Express，并以常规方式连接到它。

Jet MDB's are file accessed based. You can't run them as a database server AFAIK. To do that you would need to upsize the database to an actual database server like SQL Server Express, and connect to that in the usual way.

如果你有IIS运行远程服务器，你可以尝试这个黑客：

If you have IIS running on the remote server, you can try this hack:

Dim strSQL As String
 'assign connection string
strConString = "Provider=MS Remote;" & _
               "Remote Server=http://192.168.1.1;" & _
               "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=MyRemoteDB;Persist Security Info=False"
    'initialize connection object variable
Set adoConn = New ADODB.Connection
'open connection adoConn.Open strConString, "admin", ""

这篇关于ColdFusion 8连接到远程访问MDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！