ODBC Drivers for Fm Pro 5.5 II?

Peter Reid preid at reidit.co.uk
Wed May 22 19:09:01 EDT 2002


>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

Please excuse my ignorance, but I'm not sure how to apply your advice 
above!  I'm trying to test this under the following circumstances on 
my small LAN:

Server
------
- Win XP Pro PIII-700 laptop (IP address 192.168.181.4)
- running FM Pro 5.5 with Web sharing enabled
- simple db file called "job.fp5" with two fields: "JobCode" and "JobDesc"
- db layouts "Fullinfo" and "Table"
- response file: "C:\fmformat.html"
- fmformat.html content:

    JobCode: [FMP-field: JobCode]
    JobDesc: [FMP-field: JobDesc]

Client
------
- Mac OS X (10.1.4) G4/733 running Rev 1.1.1
- able to connect to server FM Pro using IE 5.1 with URL of 
http://192.168.181.4
- tried following handler:

   on GetWeb
     put "http://192.168.181.4//FMPro" into theURL
     post "-db=Job.fp5&-lay=Table&-format=fmformat.html&-findAll" to URL theURL
     put urlDecode(it)
   end GetWeb

All I get back in the message box is an HTML formatted error message that says:

   window.errObj = { code: 400, reason: 0, cause: "//FMPro HTTP/1.1" }

where

   err400: "Bad Request\r\rThe server could not process your request 
due to a syntax error."

It seems to locate the response file OK, but not understand its content??

Any ideas please?

Peter
-- 
Peter Reid
Reid-IT Limited, Loughborough, Leics., UK
Tel: +44 (0)1509 268843 Fax: +44 (0)870 052 7576
E-mail: preid at reidit.co.uk
Web: http://www.reidit.co.uk



More information about the use-livecode mailing list