Drivers for bank connection via Classic ASP

Navigation
1

Good afternoon. In the connection string of our web application, we always use 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? Do you have an article that explains each type?

Thank you.

    
asked by anonymous 10.06.2014 / 20:10

2 answers

1

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

  • Is this driver reliable and well tested?
  • Is this driver compatible with my infrastructure and architecture?
  • Does this driver provide the features my application needs?
  • Does this driver have a 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 performance and reliable

More information here: link

link

    
10.06.2014 / 21:31
0

Well, the newer the driver, the more versions of SQL Server your application will have compatibility. I think that's the logic. Native Client is the driver with the widest spectrum of compatibility among all the others.

In terms of performance, the difference is negligible.

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

  

link    link

    
10.06.2014 / 21:23
SqlDataAdapter Query with Parameters Change a textbox inside a textbox / jQuery group