Great info Scott!
Trying here with SQL Server 2012

I used your ADO string
of: ADO,provider=SQLNCLI11;DataTypeCompatibility=110;   (does that look
right?)
I've tried the FQDN, localhost, and 127.0.0.1 for the myhost name
username and password entered the same as I did for the user using SQL
server auth (not integrated).

I see lots of errors like this:
Feb-17-15 22:13:05 Warning: database table whitelist has failed state - try
to reconnect
Feb-17-15 22:13:05 Whitelist database error: Usage
tie(%h,Tie::RDBM,<DBI_data_source>,%options) at sub main::checkDBCon line
69 thread 8.
Feb-17-15 22:13:05 Error: unable to use defined database - switching over
to use c:/assp/whitelist instead of table whitelist!
for all of the databases

Any suggestions? Did you ever hear back from Thomas on the code change?

Thanks!!!!
Ken


On Wed, Feb 4, 2015 at 12:23 PM, Scott MacLean <[email protected]> wrote:

> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/assp-test
>
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
_______________________________________________
Assp-test mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-test

Reply via email to