We migrated our intranet to an upgraded server over the weekend, and now some of our PERL routines (that worked fine before!) aren’t working properly.  These all involve ODBC connections to an Access database using Win32::ODB.  A bottom-of-the-barrel query “Select * from tablename” works fine.  But “select fieldname from tablename” or “select * from tablename where field1=3” generates an error.  Win32::ODBC::Error() returns

                        -3100, [Microsoft][ODBC Microsoft Access Driver] Unknown, 1, ,

Doe anyone have any suggestions?  The really weird thing is that some queries run and others (that I know are correct) will not.

 

- Deb Thompson

Civil & Environmental Consultants, Inc.

www.cecinc.com

800-365-2324

 

_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to