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
