Thanks Mark, seems the vendor driver is the way to go, found them with the client install.
Have you/can you interact with the java objects from cf or do I need to do the whole shebang from in java. What i mean is should/can I create a class, to create and return a connection object and use that in cf to excute prepared statements etc or am i going to be casting all the time and be unable to access some method properly. I am creating some cfc to wrap my own database interactions but cfquery is a pain if you want to use cfqueryparam. and build dynamic sql statements Elliot "Mark Mandel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Elliot, > > I did a post on connecting Oracle 9i to CFMX Pro a bit ago (which also > has some links to other resources). > > http://www.compoundtheory.com/?action=displayPost&ID=15 > > There are a bunch of JDBC drivers for Oracle on the Oracle site itself. > http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html > > Does that help you out? > > Mark > > -- > E: [EMAIL PROTECTED] > W: www.compoundtheory.com > ICQ: 3094740 > > On Thu, 12 Aug 2004 09:54:36 +1000, Elliot Russo > <[EMAIL PROTECTED]> wrote: > > Thanks fellas - I thought i remebered a post about this Andrew and the > > licensing. Weird you would think the cf context of the call would provide > > enough. > > > > I'm trying to use with Oracle 9i perhaps it is available with the client > > install - I'll have a look > > > > Elliot > > > > > > "Elliot Russo" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > > > > > > > > Hi, > > > > > > can any one confirm/deny or give example of using jdbc (in a java class or > > > directly from cf.) in particular can you use the cf provided drivers for > > > this task (and what are the class names for ODBC socket) and what might be > > > there 'URL's be ie. > > > > > > Class.forName ("com.macromedia.sql.ODBSocket"); ???????? > > > String url = "jdbc:odbc:MyDSN"; ??????? > > > Connection con = DriverManager.getConnection (url, "sa", "password"); > > > > > > or do i need to download other drivers? > > > > > > > > > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
