ADO,provider=SQLNCLI10;Server=your-SQL-Server;DataTypeCompatibility=100;
should do it, without changing the code.
How ever the code will be changed to use 'server' instead of 'host' as
connection parameter if the 'ADO' or 'ODBC' driver is used.
Thomas
Von: K Post <nntp.p...@gmail.com>
An: a...@hollsco.com, ASSP development mailing list
<assp-test@lists.sourceforge.net>
Datum: 18.02.2015 04:22
Betreff: Re: [Assp-test] Running ASSP on Windows Server 2008
against SQL Server 2008 R2
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 <a...@hollsco.com> 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
> Assp-test@lists.sourceforge.net
> 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
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally
privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no
known virus in this email!
*******************************************************
------------------------------------------------------------------------------
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
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
