I don't know any other good reason why this should not work with all
MSSQLversions , than a misconfiguration.
You need to install the OLE provider (Native Client SQL 2012) . Lower
versions of the native client would possibly require compatibility options
in the ADO connection string.
Trusted Connection=yes; could be also reqiured - this depends on the
SQL-Server configuration
Keep in mind, that most MSSQL Server installations require the definition
of the SQL-Instance in the connection string 'Server' option
(SQL-Server/SQL-Instance - older MSSQL versions may require a backslash
instead SQL-Server\SQL-Instance)!
I would create a DSN with all required configuration options. You may use
a texteditor or the odbcad32.exe to do this. Check that the connection is
working in odbcad32.exe.
There could be an additionaly requirement, if you use a 64Bit OS and a
32Bit Perl. Always use the right odbcad32.exe to create the DSN (64Bit
%windir%\system32\odbcad32.exe - 32Bit %windir%\SysWow64\odbcad32.exe)
Using a DSN is only one option.
you can test it with:
#!/usr/local/bin/perl
use strict;
use DBI;
my $dbh = DBI->connect("DBI:ADO:DSN=mydsn;", "user", "password");
If this script throws no error, it is working. Using a DSN - I recommend
to skip the assp config for 'myhost' and 'mydb'.
DBdriver:=ADO::DSN=mydsn;
myhost:=
mydb:=
----------------------
Instead, this should also work:
my $dbh =
DBI->connect("DBI:ADO:database=my-assp-db;server=SQL-Server/SQL-Instance;Provider=sqloledb;",
"user", "password");
'myhost' and 'mydb' are also not required here, because the ADO connection
string is fully defined ( in the 'DBdriver' option).
DBdriver:=ADO:database=my-assp-db;server=SQL-Server/SQL-Instance;Provider=sqloledb;
myhost:=
mydb:=
----------------------
With the assp.cfg definition of 'myhost' and 'mydb'
my $dbh = DBI->connect("DBI:ADO:Provider=sqloledb;", "user", "password");
should work - how ever, the 'SQL-Server/SQL-Instance' definition for
'myhost' will be not accepted by the GUI with the current release, but
this will be changed.
To try this with the latest release, change the line 3045 of assp.pl 2.4.4
build 15052 to
['myhost','database hostname or IP',40,\&textinput,'','(.*)',undef,
DBdriver:=ADO:Provider=sqloledb
myhost:=SQL-Server/SQL-Instance
mydb:=my-assp-db
Thomas
Von: K Post <[email protected]>
An: ASSP development mailing list <[email protected]>
Datum: 21.02.2015 23:47
Betreff: Re: [Assp-test] fixes in assp 2.4.4 build 15052
EXCELLENT. Thank you so much Thomas.
You didn't by chance test this against SQL Server 2012 did you? My
trouble is likely with DBD-ADO module vs ASSP itself, but just curious if
you ever tried with that version of MSSQL.
Thanks for taking such good care of all of us here. Here's to hoping that
your crazy work schedule relaxes and you get some time for yourself!
On Sat, Feb 21, 2015 at 9:20 AM, Thomas Eckardt
<[email protected]>
wrote:
> Hi all,
>
> fixed in assp 2.4.4 build 15052:
>
> - it was possible that the Perl module autoupdate function has removed
> unrelated files from the assp folder
>
> - the GUI index and the left menu were working only in the main
> configuration view since several releases
>
> - if the Perl module IO::Socket::IP was installed, on some systems,
> listeners defined on universal addresses
> were not working
>
> - module load errors for 'Unicode::Normalize' are now shown in the log
and
> the file moduleLoadErrors.txt
>
>
> changed:
>
> - the minimum version requirement for 'Win32::Unicode' is set to 0.37
>
> - if the 'Server' definition for ADO and ODBC connection is not set in
the
> 'DBdriver' definiton but the
> 'myhost' configuration is set, this value is now used in the
connection
> string to the database
>
> - the trailing IPv4 OIP detection for privat IPv6 addresses is now
skipped
> if such a notation is found in public IPv6 addresses, assp will detect
> the normalized IPv6 and
> the trailing IPv4 and will use both in the IP address checks
>
>
> Thomas
>
>
> 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
> [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
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-test
