Connection Strings for SQL Server 2000 and 7.0

.NET Framework Data Provider for SQL Server

Standard Security
Data Source=ServerName;Initial Catalog=DatabaseName;User Id=UserName;Password=Password;

Standard Security alternative syntax
Server=ServerName;Database=DatabaseName;User ID=UserName;Password=Password;Trusted_Connection=False;

Trusted Connection

Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI;

Connecting to an SQL Server instance

Server=ServerName\theInstanceName;Database=DatabaseName;Trusted_Connection=True;

Trusted Connection from a CE device

Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI;User ID=myDomain\UserName;Password=Password;

Note: This will work on a CE device only. 

Connect via an IP address

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=DatabaseName;User ID=UserName;Password=Password;

DBMSSOCN=TCP/IP.

Note: 1433 is the default port for SQL Server.

Microsoft OLE DB Provider for SQL Server

Standard Security

Provider=sqloledb;Data Source=ServerName;Initial Catalog=DatabaseName;User Id=UserName;Password=Password;

Trusted connection

Provider=sqloledb;Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI;

Connecting to an SQL Server instance

Provider=sqloledb;Data Source=ServerName\theInstanceName;Initial Catalog=DatabaseName;Integrated Security=SSPI;

Connect via an IP address

Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=DatabaseName;User ID=UserName;Password=Password;

DBMSSOCN=TCP/IP.

This use to connect the SQL Server Database via internet connection.

SQL Server 2005 Express - For Visual Basic .Net and 6.0

The best database server for Microsoft Visual Basic Language is "Microsoft SQL Server" but what's the difference between the Microsoft SQL Server Express and SQL Server. Well, MS SQL Server you need to buy a license from Microsoft Corporation while the MS SQL Server Express or MSDE in previous version it's a FREE database, it means you can use this software without buying a license. However, there's a limitations not to mention all, but one is the size of the database can grow up to four(4) Gigabytes only, for me 4GB database can handle enough for a small company with transactions more or less 1 million records. For more information please visit website here. http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx

I suggest to use this database server for testing your .net applications, .asp or .aspx for website applications because it's easy to configure and use. You can install this software in MS Windows XP, MS Vista and MS Windows 7.

Click the link below to download the software from Microsoft website.

Download the Microsoft SQL Server 2005 Express....