Sage line 100 is an ancient beast and I would use a normal cf datasource if I could, but it doesn't work. It does in CF5 but in CF8.1, 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 FROM SALES_LEDGER VENDORERRORCODE 2217 DATASOURCE SAGE1 Additionally, when I get this error, I get a Visual studio Just-in-Time Debugger window popping up on the server (this is a dev server) with the message: An unhandled exception occurred in swsoc.exe [6138] You then have to restart the CF service, so it's pretty catastrophic. The only way I've succesfully communicated with the DB in CF8 is by a direct JDBC connection (code below) but I'd prefer to do it in a more standard way if I could.... Richard > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: 01 May 2008 09:13 > To: CF-Talk > Subject: RE: closing JDBC recordsets > > > You're right, a standard datasource would be much better, my direct > > access code which works (CF 8.1) is: > > > > <cfobject type="JAVA" action="Create" name="Class" > > class="java.lang.Class"> <cfset > > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")> > > <cfobject type="JAVA" action="Create" name="DriverManager" > > class="java.sql.DriverManager"> > > <cfset con = DriverManager.getConnection("jdbc:odbc:SAGE1;UID=xxx; > > PWD=yyy;")> > > <cfset st = con.createStatement()> > > <cfset rs = st.executeQuery("#sql#")> > > > > Any suggestions what should go where in the administrator? > > I've tried quite a few combinations of settings for an 'other' type > > datasource, some 'verify', but if you run a query against the DS I > > always get: "Error Executing Database Query. Option out of range" > > If you're using an ODBC datasource, why not just use the ODBC > Socket datasource option in CF? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Training: Adobe/Google/Paperthin Certified Partners > http://training.figleaf.com/ > > WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! > http://www.webmaniacsconference.com/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304568 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
