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 |
|
macnab
Starting Member
6 Posts |
 Posted - 2009-11-09 : 03:53:26
|
| I have just upgraded to Windows &, so a bit of a problem getting SQL Server to work again. I used to use both Windows and SQL Server authentication. It is not recommended, so I am switching to just Winows authentication.My problem is the connection string. Currently it looks like this: cnStr = "Data Source='NIGEL-PC\\SQLEXPRESS';" + "user id=timesheetadmin;" + "pwd=password;" + "database=timesheet";Obviuosly the user id and pwd must come out, but I need to add to use SSPI. But how do I do that? All the documentation I have focusses on OleDB, and of course the wording is different. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-09 : 05:19:18
|
Maybe you can find what you're looking for...http://www.connectionstrings.com
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-09 : 05:20:24
|
And what is "Windows &"?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
macnab
Starting Member
6 Posts |
Posted - 2009-11-09 : 07:08:57
|
| Thanks. It's the multiple words for the same thing that got me. Whether or not it is Windows 7!! |
|
|
|
|
|
|
Connection string