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.
