Need SQL 2008 Connection String Help 2

[whateveragain]

I have been trying to get my connection string going for a couple of days and am getting nowhere. The following is my info. Can someone help me put together the proper connectionstring for SQL 2008 Server? I already tried

http://www.connectionstrings.com/sql-server-2008

to no avail.

server type: Database Engine
Server name: MyComputer-PC
Authentication: Windows Authentication

local connection
SQL 2008 Server

I want to include the statement: Connect Timeout=30
Thanks

 

[Rhys666]

What provider are you using?

Adding...

;Connect Timeout=60

...to the end of your current connection string should update the connection timeout but this won't affect the query/command timeout, (i.e., with the .net framework the SqlCommand.CommandTimeout property defaults to 30 seconds and would also need to be set appropriately if you want to extend the timeout length).

MSDN

Rhys

"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"
Terry Pratchett

 

[dhulbert]

Data Source=servername;
Initial Catalog=defauldatabase;
Provider=SQLNCLI10;
Integrated Security=SSPI;
Auto Translate=false;
Connect Timeout=30

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[whateveragain]

I'm a newbie. When you say provider, do you mean something like 'MSSQLSERVER'?

 

[Rhys666]

As per Dhulberts code...

Data Source=servername;
Initial Catalog=defauldatabase;
[b]Provider=SQLNCLI10;[/b]
Integrated Security=SSPI;
Auto Translate=false;
Connect Timeout=30

Rhys

"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"
Terry Pratchett