Solved

Choose FM Pro or ASP.NET

Posted on 2003-10-27
3
974 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Accepted Solution

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

Author Comment

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

Beatboxradio
0
 

Expert Comment

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

707 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