FileMaker instead of Access on an ASP website

[Guy Verville]

Hello,

I've done and managed a website made in ASP using an Access database. Since then, i've migrated to Mac while my client website remains ASP (on Windows). Before investing in FileMaker, I would like to know if I have any chance to use FileMaker instead of Access on the website, or should I rather consider migrating all the stuff into PHP and mySQL...

The reason for me to chose FileMaker is that I could use this software not only for this website, but also for other purposes, with my Mac.

Thanks in advance for any clarification given.

[Garry Claridge]

If your application is purely web-based then PHP/MySQL technology would be the way to go.

However, if you need an "in-house" DBMS then FM may be a very good choice.

A mix of "inhouse" and "web" can be provided by FM Server Advanced. You can use PHP etc to provide the web application. Depending on cost and other user needs a mix of FM and MySQL may also be a reasonable technology.

PHP and MySQL will run on your Mac!

All the best.

Garry

[Guy Verville]

Thank you, Gary, for your reply. My purpose for asking this is that I would have like not disturb that much my client website, allowing them to stay in ASP while me being able to better work on my Mac. Perhaps I will just ask them to find another webmaster.

I'm well aware that PHP and MySQL works either on my machine or even on my client site (which uses IIS).

Actually, the connection string is performed by this (VBScript)

Function CreateConnexion(SQLString)

set Connexion = Server.CreateObject("ADODB.Recordset")

Connexion.ActiveConnection = dcnDB

Connexion.Source = SQLString

Connexion.Open

Set CreerConnexion=Connexion

end Function

I'm not sure I can link this to a FM database.

[Garry Claridge]

I know that somebody had an ASP class (a long time ago) that worked with FM. However, I think too many differences may exist to make what you want to do viable.

All the best.

Garry

[Curtis_B]

Thought I would speak up here. I have a php/mysql site running remotely on our webserver and FMS running locally on our network here. We love FM for our in house information system, and php/mysql on the web end of things, so I recently developed a solution that automatically replicates FM >MySQL daily (or could be as often as needed). There is no need for incoming web>fm data for our solution, so it is just intended to display information. When I get some free time I'll document how I did everything and post it in this forum.

Curt

[Wim Decorte]

Keep your eye on fmdotnet.sourceforge.net

(should go live this week or next).

fmDotNet won't use ODBC though, it uses the FMSA XML data. But it does return a standard .NET DataSet.