I am running MS-Access on a Windows 2000 system and using the Window version of the OpenLink package. CFMX is running on the SunSolaris8 system as a client. I recently posted the details of this earlier under this same subject.
I agree with you about not running MS-Access in a production mode. I discourage it. But I do have cases where I need to. Troy Dick Applebaum wrote: > Troy > > Are you running the MS-Access & windows portion of the OpenLink package > under emulation or on a real windows box. > > I run it under emulation and it seems to perform pretty well (better > than I expected). > > Of course it is only used to convert to/from a real RDBMS, and not as a > production CFMX datasource. > > I look at use of OpenLink by CFMX as just an extension of using > MS-Access by CFMX (on a win platform) -- you only do it for a little > while, and only when you absolutely need to > > I bought MS-Office, just so I could manipulate client's mdb on win > emulation, now OpenLink extends this ability to CFMX on non-win > platforms. > > Dick > > On Thursday, October 24, 2002, at 04:25 PM, Troy Simpson wrote: > > > I think that Dick might be right about MS Access. > > The only driver for M$ Access is Microsoft's ODBC Driver which is only > > for Windows systems. > > All the other drivers like the JDBC drivers act as a middle layer > > between CFMX and the Access ODBC driver. > > > > I'm afraid that there is not a pure 100% Java JDBC driver for M$ > > Access. > > > > I believe I'm going to be stuck with the OpenLink Software Solution > > for now. > > I hate having to introduce another system into the mix. > > > > Troy > > > > Rob Rohan wrote: > > > >> By the way, I just tried this on a win box (jre 1.4.0_02) and it > >> worked. I > >> don't have a real computer here at work so I cant check on Linux or > >> Solaris > >> (or OSX for that matter) > >> > >> URL = sun.jdbc.odbc.JdbcOdbcDriver > >> Class = jdbc:odbc:Driver={Microsoft Access Driver > >> (*.mdb)};DBQ=C:\test.mdb > >> Name = test > >> > >> -----Original Message----- > >> From: Rob Rohan [mailto:rob@;cardinalweb.com] > >> Sent: Thursday, October 24, 2002 1:07 PM > >> To: CF-Talk > >> Subject: RE: M$Access DB and ColdFusionMX for Solaris > >> > >> 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.