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 <[email protected]> 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, 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. > -- -- 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.
