Subscribe Now

For ColdFusion hosting try HostMySite.com.

Author:

Brian Meloche

Can CF7 running on a Mac connect to an Access database located on the Mac?  It's for a presentation I have to make tonight, and having the Access file on the Mac would make it a whole lot easier to present. -- Sincerely, Brian Meloche Now blogging at: http://www.brianmeloche.com/blog/ User Group Manager, Cleveland Macromedia Users Group, http://www.clevelandmmug.org Co-Manager, Cleveland ColdFusion Users Group, http://www.clevelandcfug.org

Author:

Lola J. Lee Beno

Brian Meloche wrote: > Can CF7 running on a Mac connect to an Access database located on the > Mac?  It's for a presentation I have to make tonight, and having the > Access file on the Mac would make it a whole lot easier to present. Try Actual Technologies at http://www.actualtechnologies.com . . . they've created a driver that allows you to read Access DBs, both on your desktop (as long as the file has .mdb appended) and remote (I think). I don't know about making it work with CF, though, since this driver is ODBC only and not JDBC, far as I can tell. If you can figure out how to get CF7 connect with this, I'd love to know. -- Lola - mailto:lola@his.com http://www.lolajl.net | Blog at http://www.lolajl.net/blog/ Freedom is not free. I'm in Bowie, MD, USA, halfway between DC and Annapolis.

Author:

John Michael Barrett

This is not possible(to my knowledege) The best thing(what I do) is to find a access to mysql converter(assuming you have mysql runnning on your mac),and then use the mysql file. If you in a crunch,and this is for a meeting tonight I can host the db for you. Let me know if you need this done. John ----- Original Message ----- From: Brian Meloche <brianmeloche@gmail.com> Date: Wednesday, February 8, 2006 8:19 am Subject: Using Access DB on a Mac? To: CF-Mac <cf-mac@houseoffusion.com>

Author:

Lola J. Lee Beno

John Michael Barrett wrote: > This is not possible(to my knowledege) > The best thing(what I do) is to find a access to mysql converter(assuming you have mysql runnning on your mac),and then use the mysql file. Is this converter Windows only? -- Lola - mailto:lola@his.com http://www.lolajl.net | Blog at http://www.lolajl.net/blog/ Freedom is not free. I'm in Bowie, MD, USA, halfway between DC and Annapolis.

Author:

Brian Meloche

I will probably just bring a Windows laptop with me.  There may be a way to do it, but I don't have time to investigate it at this point. On 2/8/06, Lola J. Lee Beno <lola@his.com> wrote:

Author:

John Michael Barrett

good luck to you, and I hope everything works out:) ----- Original Message ----- From: Brian Meloche <brianmeloche@gmail.com> Date: Wednesday, February 8, 2006 10:49 am Subject: Re: Using Access DB on a Mac? To: CF-Mac <cf-mac@houseoffusion.com>

Author:

Lewis Sellers

On Feb 8, 2006, at 3:31 PM, Lola J. Lee Beno wrote: I looked about a year ago for the same purpose, and could never find   a mac native access to mysql converter. I did find several (mostly   shareware and commercial) that did what I needed. Don't recall the   name of the one I ended up using but it's backed up to disk somewhere   if no one else can suggest one. As I recall it just created a sql text file that I then used to   inject the data into a new mysql database I had created. Easy to use and straight forward -- if you have a windows machine and   the software. Takes just a minute. --min

Author:

Lewis Sellers

http://www.dmsofttech.com/index.shtml I believe this is what I used. As I said, been a year though. --min

Author:

John Michael Barrett

Yeah, I have to use windows at work. The problem is that you have to get this applications to read the access file, and then convert to mysql. I quess you could ue the virtual PC, but my friend at school tells me it is slow, and don't bother if this is all you want a PC for. I found a free one, let me kow I can send you the URl for downloading. John ----- Original Message ----- From: "Lola J. Lee Beno" <lola@his.com> Date: Wednesday, February 8, 2006 10:32 am Subject: Re: Using Access DB on a Mac? To: CF-Mac <cf-mac@houseoffusion.com>

Author:

Sean Corfield

On 2/8/06, John Michael Barrett <johnbarr@hawaii.edu> wrote: > This is not possible(to my knowledege) Sure it is :) The Actual drivers give you an ODBC connection. Then, in theory, you can use the JRun JDBC/ODBC bridge driver to create a JRun datasource. Then, in theory, you can use the J2EE datasource type in the CF Admin to let CF connect to the JRun datasource (which in turn bridges to the Actual ODBC driver and the DSN you create for the database). I've gotten as far creating the ODBC datasource in the Apple ODBC administrator, using the Actual driver. Next step would be to ensure the Sun JDBC/ODBC driver is on JRun's path (it isn't in my setup). -- Sean A Corfield -- http://corfield.org/ Got frameworks? "If you're not annoying somebody, you're not really alive." -- Margaret Atwood

Author:

John Michael Barrett

Hi Sean, Thank you for the mail on this:) This is something that I will look in it today:) John ----- Original Message ----- From: Sean Corfield <seancorfield@gmail.com> Date: Wednesday, February 8, 2006 11:07 am Subject: Re: Using Access DB on a Mac? To: CF-Mac <cf-mac@houseoffusion.com>

Author:

dave

mysql has their own db migration tools that are pretty good, try them first, they are on the mysql website. Personally I would export the access db to an xml file then import into mysql, takes about a minute. ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! John Michael Barrett wrote: > This is not possible(to my knowledege) > The best thing(what I do) is to find a access to mysql converter(assuming you have mysql runnning on your mac),and then use the mysql file. Is this converter Windows only? -- Lola - mailto:lola@his.com http://www.lolajl.net | Blog at http://www.lolajl.net/blog/ Freedom is not free. I'm in Bowie, MD, USA, halfway between DC and Annapolis.

Author:

dave

Navicat has nice features for importing as well but its not free. Again, try the mysql migration tools first http://www.mysql.com/products/tools/migration-toolkit/ even has a video on how to do an import from access ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! On Feb 8, 2006, at 3:31 PM, Lola J. Lee Beno wrote: I looked about a year ago for the same purpose, and could never find a mac native access to mysql converter. I did find several (mostly shareware and commercial) that did what I needed. Don't recall the name of the one I ended up using but it's backed up to disk somewhere if no one else can suggest one. As I recall it just created a sql text file that I then used to inject the data into a new mysql database I had created. Easy to use and straight forward -- if you have a windows machine and the software. Takes just a minute. --min

Author:

John Michael Barrett

HI I use Navicat for the mac, but can't use access(only there windows version, I think). Great software! John ----- Original Message ----- From: dave <cflist@jamwerx.com> Date: Wednesday, February 8, 2006 11:58 am Subject: Re: Using Access DB on a Mac? To: CF-Mac <cf-mac@houseoffusion.com>

© COPYRIGHT 2008 HOUSE OF FUSION

Privacy | FAQ | Site Map | About | Feedback | Advertising | Tiny Url | Mailing Lists Cache
Fusion Authority | ColdFusion Jobs @ House of Fusion | Blog of Fusion