error in using udl

Question

Good day. Im having a problem in using udl to connect to a database.. The Code: Dim con As New OleDb.OleDbConnection() Dim com As New OleDb.OleDbCommand() Dim query As String = "select * from tbltest" con.ConnectionString = "File Name =c:/test.udl" com.Connection = con com.CommandText = query con.Open() con.Close() The udl is set to a sql dsn However, the code generates an exception.. An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll Additional information: The .Net Data OLE DB Provider(System.Data.OleDb) does not support the MSDASQL Provider, Microsoft OLE DB Provider for ODBC Drivers. thnx for ur help

Adam Erstelle · Answer

You have to change: Dim con As New OleDb.OleDbConnection() Dim com As New OleDb.OleDbCommand() to the odbc version. With the code as above you aren't using the odbc data provider you just downloaded and installed. The odbc data provider comes with help files that will get you pointed in the right direction. In the end you will want something like this (will vary depending on imports statements) Dim con As New OdbcConnection() Dim com As New OdbcCommand()

quietfulness · Answer

thnx for ur reply I have installed odbc_net.msi on my pc but still The .Net Data OLE DB Provider(System.Data.OleDb) does not support the MSDASQL Provider Microsoft OLE DB Provider for ODBC Drivers. How can i make this work any solutions would be very much appreciated. THnx..

Adam Erstelle · Answer

Based on the additional information you provide I would think that you need to use the ODBC .net Data provider. It can be downloaded from Microsoft. Its use is almost the exact same as the oledb data provider that comes with the .net framework.