An ODBC connection to a SAGE line-100 accounts database works perfectly well in CF5 but I can't get it to work at all in CF8 on the same server. (Win2k3 R2 sp2) In CF8, it shows OK in the status column of the Data sources page, also when I 'verify' it, but when I run a query from a page which works OK in CF5:
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed. SQLSTATE HY000 SQL SELECT ACCOUNT_NUMBER, ACCOUNT_NAME, THIS_RECORD, PARENT_RECORD FROM SALES_LEDGER VENDORERRORCODE 2217 DATASOURCE SAGE_NMCDATA Additionally, when I get this error, on the server I get a Visual studio Just-in-Time Debugger window popping up with the message: An unhandled exception occurred in swsoc.exe [6138] Has anyone any ideas? Thanks Richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
