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 <[email protected]> wrote: > 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 Boniol > > On Thu, Sep 17, 2015 at 10:57 PM, Andrew Farnsworth <[email protected]> > wrote: >> >> 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. >> >> Andrew Farnsworth >> (804) 405-3630 >> >> On Sep 17, 2015, at 11:22 PM, Paul Boniol <[email protected]> wrote: >> >> 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 says that we need to specify the >> password on the connect. >> >> Is anyone aware of a way to use the password stored in the Windows ODBC >> connection instead? (If this is possible, it is a win/win from my point of >> view, but nothing I have seen points to the ability to do so.) >> >> Paul >> >> -- >> -- >> You received this message because you are subscribed to the Google Groups >> "NLUG" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/nlug-talk?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "NLUG" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> >> -- >> -- >> You received this message because you are subscribed to the Google Groups >> "NLUG" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/nlug-talk?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "NLUG" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. > > > -- > -- > You received this message because you are subscribed to the Google Groups > "NLUG" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/nlug-talk?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "NLUG" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- Tilghman -- -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en --- You received this message because you are subscribed to the Google Groups "NLUG" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
