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...
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...
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
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
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...
#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...
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...
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...
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
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...
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...
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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.