Thanks for the idea. I found this in the log too (was there before, just
missed it). Doesn't matter of compatibility if 90, 100, or 110. Same
basic error:
Feb-18-15 16:59:29 Info: the DBI connection string is set to:
'DBI:ADO:database=asspdb;host=127.0.0.1;provider=SQLNCLI11;DataTypeCompatibility=110;'
Feb-18-15 16:59:29 Error: Can't Open Connection
'database=asspdb;host=127.0.0.1;provider=SQLNCLI11;DataTypeCompatibility=110;'
Package : DBD::ADO::dr
Filename : C:/Perl/site/lib/DBD/ADO.pm
Line : 158
Last error : -2147217887
OLE exception from "Provider":
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
Win32::OLE(0.1712) error 0x80040e21
in METHOD/PROPERTYGET "Open"
Feb-18-15 16:59:29 Unable to get database information via ADO!
Feb-18-15 16:59:29 Warning: database options will not be available!
I tried setting up a system DNS in the ODBC setup on the machine. Used
SQLNCLI11, 127.0.0.1, same username, pw, database. Test succeeded.
On Wed, Feb 18, 2015 at 3:50 PM, Scott MacLean <a...@hollsco.com> wrote:
> 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
>
------------------------------------------------------------------------------
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
