O'Reilly logo

ADO.NET Programming in Visual Basic™ .NET by Bob Howell, Steve Holzner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The SQL Server Data Provider

Of course we first look at the flagship, SQL Server provider. A typical Connection string SQL Server looks like this:

provider=SQLOLEDB;data source=EM_SERVER\VSdotNET;initial 
catalog=eLandBill;password=svcslave;persist security info=true;user 
id=sa;workstation id=EM_SERVER;packet size=4096 

Note that if we were using the SqlConnection class the Provider=SQLOLEDB element would not be used. Also if an element (or property) is missing it will use the default setting. We’ve already gone over most of these settings (when we looked at the Data Link Properties page). Just for completeness, I’ll summarize them again here:

  1. Provider— This is the name of the OLEDB data provider, in this case SQLOLEDB is the name of SQL Server ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required