> Message: 4 > Date: Wed, 22 May 2002 08:05:58 +0100 > To: [EMAIL PROTECTED] > From: Peter Reid <[EMAIL PROTECTED]> > Subject: Re: ODBC Drivers for Fm Pro 5.5? > Reply-To: [EMAIL PROTECTED] > > >on 21/5/02 4:20 PM, Peter Reid at [EMAIL PROTECTED] wrote: > > > >> Does anyone know where I can get installers for ODBC drivers to > >> support accessing FileMaker Pro 5.5 databases using Rev 1.1.1? I'm > >> looking to access FM Pro dbs from Win 32, Mac Classic and Mac X > >> clients. > Cheers > > Peter > -- > Peter Reid > Reid-IT Limited, Loughborough, Leics., UK > Tel: +44 (0)1509 268843 Fax: +44 (0)870 052 7576 > E-mail: [EMAIL PROTECTED] > Web: http://www.reidit.co.uk
You can use FileMaker Pro web companion to exchange data between FMP and Rev either on the local network or on the internet. Normally, all you have to do (after setting up web companion) is to send put "http://folderInPath/folderWithResponseFile/FMPro"; into theURL post "-db=MyDbNameHere&-lay=DBLayoutNameHere&-format=FormatFileName.html&-findAll" put urlDecode(it) Response file contains tags (FMP files) you want to receive in following format First Name: [FMP-field:Students::First Name] -- for related field Last Name: [FMP-field: Last Name] -- for "normal" field. Refer to FMP "CDML Reference.fp5" database for more details. Use LINK forms of CDML syntax. You can do all kind of things with this... update, delete, add records, find records etc There is one detail involved however. Because FMP 4.x is not returning "content-length", LibURL was failing to process the call. I don't know if it was fixed in FMP 5.x or/and in LibURL. If it is NOT fixed you can try your own socket handler with something like this.. on mouseUp put "-db=MyDBName&-lay=MyLayoutName&-format=MyFormatFile.html&-findAll" into TheCall replace " " with "+" in TheCall replace cr with numToChar(13) in TheCall put number of chars of TheCall into Nchars put "YourURLaddressHere" into TheURL put "POST /YourPathToResponseFile/FMPro? HTTP/1.0" & CRLF &"host: " &TheURL& CRLF&"Content-Type: application/x-www-form-urlencoded" & CRLF&"Content-Length: " & Nchars& CRLF & CRLF &TheCall into tString open socket to TheURL write tString to socket TheURL read from socket TheURL until CRLF read from socket TheURL until CRLF & CRLF read from socket TheURL for 100000 -- approximatelly CLOSE SOCKET TheURL put urlDecode(it) end mouseUp note: script above is just raw example You need to have FMP 5.5 unlimited if you have more then 10 users with different IP addressees per 24 hours. Otherwise use FMP 4.x (this version does not have above restrictions) this method with FMP 4.1 <-> FMserver <-> lasso combination works for us for more then 1 000 users and VERY havy load. You can check how it works if you go <http://www.psych-ai.com/> and download evaluation copy of our application. Best Regards Tariel Gogoberidze _______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
