Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Mac (CF-Mac)
Using Access DB on a Mac?
Author: John Michael Barrett
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2237
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 -----
Author: John Michael Barrett
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2236
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 -----
Author: Sean Corfield
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2235
> 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: Lewis Sellers
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2234
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 -----
Author: dave
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2233
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 -----
Author: John Michael Barrett
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2232
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 -----
Author: dave
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2231
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: John Michael Barrett
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2230
good luck to you, and I hope everything works out:)
----- Excess quoted text cut - see Original Post for more -----
Author: Lewis Sellers
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2229
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 -----
Author: Brian Meloche
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2228
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 -----
Author: Lola J. Lee Beno
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2227
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: John Michael Barrett
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2226
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 -----
Author: Lola J. Lee Beno
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2225
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: Brian Meloche
Short Link: http://www.houseoffusion.com/groups/cf-mac/thread.cfm/threadid:770#2224
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
|
May 23, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
