Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: hanso
  • Order by date
  1. hanso

    How do I stop execution of SQL (insert) query on server?

    Vancouverite, What technique did you find, other than using Monitor? We are considering upgrading to SP4 but, we still need to perform some extended tests so that might take a while... Much thanks for any help Hans
  2. hanso

    How do I stop execution of SQL (insert) query on server?

    Vancouverite, Alas, tried it, but then monitor hangs as well. We' re not able to delete the SRDE anonymous user on Novell because it's on connection 0 (server process). Also rebooting the workstion does not help...... I'm at a loss...... Hans.
  3. hanso

    How do I limit system resources for query execution

    We are on Novell 5.1 SP3 with Pervasive.SQL 200i (SP3), we' re just considering upgrading (both) to SP4. Do I understand correctly you had this issue up untill you upgraded to SP4 ?
  4. hanso

    Connecting to Btrieve with VB 6

    More info on: http://www.pervasive.com/library/index.asp?_shownode=EMB Hans.
  5. hanso

    Updating Pervasive Btrieve tables in MS Access

    Hi, Sounds like you are trying to insert a value in a linked field that does not have a corresponding value in the linked table. So you probably should upodate the table that is linked to, first. Hans.
  6. hanso

    Connecting to Btrieve with VB 6

    Pmitter, ADO is the engine MS is using for data access, it usually still uses ODBC to connect. You can use Pervasive tools in your app (without having SDK. Just add PVSWInstallpath\BIN\PVDCM.dll as a reference and it will allow you to approach your Pervasive database through the pervasive...
  7. hanso

    How do I limit system resources for query execution

    Tom, I checked all possible configuration items and alse the helpfile concerning this issue. Unfortunately Pervasive runs on Novell Netware 5.1 at our site so not all options are available to me. Furthermore this situation also occurs running the simplest of queries (select * from table). Also...
  8. hanso

    end-of-file marker is not being updated regularly during query

    Hi, When inserting records in a table through a SQL query the end-of-file marker is moved to the end of the data only when the query succesfully terminates. If there is an error during execution of the query I can see from the data size of the file that records have been inserted but querying...
  9. hanso

    How do I limit system resources for query execution

    Hi, When I run a query on the server the SRDE uses all processor resources on the server available. Is there anyway to limt this? Thanks for any help. Hans
  10. hanso

    How do I stop execution of SQL (insert) query on server?

    Hi, When I execute an insert statement from within SQL Data Manager (PVSW 2000i SP3 on Novell 5.1) The SQL Data Manager stops responding but the query is still being executed. In the pervasive monitor I see that user SRDE Aanonymous is running the query and in Novell moitor I see that the file...

Part and Inventory Search

Back
Top