I ran the following query on CF 5.0 and it returns "95" but when run on CFMX it returns the error below: CF 5.0 link: http://www.strictlyhodaka.com/test.cfm
CFMX link: http://www.ticketleap.com/test.cfm Error returned on CFMX: The test page now returns the following: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'sysobjects'. Make sure it exists and that its name is spelled correctly. The error occurred in C:\Inetpub\wwwroot\ticketleap\test.cfm: line 1 1 : <cfquery datasource="ticketleap" name="rs"> 2 : select * from sysobjects 3 : </cfquery> Can anyone tell me what the problem is? Doug ================================ This address is filtered through the open relay database at http://www.ordb.org and is virus scanned by ANTIVIR http://www.dwhite.ws mailto:[EMAIL PROTECTED] ================================ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=10 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=10 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
