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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
