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 Mike Lewis 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: *

  1. leftee

    Having Issues with Managed Gigabit switches over fiber link

    i just recently purchased 3 new Dell Powerconnect 5424 managed gigabit switches . We are currently running Dell 2324 Powerconnect 100mb unmanaged switches. Everything is working fine but we are running out of ports and it would not hurt to go ahead and enter the 21st century and upgrade to...
  2. leftee

    Slow Pervasive Performance

    Alright, after doing some considerable searching and reading i think i am beginning to understand a little better how the cache settings work in pervasive. If i understand correctly pervasive uses 2 levels of caching. L1 ( cache allocation) and L2 ( Max Microkernel memory). and L1 is usually...
  3. leftee

    Slow Pervasive Performance

    here is the cache info you asked for Performance tuning: Cache allocation 2000 Max Microkernel Memory usage 40 Memory Usage: System Cache is not checked Allocate Resources on Startup is checked
  4. leftee

    Slow Pervasive Performance

    Here is what i find for cache settings . This is under the properties of the Microkernel. Is this the Cache info you were asking for ? I have posted screenshots at this link http://realshare.net/pcc/pcc.html
  5. leftee

    Slow Pervasive Performance

    I did not find any errors in any of the log files.
  6. leftee

    Slow Pervasive Performance

    In my research i found some info saying that with thes multicore processors you shoul change the power options in the Windows 2008 Server control panel to High performance instead of running at the default Balanced setting. It has helped. I had several people stop me and ask what i had done to...
  7. leftee

    Slow Pervasive Performance

    #clients 30 users ... most of the time no more than 20 on at a time Server Version : 10.30.017000 Client Version : 10.30.017000 SP2 Version : 5.0.69 Server Specs: Dell PowerEdge T310 CPU Xeon X3450 2.67ghz 8 gig ram 40 gig HD broke up into C and D partitions. Raid controller...
  8. leftee

    Slow Pervasive Performance

    Can i run system analyzer with users logged on ? I'll check log files I'll find out what version clients are running. Thanks for the help .
  9. leftee

    Slow Pervasive Performance

    Let me start by admitting that i have very very little experience with Pervasive. I have been doing some other I.T. work for a company and they have asked me to help troubleshoot a problem with an ERP program they are using to run their manufacturing business. They are aware of my lack of...
  10. leftee

    copy pervasive database files to a different machine

    I am wanting to setup a lab environment so as to do some testing with a script i am writing that will do some updates to my existing pervasive database. I know i could setup a dummy database on exisiting server but i need to have the exact tables and data etc ... to work from. I will also be...
  11. leftee

    Check for Existing Records Before doing Insert

    If it will give me an error when it find a duplicate that will be OK. I'll check into it. thanks for the help. Side Note: This pervasive databse works with Globalshop ERP Do you have any experience working with Globalshop by any chance ? Thanks
  12. leftee

    Check for Existing Records Before doing Insert

    I am using a script of Ken Puls to insert data from my Excel sheet into a table in my pervasive database. It works great , but i have come to realize that i need to check and make sure that there are no existing records in my databse table that matches the data that i am about to insert. Long...
  13. leftee

    Excel data inserted into Pervasive Table using a VB Script

    YoooHooo , it is now working !! i figured out why the insert statement was not adding my other columns .... i had my name range defined wrong in the excel sheet. Thanks so much for the help on the insert statement code , i have worked and worked and was about to give up. i can tell...
  14. leftee

    Excel data inserted into Pervasive Table using a VB Script

    here is the result of the query: Query: Insert INTO (Hours) Values('12') i get the same update error. i may be wrong but that number 12 should not have the '' around it. here is what the insert statement should read based on the column headings i am using Insert INTO...
  15. leftee

    Excel data inserted into Pervasive Table using a VB Script

    nevermind the end of statement error i figured out what that was.. it was a typo error on my part. the dbPath is = 192.168.1.70 it pulls that from cell B1 in the excel sheet.
  16. leftee

    Excel data inserted into Pervasive Table using a VB Script

    Thanks for the response. I entered those lines you suggested and i get a error saying "and end of statement is expected" with the = sign right after the strindsSQL being highlited. any ideas ? The error message: There was an error. Update was not succesful this is generated from the...
  17. leftee

    Excel data inserted into Pervasive Table using a VB Script

    I am working on a project where i am trying to get rows of data in a Excel sheet inserted into my Pervasive Database on my network server. I have found a VB script that will connect to an Access databse and insert data into it. It works great. I thought i might be able to change the code a bit...

Part and Inventory Search

Back
Top