I'll give that a go. Thanks. On Fri, Feb 27, 2015 at 1:32 AM, Thomas Eckardt <[email protected]> wrote:
> >"DBIFullConnectionString" > > 'DBdriver' should be used for this! > > Thomas > > > > > > Von: K Post <[email protected]> > An: ASSP development mailing list <[email protected]> > Datum: 26.02.2015 23:44 > Betreff: Re: [Assp-test] fixes in assp 2.4.4 build 15052 > > > > 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 > > > > > > > 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! > ******************************************************* > > > ------------------------------------------------------------------------------ > 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 > ------------------------------------------------------------------------------ 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
