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"
These are the possible settings
CF Data Source Name =
JDBC URL =
Driver Class =
Driver Name =
User Name =
Password =
Regards
Richard
> -----Original Message-----
> From: denstar [mailto:[EMAIL PROTECTED]
> Sent: 01 May 2008 06:48
> To: CF-Talk
> Subject: Re: closing JDBC recordsets
>
> On Wed, Apr 30, 2008 at 11:36 PM, Richard Meredith-Hardy
> <[EMAIL PROTECTED]> wrote:
> > I did try, but without success.
> >
> > I suppose you're right though. I'll have another go at it.
>
> You can always implement your own pooling, if you want. Just
> more typing. :-)
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:304566
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
