Asp.net Forum

Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds

How to use DSN in asp.net

  Asked By: Adelisa    Date: Feb 09    Category: Asp.net    Views: 1103

I use datareader in datagrid but could not use file dsn in connection
string DSN=mydata;....

Could anybody help me out with small example ?



1 Answer Found

Answer #1    Answered By: Freda Lane     Answered On: Feb 09

shows correct Access connection string.

is small datareader  example.

Just search for SQLClient replace with OLEDB.

DSNs actually imply an ODBC connection which is slower than SQLClient or OLEDB. So avoid DSNs. A lot of Classic asp  programmers using DSNs were getting worse pefrformance via ODBC instead of OLEDB and never knew it. ASP.net wants to end people accidentally using ODBC without knowing it.

Didn't find what you were looking for? Find more on How to use DSN in asp.net Or get search suggestion and latest updates.