Drivers for bank connection via ASP Classic

Asked

Viewed 326 times

1

Good afternoon. In the Connection string of our web application, we always use the Driver {SQL Server}. We have other options like {SQL Server Native Client 11.0}. What are the decision-making criteria for choosing one or the other? Is there an article that explains each type?

Grateful.

sql-server asp connection

2 answers

1


You should also consider your choice of drivers based on other factors like:

  • this driver is reliable and has been well tested?
  • this driver is compatible with my infrastructure and architecture?
  • this driver offers the features my application needs?
  • this driver has some license problem?
  • this driver has the best performance available

Generally, when choosing between an OLEDB driver and an ODBC driver, I prefer the OLE driver because it is more performatic and reliable

More information here: http://help.adobe.com/en_US/dreamweaver/cs/using/WSc78c5058ca073340dcda9110b1f693f21-7a11a.html

http://serolmar.wordpress.com/2008/03/05/ligacao-a-bases-de-dados-odbc-e-ole-db-e-ado/

0

Well, the newer the driver, the more versions of SQL Server your application will have compatibility. I think this is the logic. Native Client is the driver with the highest compatibility spectrum of all others.

When it comes to performance, the difference is negligible.

There are two links that can be interesting, with examples of connections for each application scenario, and with recommendations for using the Native Client compared to other available drivers:

http://www.connectionstrings.com/sql-server-native-client-11-0-oledb-provider/ http://www.connectionstrings.com/sql-native-client-use/

Browser other questions tagged sql-server asp connection

You are not signed in. Login or sign up in order to post.