I am still having error 162 problems with Arcserve6 and Btrieve. Btrieve 7 is a total GUI environment and I am at a loss as how to navigate to the Microkernel database engine system resource setting. I am trying to increase the Active Client resource setting.can anyone help ?
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Accessing Btrieve 7's microKernel Database Engine. 2
- Thread starter bondini
- Start date
-
1
- #2
handlewithcare
Programmer
I find the Pervasive GUI is a bit of a nightmare as it's so different to the previous versions. Try editing the BTI.INI directly and this should help.
-
1
- Thread starter
- #3
handlewithcare
Programmer
According to the Pervasive spec, Error 214 occurs when a user has Alter rights to a table and has rights to every column in the table. I'm not 100% sure what this means, but you could try revoking access to the table before making changes to it, and then regranting access afterwards.
If you not making table changes, then the above does not apply, in which case let me know what you're doing and I'll see if I can help.
If you not making table changes, then the above does not apply, in which case let me know what you're doing and I'll see if I can help.
- Thread starter
- #5
Handlewithcare,appreciate you helping.I am simply trying to perform a restore from Arcserve6.As you drill down through the directories you will eventually be confronted by Btrieve error 162 and obviously not be capable of going any further.I'm not sure if the data on the tape is retrievable or not but I would like to take this as far as is possible.
Your opinion would be valued as I would like to let the user know if this problem can be resolved.
Again , thanks in advance for your help.
Your opinion would be valued as I would like to let the user know if this problem can be resolved.
Again , thanks in advance for your help.
handlewithcare
Programmer
I did a bit of checking, assuming that the error is not being caused by data corruption, increasing the Active Clients settings should solve this problem. I used the following setup to do this in Pervasive 7.
1. Click Start, Programs, then Pervasive SQL 7.
2. Select Configuration (Setup) from the list of programs.
3. If you are running from a client, click Connect and type the name of the server.
4. Select MicroKernel Database Engine from the list of components.
5. Select System Resources/Directories from the list of categories for the MicroKernel Database Engine.
6. Select the Active Clients setting.
7. Increase this value. I found that it always needs to be higher than you think. Setting it too high may reduce server performance.
Hope this helps
1. Click Start, Programs, then Pervasive SQL 7.
2. Select Configuration (Setup) from the list of programs.
3. If you are running from a client, click Connect and type the name of the server.
4. Select MicroKernel Database Engine from the list of components.
5. Select System Resources/Directories from the list of categories for the MicroKernel Database Engine.
6. Select the Active Clients setting.
7. Increase this value. I found that it always needs to be higher than you think. Setting it too high may reduce server performance.
Hope this helps
- Status