求助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