Re: FileMaker Pro Backend DB?
The only real reason to use FMP as a back-end database is if people are still access it through the regular FMP interface. Sharon - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 7:05 PM Subject: Re: FileMaker Pro Backend DB? It will take me a while to dig up the info on how to do this -- I will post later. I'd appreciate that. Since the site isn't expecting heavy traffic, I was thinking a migration over to MS Access or MySQL if necessary. I don't think the project warrants moving up to SQL server or similar. - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: FileMaker Pro Backend DB?
Here is how to do this -- assuming you have FIleMaker and the JDBC driver (fmpjdbc12.jar). 1) Start FileMaker and create/open a db called Data Source : FileMakerTest CF Data Source Name FileMakerTest JDBC URL jdbc:fmpro:http://www..yourwebsite.com:591/ Driver Class com.fmi.jdbc.JdbcDriver Driver Name FileMakerJDBC Username Put the fmpjdbc12.jar file path in your classpath, or put the jar in /Library/Java extensions I just tried it and it worked fine HTH Dick On Thursday, October 10, 2002, at 07:50 AM, Sharon DiOrio wrote: The only real reason to use FMP as a back-end database is if people are still access it through the regular FMP interface. Sharon - Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 09, 2002 7:05 PM Subject: Re: FileMaker Pro Backend DB? It will take me a while to dig up the info on how to do this -- I will post later. I'd appreciate that. Since the site isn't expecting heavy traffic, I was thinking a migration over to MS Access or MySQL if necessary. I don't think the project warrants moving up to SQL server or similar. - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
FileMaker Pro Backend DB?
A potential client is considering porting his FileMaker db to the web to display his inventory on his site. I've no experience with FM but believe there are drivers out there for CF to interact with it. Does anyone have experience with this? Does FM online require a specific type of server in addition to CF? Does one query the db with more-or-less standard SQL? Any resource URL's would be appreciated. TIA. Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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.
RE: FileMaker Pro Backend DB?
None personally, but a fellow CF programmer friend had tried with minimal success to connect to FM. I recall a thread several weeks ago on this too, you might want to check the archives. If I recall correctly, it was way more problematic than it was worth, for that individual. Jon Moneymaker Computer Specialist Fleet and Family Support Center 799 Powderkeg Lane (Gate 3) Naval Weapons Station Yorktown, VA 23691 -Original Message- From: Bob Haroche [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 2:24 PM To: CF-Talk Subject: FileMaker Pro Backend DB? A potential client is considering porting his FileMaker db to the web to display his inventory on his site. I've no experience with FM but believe there are drivers out there for CF to interact with it. Does anyone have experience with this? Does FM online require a specific type of server in addition to CF? Does one query the db with more-or-less standard SQL? Any resource URL's would be appreciated. TIA. Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: FileMaker Pro Backend DB?
Run screaming. Upgrade the DB backend. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Bob Haroche [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 1:24 PM To: CF-Talk Subject: FileMaker Pro Backend DB? A potential client is considering porting his FileMaker db to the web to display his inventory on his site. I've no experience with FM but believe there are drivers out there for CF to interact with it. Does anyone have experience with this? Does FM online require a specific type of server in addition to CF? Does one query the db with more-or-less standard SQL? Any resource URL's would be appreciated. TIA. Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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.
Re: FileMaker Pro Backend DB?
I have interfaced FileMaker to CFMX done a limited amount of testing. I think you want to avoid using filemaker as an online db (similar reasons to those for avoiding MS-Access). What you could do is use CFMX to convert the FileMaker data into some other online RDBMS (free or proprietary) It will take me a while to dig up the info on how to do this -- I will post later. Dick On Wednesday, October 9, 2002, at 11:24 AM, Bob Haroche wrote: A potential client is considering porting his FileMaker db to the web to display his inventory on his site. I've no experience with FM but believe there are drivers out there for CF to interact with it. Does anyone have experience with this? Does FM online require a specific type of server in addition to CF? Does one query the db with more-or-less standard SQL? Any resource URL's would be appreciated. TIA. Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: FileMaker Pro Backend DB?
I don't work with FM much (read: if I can help it) but others here are pretty knowledgable about it. While working with a multi-DB project (SQL FM, if you believe) what I was told was that the ODBC drivers for FM are pretty leaky and crash-prone. On top of that, they are rather slow (even on FM server) as compared to a native SQL server. And, of course, FM is only partially SQL compliant. I may be off on the particulars, but that's the gist of what I heard. HTH. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Moneymaker, Jon S CONT (WPNSTA Yorktown) : [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, October 09, 2002 3:42 PM : To: CF-Talk : Subject: RE: FileMaker Pro Backend DB? : : : None personally, but a fellow CF programmer friend had tried with minimal : success to connect to FM. : I recall a thread several weeks ago on this too, you might want : to check the : archives. : If I recall correctly, it was way more problematic than it was worth, for : that individual. : : Jon Moneymaker : Computer Specialist : Fleet and Family Support Center : 799 Powderkeg Lane (Gate 3) : Naval Weapons Station : Yorktown, VA 23691 : : -Original Message- : From: Bob Haroche [mailto:[EMAIL PROTECTED]] : Sent: Wednesday, October 09, 2002 2:24 PM : To: CF-Talk : Subject: FileMaker Pro Backend DB? : : : A potential client is considering porting his FileMaker db to the web to : display his inventory on his site. I've no experience with FM but believe : there are drivers out there for CF to interact with it. Does anyone have : experience with this? Does FM online require a specific type of server in : addition to CF? Does one query the db with more-or-less standard SQL? Any : resource URL's would be appreciated. : : TIA. : : Regards, : Bob Haroche : O n P o i n t S o l u t i o n s : www.OnPointSolutions.com : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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
Re: FileMaker Pro Backend DB?
It will take me a while to dig up the info on how to do this -- I will post later. I'd appreciate that. Since the site isn't expecting heavy traffic, I was thinking a migration over to MS Access or MySQL if necessary. I don't think the project warrants moving up to SQL server or similar. - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm