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