Yes, the code runs on the server. (Not a complete fan of the setup, but I don't control or manage it.) Windows Server 2012 R2, IIS, Active State Perl 64 bit.
Paul On Fri, Sep 18, 2015 at 12:01 PM, Andrew Farnsworth <[email protected]> wrote: > 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 <[email protected]> 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 <[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. >> > -- > -- > 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.
