"Reading about it on the Adobe site they say that ODBC not really necessary"
which is true.
You can build connections via a JDBC connection string via CFML, JWS class
or an outside class or
jar as long as you return a connection object back to your page you can also
use preparedStatement too or
just use the datasource manager.
<cfset application.test =
MacromediaDriver.connect("jdbc:macromedia:sqlserver://xxx")>
<cfset application.update_mailinglist =
application.test.prepareStatement("Update
mailinglist SET email = ?, why = ?, Delivery = ? WHERE email = ?")>
<cfset application.insert_mailiglist =
application.sqlserver_connection.prepareStatement("INSERT INTO mailinglist
(Email,USER_NAME,PASSWORD,date_added,Days_Remaining,date_end,Status,Validated,Delivery)
VALUES
(?,?,?,?,?,?,?,?,?);")>
On 8/3/06, dsmith @ psea. org dsmith @ psea. org <[EMAIL PROTECTED]> wrote:
>
> >Smith, Daron [PA] wrote:
> >> We are having lots of trouble with the CF ODBC service locking up.
> >> Reading about it on the Adobe site they say that it's not really
> >> necessary. But if I stop it, my ODBC queries do not work. What do
> >> you
> >> use for database access if you disable that service?
> >
> >JDBC:
> http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001735.htm#1235436
> >
> >Jochem
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248734
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
