SnippetGood

Question

1

Hello, I'm looking for some simple, standard, connection string snippets for MS SQL and MySQL databases, and an explanation of what the variables mean.

Thanks.

Steve

edited Oct 1 at 17:00

binky♦♦
500●8

asked Sep 30 at 21:56

steveT
33●2

StopTheSearch.com · Accepted Answer · 2009-09-30 23:53:52Z UTC

2

Check out ConnectionStrings.com for a huge collection of samples broken down by product and technology. The whole site is devoted to connecting to databases so I'm sure you'll find what you're looking for there.

answered Sep 30 at 23:53

StopTheSearch.com
125●5

You're certainly right about that. Thanks. That site is amazing. – steveT Oct 1 at 2:30

binky · Answer 2 · 2009-10-09 04:10:17Z UTC

Here are some standard connection strings using .NET.

.NET to SQL Server 2005

Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;

.NET to SQL Server 2005 Trusted

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

.NET to MYSQL Connector (with port)

Server=myServerAddress;Port=3306;Database=myDataBase;Uid=myUsername;Pwd=myPassword

Looking for database connection strings

2 Answers