Hello. Has anyone had any problems with querying a SQL table whose information originally came from a FoxPro table?
This is why I'm asking this question:
A FoxPro table was exported to a MS SQL 7 table recently. Shortly after I activated a page (MultiPrice.cfm) with a query pointing to this new SQL table, my ColdFusion server began shutting down automatically.
This is the error I get when my CF server crashes:
"Error","TID=311","03/05/02","16:46:04","Exception thrown from within Listener Thread." Since the CF server shuts down instantly after the above error, my logs files do not tell me much of anything.
After further investigation, it seems as though this page (MultiPrice.cfm), once called 5-10 times, is to blame. I've used MultiPrice.cfm with a different SQL table being queried, and everything was fine. But for some reason, this particular SQL table (that was populated with data from a FoxPro table) is fouling everything up. It has 5 columns, all datatypes are nvarchar, except the ID column (int).
I don't have any experience with FoxPro. Any help would be greatly appreciated.
Thanks,
Kim Hamb
This is why I'm asking this question:
A FoxPro table was exported to a MS SQL 7 table recently. Shortly after I activated a page (MultiPrice.cfm) with a query pointing to this new SQL table, my ColdFusion server began shutting down automatically.
This is the error I get when my CF server crashes:
"Error","TID=311","03/05/02","16:46:04","Exception thrown from within Listener Thread." Since the CF server shuts down instantly after the above error, my logs files do not tell me much of anything.
After further investigation, it seems as though this page (MultiPrice.cfm), once called 5-10 times, is to blame. I've used MultiPrice.cfm with a different SQL table being queried, and everything was fine. But for some reason, this particular SQL table (that was populated with data from a FoxPro table) is fouling everything up. It has 5 columns, all datatypes are nvarchar, except the ID column (int).
I don't have any experience with FoxPro. Any help would be greatly appreciated.
Thanks,
Kim Hamb
