Great! Database object permissions are highly overlooked problems when used with Perl. OBDC's error messages are painted with a pretty broad stroke so they're not easy to detect.
If you print the sql code out from the script then cut and paste it to sql and it runs you can be sure the problem isn't in Perl. Chances are it is permissions on the dB object, the ODBC data source is set up incorrectly or you are connected to the wrong database. The problem can also be that the sql server is disconnected. ODBC does give you a good error message when the connection doesn't exist. | [reply] |
