简单问题,关于数据库连接.

[szheto]

本人在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

[暗石绿]

你把longfung.mdb 复制到 D:盘

试试

myconnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:\longfung.mdb;"

[nmlvjun]

没有myconnection.open()

[dzvsyt]

对，没有myconnection.open()

[szheto]

加上去了,myconnection.open()
问题同样出现.

[szheto]

"ISAM"是什么东西呀?在winform里都没有问题呀.刚学webform就出问题,请高手帮帮忙呀?

[greennetboy]

我记得在字符串中\是作为转译字符的吧，搂主的"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;"或者"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:\\Documents and Settings\\Administrator\\My Documents\\Visual Studio Projects\\longfung\\longfung.mdb;"吧，呵呵，小弟不懂VB,但转译字符好像C++里也是'\'，如果小弟错了的话，海涵！海涵！

[暗石绿]

我怀疑是 D:\Documents and Settings
路径里面有空格造成了。
所以让你把数据库放到 D:盘根目录下测试一下呀。

怎么不试试？

[szheto]

xrascal(横刀夺爱)
楼上说的,我试过了,一样不行呀.
greennetboy(我的老婆叫静静
这位楼上说的,我也试过了,一样不行.

是不是我的vs.net有问题?

[szheto]

connstr = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=D:\longfung.mdb;"
把以上语句换成以下语句却OK.
connstr = "provider=sqloledb;server=jacky;uid=sa;pwd=;database=ERP DATA;"

[vzxq]

?

[暗石绿]

是Data Source而不是DataSource

[coley]

用VS自带连接查下呢?