Paul, Is your code running on the server and if so what OS is the server running? If it isn't windows it won't work.
Andy On Fri, Sep 18, 2015, 1:06 AM Paul Boniol <paul.bon...@gmail.com> wrote: > 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 <tilgh...@meg.abyt.es> > 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 <paul.bon...@gmail.com> >> 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 <farn...@gmail.com> >> > 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 <paul.bon...@gmail.com> >> 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 nlug-talk@googlegroups.com >> >> To unsubscribe from this group, send email to >> >> nlug-talk+unsubscr...@googlegroups.com >> >> 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 nlug-talk+unsubscr...@googlegroups.com. >> >> 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 nlug-talk@googlegroups.com >> >> To unsubscribe from this group, send email to >> >> nlug-talk+unsubscr...@googlegroups.com >> >> 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 nlug-talk+unsubscr...@googlegroups.com. >> >> 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 nlug-talk@googlegroups.com >> > To unsubscribe from this group, send email to >> > nlug-talk+unsubscr...@googlegroups.com >> > 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 nlug-talk+unsubscr...@googlegroups.com. >> > 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 nlug-talk@googlegroups.com >> To unsubscribe from this group, send email to >> nlug-talk+unsubscr...@googlegroups.com >> 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 nlug-talk+unsubscr...@googlegroups.com. >> 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 nlug-talk@googlegroups.com > To unsubscribe from this group, send email to > nlug-talk+unsubscr...@googlegroups.com > 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 nlug-talk+unsubscr...@googlegroups.com. > 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 nlug-talk@googlegroups.com To unsubscribe from this group, send email to nlug-talk+unsubscr...@googlegroups.com 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 nlug-talk+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
