读书人

2005连接数据库有关问题啊

发布时间: 2012-01-23 21:57:28 作者: rapoo

求助2005连接数据库问题啊~
Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection( "Provider = MicroSoft.jet.OLEDB.4.0;DataSource=|DataDirectory|\DataManage.mdb;Jet OLEDB;Database password = admin ")

Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand( "SELECT name, pws, purview FROM nameload where name = ' " + strNAME + " '; ")

conn.Open()

Dim rd As OleDb.OleDbDataReader

rd = cmd.ExecuteReader()

name = rd.GetData(0).ToString

pws = rd.GetData(1).ToString


到conn.Open()就出错,显示的信息是:找不到可安装的ISAM

[解决办法]
确认一下连接字符串
http://www.connectionstrings.com/?carrier=sqlserver2005
[解决办法]
Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection( "Provider = MicroSoft.jet.OLEDB.4.0;DataSource=|DataDirectory|\DataManage.mdb;Jet OLEDB;Database password = admin ")
______________________________
不是连接SQL 2005的字符串
[解决办法]
DataSource改成Data Source

读书人网 >VB Dotnet

热点推荐