Question

I need to know what the various FogBugz connection strings look like for Access, MySQL, and SQL Server.

Answer 1

Here's the SQL Server connection string using SQL Server Authentication:

Server=myServerAddress;Initial Catalog=myDatabase;User Id=myUsername;Password=myPassword;MultipleActiveResultSets=true;

Here it is using Integrated Security:

Server=myServerAddress;Initial Catalog=myDatabase;Integrated Security=SSPI;MultipleActiveResultSets=true;

Here's an example MySQL connection string:

Driver={mySQL};Server=myServerAddress;Database=myDatabase; User=myUsername;Password=myPassword;

A note:

• The {mySQL} portion of the above string is pretty much vestigial. As of FogBugz 7, we are using the .NET connector regardless of what driver you specify.