Problem with server

Results 1 to 2 of 2

Thread: Problem with server

  1. #1
    Join Date
    Dec 1969

    Default Problem with server

    Hello <BR>I have an Sql statement which retrieves around 20000 records at a time .It is being run on an NT server . It works fine in 4 NT servers except one . The erraneous line of code is <BR>set myrs=myconn.execute(strsql)<BR>i also tried with strsql,myconn,adopenstatic <BR>Infact I tried all the cursortypes, tried using cursortype consts instead of their names etc <BR>when i checked the sate of rs using myrs.state i got 0 before it got populated and 1 after it got populated. but in the server in which the above code is not working i am not getting myrs.state as 1 bcos myrs is not getting executed because server is not being able to execute the connection string . what can be done for this .. can anyone help me out <BR><BR>the error message i am getting is <BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;8007000e&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk. <BR>

  2. #2
    <eop> Guest

    Default CROSSPOST


Posting Permissions

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