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:304626 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
