本人在Module1里定义一个function用于连接数据库,却出现错误,"找不到可安装的ISAM".
代码如下:
Imports System.Data
Imports System.Data.OleDb
Module Module1
Public myconnection As New OleDbConnection
Public mydataset As New DataSet
Public mydataadapter As OleDbDataAdapter
Public mydatacommandbuilder As OleDbCommandBuilder
Public Function executesql(ByVal str As String, ByVal table As String)
myconnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\longfung\longfung.mdb;"
mydataadapter = New OleDbDataAdapter(str, myconnection)
mydatacommandbuilder = New OleDbCommandBuilder(mydataadapter)
mydataadapter.Fill(mydataset, table)
myconnection.Close()
myconnection = Nothing
End Function
End Module
代码如下:
Imports System.Data
Imports System.Data.OleDb
Module Module1
Public myconnection As New OleDbConnection
Public mydataset As New DataSet
Public mydataadapter As OleDbDataAdapter
Public mydatacommandbuilder As OleDbCommandBuilder
Public Function executesql(ByVal str As String, ByVal table As String)
myconnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\longfung\longfung.mdb;"
mydataadapter = New OleDbDataAdapter(str, myconnection)
mydatacommandbuilder = New OleDbCommandBuilder(mydataadapter)
mydataadapter.Fill(mydataset, table)
myconnection.Close()
myconnection = Nothing
End Function
End Module
问题同样出现.
能编译通过么?正确的应该是@"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\longfung\longfung.mdb;"或者"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:\\Documents and Settings\\Administrator\\My Documents\\Visual Studio Projects\\longfung\\longfung.mdb;"吧,呵呵,小弟不懂VB,但转译字符好像C++里也是'\',如果小弟错了的话,海涵!海涵!
路径里面有空格造成了。
所以让你把数据库放到 D:盘根目录下测试一下呀。怎么不试试?
楼上说的,我试过了,一样不行呀.
greennetboy(我的老婆叫静静
这位楼上说的,我也试过了,一样不行.是不是我的vs.net有问题?
把以上语句换成以下语句却OK.
connstr = "provider=sqloledb;server=jacky;uid=sa;pwd=;database=ERP DATA;"