Forums
This topic is locked
differences in connection strings between 2008 and previous versions of MSSQL
Posted 14 Oct 2009 17:23:43
1
has voted
14 Oct 2009 17:23:43 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 01 Nov 2009 21:20:50
01 Nov 2009 21:20:50 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"