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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Connection String

Author  Topic 

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2001-12-02 : 13:06:10
I saw this connection string posted on another board and was curious if anyone could explain what the ".1" is for. I haven't been able to find an answer yet.

strConnString = "Provider=SQLOLEDB.1;Data Source=xxx.xxx.xxx.xxx,1433;Network Library=DBMSSOCN;Initial Catalog=xxxxx;User Id=xxxx;Password=*******;"

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Argyle
Yak Posting Veteran

53 Posts

Posted - 2001-12-02 : 14:23:46
.1 is the version number. Search the registry and you will see that the ProgID for Microsoft OLEDB Provider for SQL Server is SQLOLEDB.1.

Incase you would have more than one installed you could specify another version. If you just type SQLOLEDB the default will be used.

Go to Top of Page
   

- Advertisement -