Try backing your DataTypeCompatibility down to 90 or 100 and see if it
makes any difference.
On 2/18/2015 1:29 PM, K Post wrote:
> oh, and the user has full rights to that database.
>
> On Wed, Feb 18, 2015 at 1:10 PM, K Post <nntp.p...@gmail.com> wrote:
>
>> I see this at startup in the log:
>>
>> Feb-18-15 11:38:07 Info: the DBI connection string is set to:
>> 'DBI:ADO:database=asspdb;host=127.0.0.1;provider=SQLNCLI11;DataTypeCompatibility=110;'
>> Feb-18-15 11:38:07 Error: Can't Open Connection
>> 'database=asspdb;server=127.0.0.1;provider=SQLNCLI11;DataTypeCompatibility=110;'
>> Package : *DBD::AD*O*::d*r
>>
>>
>> I can connect to 127.0.0.1 with the same creds using SQL Server mangement
>> server. I confirmed that the username, password,and database name are all
>> correct in the gui.
>>
>> Activestate perl 5.20. version 2.99 of dbd-ado.
>>
>> Anything else I can try?
>>
>> On Wed, Feb 18, 2015 at 11:18 AM, K Post <nntp.p...@gmail.com> wrote:
>>
>>> Thanks Thomas.
>>> I know with MySQL the tables should be created automatically. That's not
>>> happening for my test MSSQL 2012 installation. I assume it should? if so,
>>> I need to drill down to see what's going on in my case.
>>>
>>>
>>> On Wed, Feb 18, 2015 at 2:49 AM, Thomas Eckardt <
>>> thomas.ecka...@thockar.com> wrote:
>>>
>>>> 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
>>>>
>>>
> ------------------------------------------------------------------------------
> 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
------------------------------------------------------------------------------
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
