Solved

Choose FM Pro or ASP.NET

Posted on 2003-10-27
3
955 Views
Last Modified: 2012-03-15
Hi,

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) !!!!

beatboxradio.
0
Comment
Question by:beatboxradio
3 Comments
 
LVL 3

Accepted Solution

by:
Mariano_Peterson earned 125 total points
Comment Utility
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,
Mariano
0
 
LVL 5

Author Comment

by:beatboxradio
Comment Utility
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 !!

Beatboxradio
0
 

Expert Comment

by:mjojones
Comment Utility
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.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now