I moved my mail server to a new box this weekend. The new server is
Windows Server 2008, and I am running ASSP against SQL Server 2008 R2.
I encountered a couple of problems getting ASSP to work with this new
environment - mainly with the SQL server. In order to get it to connect
using ADO to SQL 2008, I had to do two things. First, for the DBdriver,
I had to use this string:
ADO,provider=SQLNCLI10;DataTypeCompatibility=100;
Note that the provider has changed from previous versions of SQL, and
the DataTypeCompatibility is now a required parameter. If you are
running against a previous compatibility level of database this value
needs to change (i.e. SQL 2000 = 80, SQL2005 = 90, SQL2008 and SQL2008
R2 = 100, SQL 2012 = 110, SQL2014 = 120.
However, this still did not let it connect. Doing some research, I
discovered the "host" parameter in the connect string must be changed to
"server". In order to get ASSP to function, I had to modify the source
code from this:
if (($DBusedDriver eq 'ODBC' || $DBusedDriver eq 'ADO') &&
$CanUseTieRDBM) {
my $dbh =
DBI->connect("DBI:$DBusedDriver:database=$mydb;host=$myhost$DBOption",
"$myuser", "$mypassword");
To this:
if (($DBusedDriver eq 'ODBC' || $DBusedDriver eq 'ADO') &&
$CanUseTieRDBM) {
my $dbh =
DBI->connect("DBI:$DBusedDriver:database=$mydb;server=$myhost$DBOption",
"$myuser", "$mypassword");
This is obviously not an optimal way to do this as I'll have to change
this every time ASSP is upgraded - so just letting you know Thomas, it
looks like this parameter in the connection string needs to be itself
parameterized within ASSP.
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
