static string CreateOdbcConnectionString ()
{
#if NET_2_0
OdbcConnectionStringBuilder csb = new OdbcConnectionStringBuilder ();
csb.Driver = "SQL Server";
#else
StringBuilder sb = new StringBuilder ();
sb.Append ("Driver={SQL Server};");
#endif
string serverName = Environment.GetEnvironmentVariable ("MONO_TESTS_SQL_HOST");
if (serverName == null)
throw CreateEnvironmentVariableNotSetException ("MONO_TESTS_SQL_HOST");
#if NET_2_0
csb.Add ("Server", serverName);
#else
sb.AppendFormat ("Server={0};", serverName);
#endif
string userName = Environment.GetEnvironmentVariable ("MONO_TESTS_SQL_USER");
if (userName != null)
#if NET_2_0
csb.Add ("Uid", userName);
#else
sb.AppendFormat ("Uid={0};", userName);
#endif
string pwd = Environment.GetEnvironmentVariable ("MONO_TESTS_SQL_PWD");
if (pwd != null)
#if NET_2_0
csb.Add ("Pwd", pwd);
#else
sb.AppendFormat ("Pwd={0};", pwd);
#endif
#if NET_2_0
return csb.ToString ();
#else
return sb.ToString ();
#endif
}