Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: ODBC: SQlDriverConnect VERY VERY slow


    I use a Pervasive SQL 2000 Server engine v8.5 with ODBC. If I try to connect to the server with SQlDirectConnect, it takes up to 30 minutes to establish a connection to the database. Other ODBC commands work properly.

    Who can help me?


  2. #2
    Join Date
    Jul 2004

    Mistake: SQLDirectConnect means SQLDriverConnect

    Sorry, there's mistake in the thread before. SQLDirectConnect means SQLDriverConnect.

  3. #3
    Join Date
    Feb 2004
    I'm not sure what you mean by 2000. There is Sql 2000i, and V8.

    Anyway, I see that also with my ODBC connections. But I find that once the initial connection is made, repeat commands are very fast. In my program I open my connections and leave the open the duration of the service (which is usually all day). You would put try..catch (or on error) code in to detect if the connection closed, and re-open if necc.

    I've found this is much faster than open/close, open/close. (Unlike Sql Server).

    Hope this helps,

Posting Permissions

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