Connect to a database with with a odbc connection

[gunnar66]

Hi Try to connect to a database with a odbc connection (system dsn) Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; DSN=NRS" Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString) This will not work. why? I have tried this, this worked ok Dim connectionString As String ="Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\Inetpub\wwwroot\db1.mdb" Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString) What should I do to get this right? I am useing ASP.NET and web matrix Regards Gunnar

[minhpc_bk]

Hi there, If you want to use the system dsn, then you should go for the OdbcConnection instead of the OleDbConnection. You can take a look at the System.Data.Odbc Namespace[^]

[gunnar66]

Hi Ok I will give it a try. But that is, OleDbConnection will not work with system dsn? Thx

[minhpc_bk]

AFAIK the OleDbConnection in the .Net framework is not typically used with the system dns.