百分问题,不够再加。急---PDA上的VB。NET开发的数据库连接问题。
在2003。NET上开发
Dim MyConnection As SqlCeConnection
Dim MyCommand As SqlCeCommand
Dim objDataAdapter As New SqlCeDataAdapter
Try
If Not File.Exists("\db3.cdb") Then
Dim sqlEngine As New SqlCeEngine("Data Source=\db3.cdb")
sqlEngine.CreateDatabase()
End If
MyConnection = New SqlCeConnection("Provider=Microsoft.SQLServer.OLEDB.CE.1.0;" & _
"Data Source=\db3.cdb")
..........
.........
MyConnection.Open()
Catch
MsgBox(Err.GetException().Message.ToString)
Finally
If Not MyConnection Is Nothing Then
MyConnection.Close()
MyConnection = Nothing
End If
End Try
运行时的Exception是“连接字符串provider中未知的连接选项”。请问如何解决。请给出正确的连接串。如果还有其他的注意事项,请一并说明,