And MS provides SQL server JDBC drives for free - search their website. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barney Boisvert Sent: Monday, May 10, 2004 9:11 PM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] Subject of Java again
If the MM drivers won't let you do it, then you'll probably need to procure your own JDBC drivers, add them to the CF classpath, and then set up your datasources to use those drivers. Once that's done, then you should be able to get a reference to the DataSource from Jrun, probably though JNDI, and do your standard JDBC stuff. Cheers, barneyb > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott > Sent: Monday, May 10, 2004 6:03 PM > To: [EMAIL PROTECTED] > Subject: [CFCDev] Subject of Java again > > > Hopefully someone out here has a solution or example. > > I was writing some java to extend CF a little more, and came across > something that I can't seem to figure out the right approach. > > The tagLib that I am creating needs to hit the DB, I was > originally using > the ODBC connection but found this not the right way to go. > So as I don't > have JDBC drivers that would connect to any SQL server or > Access database > etc. I thought I would use the macromedia drivers, whoops > invalid licence. > > So, is it possible to leverage of these drivers within CF using java. > Admittedly I was using it in an application for now and will > try to do it in > a taglib, but for now has anyone attempted to do this and if > so do you have > an example for me to look at for inspiration. > > > > Regards > Andrew Scott > Technical Consultant > > NuSphere Pty Ltd > Level 2/33 Bank Street > South Melbourne, Victoria, 3205 > > Phone: 03 9686 0485 - Fax: 03 9699 7976 > > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[EMAIL PROTECTED] > ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
