Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    England
    Posts
    1

    Unanswered: Get Connected Failed or Receive Failure with ASP

    On my website I use ASP's, which use several databases that are hosted on our webserver (Windows 2003 Server) using Filemaker 6 Unlimited.

    All my pages run smoothly on the web for a short while, then I get one of the two error messages below.

    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed

    OR

    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Receive failure

    With the first message Filemaker has closed itself and the second it stays open but the webpages refuse read it.

    Can anyone help?

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    Filemaker odbc is an old implementation of the odbc api and is not really optimized to allow communication with a web server that open many connections to the database.
    If you need to build web site using Filemaker and IIS you should take a look at Blueworld LASSO or JSP
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Sep 2003
    Location
    San Francisco
    Posts
    70

    Lightbulb

    It sounds like you're trying to publish FMP data on the web using ASP. Using ODBC to connect the two is not a good idea because FileMaker's ODBC is too slow for a web server.

    Instead use http/xml to transfer data back and forth between ASP and FileMaker. You can use the MSXML http object (provided by MDAC) to send http requests to FileMaker from ASP. If you specify an xml format file from FileMaker (like fmp_xml or dso_xml) in your http request, then the MSXML object will return an XML DOM you can walk with your JScript or VBScript code. This is much, much faster than retrieving data from FMP using ODBC.

    Alternatively, you can use PHP to do the same thing. The difference is, Chris Hansen already wrote an object class in PHP that handles the HTTP query building and XML parsing for you. You can download his free code at www.iviking.org. Also, Steve Lane from The Moyer Group has written a good white paper about it at www.moyergroup.com under "published works".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •