Forums
This topic is locked
differences in connection strings between 2008 and previous versions of MSSQL
Posted 15 years ago
1
has voted
15 years ago dave blohm posted:
I'm trying to connect to a db on an MSSQL 2008 server and my typical connections strings just aren't working. Has there been a shift, a change in how we connect to MSSSQL?Replies
Replied 15 years ago
15 years ago Dave King replied:
Hi Dave, I guess you've got this sorted by now but if it helps I'm using the following connection string with Fasthosts in the UK and it's working fine:
Dim MM_ConnMSSQL_STRING
MM_ConnMSSQL_STRING = "Driver={SQL Server};Server=000.000.000.000;Database=databasename;UID=databaseID;PWD=databasepwd"
Dim MM_ConnMSSQL_STRING
MM_ConnMSSQL_STRING = "Driver={SQL Server};Server=000.000.000.000;Database=databasename;UID=databaseID;PWD=databasepwd"