数据库访问问题 [英] Database access issue

问题描述

我位于一台服务器上的ASP页面说服务器A和服务器B上的MSAccess数据库，并且我正在通过ASP文件连接此MSAccess数据库，但出现错误消息该连接无法用于执行此操作.该连接已关闭或在这种情况下无效."我已经做了所有但仍然有问题，但是当我将其与VB6.0连接时不会产生任何问题.

My ASP page located in one server say server A and MSAccess database located on server B and I am connecting this MSAccess database through ASP file but its giving error "The connection cannot be used to perform this operation. It is either closed or invalid in this context." I have did all but still have a problem but when i m connecting the same with VB6.0 it does not create any issue. can anyone help me please?

推荐答案

跟随此链接，我认为您的连接字符串中有错误.


http://www.connectionstrings.com/ [ ^ ]

follow this link, i think there is an error in your connection string.


http://www.connectionstrings.com/[^]

下面是我在asp页面中使用的连接字符串.

Below are the connection string used by me in my asp page.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverB\d

\Access Server\Access Databases\test.mdb;Persist Security Info=False"

\Access Server\Access Databases\test.mdb;Persist Security Info=False"

这篇关于数据库访问问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！