View Single Post
Old Nov 10th, 2007, 6:49 PM   #2
Grich
Hobbyist Programmer
 
Grich's Avatar
 
Join Date: Sep 2007
Location: Sydney - Australia
Posts: 195
Rep Power: 2 Grich is on a distinguished road
Re: Connecting to SQL Server 2005

developer fusion
carlprothman
Your connection string has to have this layout:
"Data Source=<host>; Initial Catalog=<Name of Database>; Integrated Security=True"
That is the minimum of what you need.
Some extra properties are as follows (these are optional):
Packet Size: Number of bytes in packet use to talk to SQL server.
User ID: User Name to log in.
Password: Password to login.
Workstation ID: Name of workstation to connect to SQL server.

(Hope this helps)
__________________
SYNTAX ERROR ...

Last edited by Grich; Nov 10th, 2007 at 6:50 PM. Reason: Add on
Grich is offline   Reply With Quote