ODBC连接:未发现数据源名称并且未指定默认驱动程序(在线等待)
xiaye 2002-12-04 07:01:35 01 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
02 Dim ConnectionString, SQLString As String
03 Dim MyConnection As Microsoft.Data.Odbc.OdbcConnection
04 Dim MyCommand As Microsoft.Data.Odbc.OdbcCommand
05 Dim DR As Microsoft.Data.Odbc.OdbcDataReader
06
07 ConnectionString = "DSN=test1"
08 SQLString = "select * from EmpList"
09
10 MyConnection = New Microsoft.Data.Odbc.OdbcConnection(ConnectionString)
11
12 MyCommand = New Microsoft.Data.Odbc.OdbcCommand()
13 MyCommand.CommandType = CommandType.Text
14 MyCommand.CommandText = SQLString
15 MyCommand.Connection = MyConnection
16 MyCommand.Connection.Open()
17 DR = MyCommand.ExecuteReader(CommandBehavior.Default)
18
19 MyDataGrid.DataSource = DR
20 MyDataGrid.DataBind()
21 End Sub
上述代码总是报错:ODBC未发现数据源名称并且未指定默认驱动程序
源文件: ..\default.aspx.vb 行: 55
Microsoft.odbc.data.dll引用我已经加上了,而且根本就没有行55,很奇怪。