Using Access DB on a Mac?

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

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.

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 ----- Excess quoted text cut - see Original Post for more -----

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.

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. ----- Excess quoted text cut - see Original Post for more -----

good luck to you, and I hope everything works out:) ----- Excess quoted text cut - see Original Post for more -----

On Feb 8, 2006, at 3:31 PM, Lola J. Lee Beno wrote: ----- Excess quoted text cut - see Original Post for more ----- 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 ----- Excess quoted text cut - see Original Post for more -----

http://www.dmsofttech.com/index.shtml I believe this is what I used. As I said, been a year though. --min ----- Excess quoted text cut - see Original Post for more -----

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 ----- Excess quoted text cut - see Original Post for more -----

> 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

Hi Sean, Thank you for the mail on this:) This is something that I will look in it today:) John ----- Excess quoted text cut - see Original Post for more -----

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.

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: ----- Excess quoted text cut - see Original Post for more ----- 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 ----- Excess quoted text cut - see Original Post for more -----

HI I use Navicat for the mac, but can't use access(only there windows version, I think). Great software! John ----- Excess quoted text cut - see Original Post for more -----