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.
