Nope. It's there. Try stopping and starting the CF service and checking connection again, if that doesn't work - I don't know what to tell ya.
Sorry. Maybe an MM guy would like to comment? -----Original Message----- From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu] Sent: Thursday, October 24, 2002 12:32 PM To: CF-Talk Subject: Re: M$Access DB and ColdFusionMX for Solaris I got back the following error when I was trying to create the M$ Access data source: Connection verification failed for data source: MSAccess []java.sql.SQLException: null The root cause was that: java.sql.SQLException Is this a problem related to being unable to find the *.jar or *.class file for sun.jdbc.odbc.JdbcOdbcDriver? If so, what JAR file do I need in the ClassPath? I'm running ColdFusionMX on Sun Solaris 8 and Apache 2.0.40. Troy Rob Rohan wrote: > and you need to have a space > > Microsoft Access Driver (*.mdb) > ^--- space! > -----Original Message----- > From: Rob Rohan [mailto:rob@;cardinalweb.com] > Sent: Thursday, October 24, 2002 10:58 AM > To: CF-Talk > Subject: RE: M$Access DB and ColdFusionMX for Solaris > > no [] > > Good luck > > -----Original Message----- > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu] > Sent: Thursday, October 24, 2002 10:54 AM > To: CF-Talk > Subject: Re: M$Access DB and ColdFusionMX for Solaris > > Thanks Rob it this works it would be great. :-) > > So the Java URL would be: > > jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=[/usr/db/db1.mdb] > or > jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=/usr/db/db1.mdb > > The second one does not have the [,]. > > The reason I'm asking for examples is because if it is going to work, the > syntax is what > usually kills it. > > Thanks, > Troy > > Rob Rohan wrote: > > > Ok, if it does work it would work like this: > > > > 1) in "Add new data source" setup in cfide choose "other" for "Driver" > > 2) for jdbc url put jdbc:odbc:Driver={Microsoft Access Driver > > (*.mdb)};DBQ=[path to access mdb] > > where [path to access mdb] is C:\blah\blah.mdb or /usr/blah/blah.mdb > > 3) Driver class = sun.jdbc.odbc.JdbcOdbcDriver > > 4) Driver namae = whatever you want > > > > If it does work, please let us know. > > > > And I don't see why it wouldn't work in Solaris, I think I have used this > in > > Linux (just not with MX). > > > > Cheers, > > Rob > > > > -----Original Message----- > > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu] > > Sent: Thursday, October 24, 2002 10:14 AM > > To: CF-Talk > > Subject: Re: M$Access DB and ColdFusionMX for Solaris > > > > You have any more real examples for the jdbc:... string? > > What *.jar or *.class files do I need? > > And this will work on Sun Solaris? > > > > Thanks, > > Troy > > > > Rob Rohan wrote: > > > > > Hey Troy, > > > > > > Try > > > > > > jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=[path to access > > mdb] > > > > > > using the jdbc odbc bridge. That's how I access it straight from java. > > Never > > > tried it with MX but in theory... > > > > > > Rob > > > > > > -----Original Message----- > > > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu] > > > Sent: Thursday, October 24, 2002 9:44 AM > > > To: CF-Talk > > > Subject: Re: M$Access DB and ColdFusionMX for Solaris > > > > > > Yea, I could. ;-) > > > > > > But we are trying to provide a service for people in other departments > and > > > they only know > > > MS Access. Additionally, management wants us to try and host this on > the > > > Unix systems if > > > possible. > > > > > > Troy > > > > > > David Adams wrote: > > > > > > > Good question and I hope you get a lot of response but can you export > > > > the data from Access to MySQL or something that runs on UNIX and have > > > > CF talk to it instead? > > > > > > > > -----Original Message----- > > > > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu] > > > > Sent: October 23, 2002 1:23 PM > > > > To: CF-Talk > > > > Subject: M$Access DB and ColdFusionMX for Solaris > > > > > > > > I'm sitting here trying to figure a way to use ColdFusionMX on > Solaris8 > > > > to get data out of an Microsoft Access Database. > > > > I heard a rumor that there was an ODBC driver or some other driver > that > > > > would allow this to happen. > > > > Does anyone know if this is true? > > > > Can I store an Access DB File on a Solaris File system and use > > > > ColdFusionMX to select data from it which is also running on the same > > > > Solaris system? > > > > I have a feeling that the answer would be NO, but just wanted to post > > > > this to see if I am correct. > > > > > > > > I searched the CF-TALK list for this and did not find anything, but I > > > > could have used the wrong search criteria. > > > > > > > > If this is indeed not possible, I thought of another idea to > accomplish > > > > this that might work. > > > > Use ColdFusionMX in distributed mode. > > > > Install ColdFusionMX and the Access DB file on a Windows2000/XP server > > > > and use ODBC to connect to Access. > > > > Configure the web server, maybe Apache2, on Sun Solaris8 with the > > > > ColdFusionMX distributed client (wsconfig.jar). > > > > I wonder if this would work like I expect it to? > > > > Anyone already done this? > > > > I can already see the benefits. > > > > I can segregate my small Access Applications from the rest. ;-) > > > > > > > > I strongly invite any and all comments. > > > > > > > > Thanks, > > > > Troy > > > > > > > > -- > > > > ------------------------- > > > > Troy Simpson > > > > Applications Analyst/Programmer, MCSE, OCPDBA > > > > North Carolina State University Libraries > > > > Campus Box 7111 | Raleigh | North Carolina > > > > ph.919.515.3855 | fax.919.513.3330 > > > > E-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm