No, it's a SAGE proprietary db format, I forget its actual name, the ODBC driver is theirs too. Suffice to say if you do a search for SAGE line 100 and ODBC and 'flaky' you get quite a few results....
These days I think SAGE are using mssql or mysql as the core of their accounts systems but despite my efforts to get my client to upgrade, so far he has no desire to, so I'm stuck with the thing. I think I'll stick with using the jdbc:odbc bridge which at least seems to work in CF8; previously I could only communicate with the thing via CF5. As suggested, my CFC always converts the jdbc recordset into a cf query even if in some cases there is an unnecessary overhead, and then the jdbc recordsets can always be closed gracefully. As an aside, it doesn't help that in line 100 a lot of the column names have # in them, as in ADDRESS_LINE#1 Thanks for all your suggestions anyway. Richard > -----Original Message----- > From: denstar [mailto:[EMAIL PROTECTED] > Sent: 02 May 2008 07:40 > To: CF-Talk > Subject: Re: closing JDBC recordsets > > Is there any possibility that the database file format is DBASE? > > That's the jdbc driver I was using for clipper, I think. > > Maybe it's foxpro or something? > > You might be able to find a more native driver, is what I'm, > um, driving at. > > -- > Time is bunk. > Douglas Adams > > On Thu, May 1, 2008 at 8:40 AM, Richard Meredith-Hardy > <[EMAIL PROTECTED]> wrote: > > In fact I'd tried this combination, but I tried again, and > no, doesn't > > work, same as many other variants I've tried. > > > > I've studied the two neos you suggest, the most > interesting thing I > > found is in neo-query.xml where jdbc-odbc-bridge has an attribute > > 'handler' with a value pointing at jdbcodbc.cfm which is in > > CFIDE\administrator\datasources\ > > > > I thought this might contain some interesting clues, but this cfm > > file is encrypted... > > > > > > Richard > > > > > -----Original Message----- > > > From: Dave Watts [mailto:[EMAIL PROTECTED] > > > > > Sent: 01 May 2008 13:44 > > > 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 take a look at neo-query.xml and neo-datasources.xml, > > > you should see the values used when you create a normal > > > datasource. You should be able to reverse-engineer that a bit > > > to figure out which values go where. That said, I think these > > > would be the right values: > > > > > > JDBC URL: jdbc:odbc:SAGE1; > > > Driver Class: sun.jdbc.odbc.JdbcOdbcDriver Driver Name: > JdbcOdbcDriver > > > Username: whatever you're putting in UID above > > > Password: whatever you're putting in PWD above > > > > > > 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:304631 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
