Hi I'm trying to connect to a MS SQL Server 2005 database but I am unable to.
I have taken the connection string from the myLittleAdmin screen:
Connection string: Data Source=(local);Network Library=;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=sharkli1;Encrypt=no;
Connection timeout: 15
Database: master
Datasource: (local)
Network packet size: 4096
Server version: 09.00.1399
Work station id: DB2005
so I've been using:
"Data Source=(local);Network Library=;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=sharkli1;Encrypt=no;"
I have a database called 'Meals' that I would like to connect to.
The code I'm using to try and open a connection is c#.NET 2.0:
string strConn = "Data Source=(local);Network Library=;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=sharkli1;Encrypt=no;"
SqlConnection conn = new SqlConnection();
conn.ConnectionString += strConn;
conn.Open();
Can anybody help?
I have taken the connection string from the myLittleAdmin screen:
Connection string: Data Source=(local);Network Library=;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=sharkli1;Encrypt=no;
Connection timeout: 15
Database: master
Datasource: (local)
Network packet size: 4096
Server version: 09.00.1399
Work station id: DB2005
so I've been using:
"Data Source=(local);Network Library=;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=sharkli1;Encrypt=no;"
I have a database called 'Meals' that I would like to connect to.
The code I'm using to try and open a connection is c#.NET 2.0:
string strConn = "Data Source=(local);Network Library=;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User ID=sharkli1;Encrypt=no;"
SqlConnection conn = new SqlConnection();
conn.ConnectionString += strConn;
conn.Open();
Can anybody help?
Comment