Re: [nlug] Perl ODBC

The server admin says it is in the Windows ODBC driver on the server. Paul On Thu, Sep 17, 2015 at 11:35 PM, Tilghman Lesher wrote: > Is the username/password being specified in odbc.ini? That's the only > way I can see that working. Otherwise, it will use the default values > for each field,

Re: [nlug] Perl ODBC

Appologies, Trying to get my son to do his homework distracted me when reading your response. I missed the important part. :) Specifying {odbc_driver_complete => 1}. It doesn't produce an error, but also seems to be running without coming back from the connect call, until the server times the s

Re: [nlug] Perl ODBC

Is the username/password being specified in odbc.ini? That's the only way I can see that working. Otherwise, it will use the default values for each field, which is almost certainly not what you want. On Thu, Sep 17, 2015 at 11:33 PM, Paul Boniol wrote: > Thanks, yes, we have been using the DBI

Re: [nlug] Perl ODBC

Thanks, yes, we have been using the DBI:ODBC. Not specifying anything other than the ODBC DSN, or specifying undef for username and password returns "Login failed for user ''.". Specifying the user but no password (or undef for the password) returns Login failed for user 'our-user-name'. Paul Bo

Re: [nlug] Perl ODBC

You should use the DBI perl module and the DBD::ODBC Driver. See http://search.cpan.org/~mjevans/DBD-ODBC-1.52/ODBC.pm Be sure to investigate the odbc_driver_complete option. It has been a while since I've done this but you could try passing in undefined values for username and password. And

[nlug] Perl ODBC

A consultant who knows a lot about ColFusion, but less about Perl said that we should be able to specify the Windows ODBC data source in our Perl scripts, without needing to specify the password on the connect string as it is stored in the ODBC connection. Everything I have tried and found online

Re: [nlug] calling database admins - (WAN / VPN) Replacement for old database app? (LAMP stack?)

On 09/17/2015 08:19 AM, Wayne Fay wrote: "be a simple transition with no major changes to the UI or system overall to avoid confusing the 70+ y/o user." I take that personally that I am confused. -- Jerry Perkins Home page http://jperkins.us Tux_Christmas_by_D3struct0.png

Re: [nlug] calling database admins - (WAN / VPN) Replacement for old database app? (LAMP stack?)

I agree. Thank you. M On Thu, Sep 17, 2015 at 8:19 AM, Wayne Fay wrote: > Perhaps there is an upgrade of your database user available? LOL > > But seriously, I would not build a new system today with a strict > requirement that it "be a simple transition with no major changes to > the UI or s

[nlug] Setting up some panel discussions at PhreakNIC by NLUG

I was at DragonCon helping with the EFF track a few weeks ago and we had a panel discussion on systemD. The panel packed the room and there was tremendous interest from those for and against and who just had no opinion but had heard of the controversy. I would like to do similar panels at Phre

Re: [nlug] calling database admins - (WAN / VPN) Replacement for old database app? (LAMP stack?)

Perhaps there is an upgrade of your database user available? LOL But seriously, I would not build a new system today with a strict requirement that it "be a simple transition with no major changes to the UI or system overall to avoid confusing the 70+ y/o user." He is simply going to have to learn