The request properties can not be supported by this ODBC Driver

Results 1 to 2 of 2

Thread: The request properties can not be supported by this ODBC Driver

  1. #1
    Ojasvi Guest

    Default The request properties can not be supported by this ODBC Driver

    This error sometimes crops up in the line where I am executing a sql statement and opening a recordset. This is not dependent on code,as the same code runs fine other time. Actually I have noticed that this shows up when the server is busy and does not have enough memory. <BR>I have set connection.commandtimeout property, but even that doesn&#039t work in such situation.<BR><BR>Can anyone suggest how I can avoid this error...and get faster resultset?<BR><BR>Thanks...<BR>Ojasvi

  2. #2
    Matthew Hazlett Guest

    Default RE: The request properties can not be supported by this ODBC Driver

    For the ODBC part, if you are talking to a SQL 7 server make sure you have the newest MDAC drivers. Last I checked they were up to 2.1. I had similer problems to this awhile ago.<BR><BR>As for the memory part, upgrade the hardware :-)<BR>

Posting Permissions

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