Choose FM Pro or ASP.NET

Posted on 2003-10-27
Medium Priority
Last Modified: 2012-03-15

I need help about 2 differents ways : FM Pro or ASP.NET(Intranet)
to manage invoices, quotes, shipping, receiving, orders, clients, retailers,.... ?
I describe my needs :
1 - I want to expand this database on the web.
2 - Retailers have access to order some products by the net.
3 - Maybe UPS Rate Calculator automaticaly when a invoice does.
4 - Maybe Tax Rate Calculator based on each countries or states.
5 - Maybe Dynamic Currency Exchange Money means convert US Funds in Canada Funds
automaticaly when a invoice does.
6 - Have I live chat on web to help someone with ours products.
7 - Some graphical charts to see financial year or others things.

Usually, I speak french so I hope you understand my english.
And thanks a lot for answer(s) !!!!

Question by:beatboxradio

Accepted Solution

Mariano_Peterson earned 500 total points
ID: 9630398
FM Pro and ASP.NET are not competing products - they each do very different things.

FM Pro is a desktop database application.  It stores and retrieves data.  Interestingly, FM Pro is not fully SQL compliant, and while it does have an ODBC component, it is so slow that it is impractical to use as an ODBC data source.  This does not mean that FM Pro cannot be used as a database; it just means that you must use methods other than SQL to communicate with FileMaker.

ASP.Net is a CGI, or web scripting application.  It answers HTTP requests, performs some programmatic action, and returns a result (typically text based HTML) to the web client.  ASP.Net (or classic ASP, for that matter) is used to server dynamic web pages which often derive content from a database.  ASP.Net is typically connected to SQL Server or Access, but is just as easily connected to any other ODBC compliant application.

ASP.Net can also be used to connect to FileMaker, however, not using ODBC (and therfore not using SQL).  FileMaker's ODBC component is simply too slow for web use.  However, using ASP's MSXML component, ASP can interact with FileMaker by sending HTTP requests to FileMaker and receiving XML responses from FileMaker.  The ASP script can then build a dynamic web page based on the data it received from FileMaker.  From a top level perspective, the HTTP/XML communication with FileMaker is similar to the ODBC connection with other databases - ASP must send a request to the database, the database must process and respond to the request, and then ASP must decipher and use the response to build the page.  The difference is FileMaker's HTTP/XML doesn't use SQL, where as ODBC does, and ODBC is not a stateless protocol and can therefore hold multiple constant connections with the database, resulting in much faster performance.

So I guess the answer to your question is not FM Pro -or ASP.NET, but rather ASP.NET -AND WHICH- database (FM Pro or Access or MS SQL) to use for the back end?

-- ALSO --

In case I misinterpretted your question:
You can build a web based intranet using ASP, or you can build a client-server application that is available to people on the intranet using FileMaker Pro and FileMaker Server.  If you build a client-server solution, then each end user will have to have a copy of FileMaker Pro installed on their work station, and a maximum of 250 concurrent users can be supported assuming that you're using FM Server.

Building a client-server application in FileMaker is typically much, much easier than building a web based intranet using ASP.  FileMaker provides its own scripting language which, while much more limited than VBScript or JScript, is much easier to learn.  Also, designing basic layouts is much easier in FileMaker than on the web, since FileMaker offers a truly WYSIWYG editor.  The down side to using FileMaker is that the code is not re-usable, and is very procedural and can get unwieldly as the complexity of your solution grows.

Hope this helps,

Author Comment

ID: 9633579
Thanks a lot Maraino.

So I can use ASP to build an Intranet with more tools than Filemaker (I means
in www.asp.net under "control gallery", a lot of tools you can used)
and after publish a part of database on the web !!

thanks !!


Expert Comment

ID: 9828782
Building a complete business solution in ASP.net n'est pas un jeu d'enfant.
Would suggest you go and see in www.sourceforge.net if there's an already built framework to start from.
This framework. would be free.
Then it would not be in asp.net but rather in PHP.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Integration Management Part 2
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question