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.
