Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    1

    Question Unanswered: PostgresODBC to Remote Server

    Hello

    I have been working with Postgres & Odbc for year now with great success.

    I have a problem now when trying to work with a remote server.

    If the network drops & reconnects I get an error saying the connect has errored

    Mysql & odbc would try and reconnect automaticly if needed.

    How can I do this with postgres & odbc?

    I thought of using the state property to check on teh connection.

    Currently I open the connection to the database when the app opens and only open and close the recordsets during the life of the app.

    I could establish a whole new connection each time I need data but that seems a waste of code and is slower for the app)

    Thanks heaps for any help


  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    IMO, monitoring connection state would be the way to go.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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