Thomas-
This is great info. Thank you as always.
This is an x64 box, but perl is 32bit.
Here's what I've found:
No DNS setup in ODBC with the instance name. Does not work:
my $dbh = DBI->connect(
"DBI:ADO:database=asspdb;server=machinename/MSSQLSERVER;Provider=SQLNCLI11;",
"asspdbusername", "thepassword"
);
Yeilds:
DBI
connect('database=asspdb;server=machinename/MSSQLSERVER;Provider=SQLNCLI11;','asspdbusername',...)
failed: Can't Open
n 'database=asspdb;server=machinename/MSSQLSERVER;Provider=SQLNCLI11;'
Package : DBD::ADO::dr
Filename : c:/Perl/site/lib/DBD/ADO.pm
Line : 158
Last error : -2147467259
OLE exception from "Microsoft SQL Server Native Client 11.0":
Named Pipes Provider: Could not open a connection to SQL Server [67].
Win32::OLE(0.1712) error 0x80004005: "Unspecified error"
in METHOD/PROPERTYGET "Open" at testdb.pl line 5.
This DOES work:
No DNS setup in ODBC.
my $dbh = DBI->connect(
"DBI:ADO:database=asspdb;server=machinename;Provider=SQLNCLI11;",
"asspdbusername", "thepassword"
);
This also DOES work:
System DNS named testdsnforassp
my $dbh = DBI->connect("DBI:ADO:DSN=testdsnforassp;", "asspdbusername",
"thepassword");
So based on this and since I would prefer not to rely on a system DSN, just
to keep all ASSP settings in one place, I've got ASSP WORKING!!
DBdriver:=ADO:Provider=SQLNCLI11
myhost:=127.0.0.1
mydb:=thedbname
user and password set
Does it make any sense to add a config line in ASSP
"DBIFullConnectionString" or something like that where a user could enter
the exact string that is needed for whatever configuration that would be
used in lieu of the other settings? Is wouldn't be as user friendly as
letting the user enter db name, username, password, but would give more
granular control.
SO excited to have this working.
Thomas, if you agree with the way that I've done things, let me know and
I'll write a post that hopefully others can reference in the future.
On Sun, Feb 22, 2015 at 6:19 AM, Thomas Eckardt <[email protected]>
wrote:
> 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
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-test
