连接字符串 [英] Connection String

问题描述

我正在创建一个将由iis在我的计算机上运行的asp页面。但是问题

是Web服务器上的数据库。我似乎无法连接到

为它工作，虽然在这里他的连接和错误。请帮忙。


连接：" Provider = Microsoft.Jet.OLEDB.4.0;数据

来源= http：//n.1asphost.com /WStoreyII/PIMP.mdb"


错误：Microsoft JET数据库引擎（0x80004005）

不是有效的文件名。

/Default.asp，第40行

谢谢，


WStoreyII

I am making a asp page that will run on my computer by iis. But the problem
is the database in on a web server. I can not seem to get the connection to
work for it though here his the connection and the error. Any help please.

Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

Error: Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/Default.asp, line 40

Thanks,

WStoreyII

推荐答案

使用Access时，它必须与访问它的代码驻留在同一台机器上，并且连接字符串中的路径必须是本地物理

路径。不能跨网络共享数据库数据。你可能希望升级到免费的MSDE（MS数据引擎），这是一个单独的用户许可版本的SQL Server。


" WStoreyII" < WS ******* @ discussions.microsoft.com>在消息中写道

新闻：5C ********************************** @ microsof t.com ...

When using Access, it must reside on the same machine as the code that is
accessing it and the path in the connection string must be a local physical
path. Access is not made for sharing database data across networks. You
may wish to upgrade to the free MSDE (MS Data Engine), which is a single
user licensed version of SQL Server.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...

我正在创建一个将由iis在我的计算机上运行的asp页面。但是问题
是Web服务器上的数据库。我似乎无法获得连接
为它工作，虽然在这里他的连接和错误。任何帮助
请。

连接：Provider = Microsoft.Jet.OLEDB.4.0;数据
Source = http://n.1asphost.com/WStoreyII/PIMP .mdb"

错误：Microsoft JET数据库引擎（0x80004005）
不是有效的文件名。
/Default.asp，第40行

谢谢，

WStoreyII

I am making a asp page that will run on my computer by iis. But the
problem
is the database in on a web server. I can not seem to get the connection
to
work for it though here his the connection and the error. Any help
please.

Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

Error: Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/Default.asp, line 40

Thanks,

WStoreyII

尝试使用本地路径，例如Source = c：\database \ PIMP.mdb ;


" WStoreyII" < WS ******* @ discussions.microsoft.com>在消息中写道

新闻：5C ********************************** @ microsof t.com ...

Try using the local path such as "Source=c:\database\PIMP.mdb"

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...

我正在创建一个将由iis在我的计算机上运行的asp页面。但是问题
是Web服务器上的数据库。我似乎无法获得连接
为它工作，虽然在这里他的连接和错误。任何帮助
请。

连接：Provider = Microsoft.Jet.OLEDB.4.0;数据
Source = http://n.1asphost.com/WStoreyII/PIMP .mdb"

错误：Microsoft JET数据库引擎（0x80004005）
不是有效的文件名。
/Default.asp，第40行

谢谢，

WStoreyII

I am making a asp page that will run on my computer by iis. But the
problem
is the database in on a web server. I can not seem to get the connection
to
work for it though here his the connection and the error. Any help
please.

Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

Error: Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/Default.asp, line 40

Thanks,

WStoreyII

如果您尝试跨站点从Access数据库获取数据（在
$ b上） $ b不同的机器），你会想调查在

远程站点上调用Web服务。


Web服务将从中获取数据访问并将其返回到您的页面。


" WStoreyII" < WS ******* @ discussions.microsoft.com>在消息中写道

新闻：5C ********************************** @ microsof t.com ...

If you are trying to get data from an Access database across sites (on
different machines), you''ll want to investigate calling a Web service on the
remote site.

The Web service will fetch the data from Access and return it to your page.

"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:5C**********************************@microsof t.com...

我正在创建一个将由iis在我的计算机上运行的asp页面。但是问题
是Web服务器上的数据库。我似乎无法获得连接
为它工作，虽然在这里他的连接和错误。任何帮助
请。

连接：Provider = Microsoft.Jet.OLEDB.4.0;数据
Source = http://n.1asphost.com/WStoreyII/PIMP .mdb"

错误：Microsoft JET数据库引擎（0x80004005）
不是有效的文件名。
/Default.asp，第40行

谢谢，

WStoreyII

I am making a asp page that will run on my computer by iis. But the
problem
is the database in on a web server. I can not seem to get the connection
to
work for it though here his the connection and the error. Any help
please.

Connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=http://n.1asphost.com/WStoreyII/PIMP.mdb"

Error: Microsoft JET Database Engine (0x80004005)
Not a valid file name.
/Default.asp, line 40

Thanks,

WStoreyII

这篇关于连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！