I am trying to make a connection to a FMP database to use with an ASP page via either ODBC connection or a DSN-less connection. I have successfully connected locally using DSN-less using the following connection string:

AllAsText=0;ApplicationUsingThreads=1;Driver=FileMaker Pro;FetchChunkSize=100;

FileOpenCache=0;IntlSort=0; MaxTextlength=255;ServerAddress=127.0.0.1;

TranslationOption=0;UseRemoteConnection=1

I have Remote Data Access Companion checked under edit/Preferences/Application/plug-ins tab

I have Remote Data Access Companion checked under File/shared

I have no idea how it sees the database (my guess is that the ODBC driver does some kinda communicating with the app to find the database) but it seems to work...it didn't work the first several times I tried it till I accidently had the database open in FMP when I was making the connection...then it worked...the problem with that is that we don't have FMP resident on the webserver...we have FM server...but not FMP...so if I want the DSN-less connection string to work...do I have to buy another site license for the webserver and install FMP there and have the database open when I create a DSN-less connection AND an ODBC connection?

This brings up more concerns...are there any security issues that anyone has found having FMP on their webserver? Any occurances of the app crashing the webserver? Does FMP require a reboot once installed...I have to send out internal notice that server will be rebooted and scedule that. etc etc etc

Seems like a lot of hoops to jump thru to get this thing to work.

Thanks in advance for any advice, suggestions, etc etc

Frank

We have on our NT 4 web server IIS, FM Unlimited and Web Server Connector. It is running for months without restart. Only once, twice a year we are restarting FMU.

We are serving dynamic pages through WebCompanion and CDML. The ODBC is poorly implemented in FM.

where can you get webcompanion and CDML? And is there a significant cost incurred?

Webcompanion is included as part of FileMaker, CDML you write in any text editor to communicate with your databases. Have a look at Webcompanion in the FMP help.

Ed.