Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
 Posted - 2004-07-22 : 06:17:07
|
| What's the difference (performance and technical) between using the following two connection strings.strconnect = "DRIVER={SQL Server}; SERVER=myserver; DATABASE=mydb; wsid=mylanlogon; Provider=MSDASQL"strconnect = "Provider=SQLOLEDB.1; SERVER=myserver; DATABASE=mydb; wsid=mylanlogon"Using the latter I don't get mylanlogon appearing in the "host" column...of the Active Process Info...i get the network address.Using the former...mylanlogon appears ok.....but before changing over I want to know the implications. |
|
|
JasonGoff
Posting Yak Master
158 Posts |
Posted - 2004-07-22 : 06:44:23
|
| The first one uses ODBC (DSN-less) connection. The second uses OLEDB drivers.Check out http://www.able-consulting.com/ADO_Conn.htm for the difference between the 2 (and other methods). |
 |
|
|
|
|
|
Connection String