Welcome, Guest. Please Login.
03/29/24 at 07:47:46
News:
Home Help Search Login


Pages: 1
Send Topic Print
Pervasive 10 (Summit) (Read 4762 times)
Tim Goldstein
Full Member
***


'Cause sooner or
later everyone needs
a chief geek

Posts: 213
Gender: male
Pervasive 10 (Summit)
12/21/07 at 14:00:33
 
For those of you plannning on upgrading (and those are are just interested)  there are a couple of items to watch when you do an upgrade.
 
First things first.  Pervasive 10  is designed to work better with windows networking and caching, 64 bit OS's and Windows Vista.  Along with that,  thay have made changes in ODBC, and naming conventions and name and path lengths.  because of this you need to be very carefull when you upgrade.  I have already made most of the mistakes so I thought I'd pass them on.
 
1:  pre release 10 versions installed by default to C:\PVSW.  However,  10 installs to C:\PROGRAM FILES\PERVASIVE SOFTWARE\PSQL and C:\DOCUMENTS AND SETTINGS\ALLUSERS\APPLICATION DATA\PERVASIVE SOFTWARE\PSQL  This will cuase problems on upgrades!
 
2: Pre release 10 versions had a propriatary ODBC interface.  Extended Features and functions were not supported through ODBC.  Version 10 is fully ASNI V2 ODBC.
 
3:  Version 10 nolonger supports Netware or DOS!  Only Windows and Linux.
 
Due to these changes  when you upgrade,  you need to do the following:
 
1:  Write down all DSNs used (Caps count!) on the server and workstations.  
2:  Delete all DSNs under ODBC.  There is a install bug that will want to point to the old dir for the DLLs and your install will lock or fail.
3:  In the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\  and HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\  Delete all the keys that reference Paervasive Client Interface and Pervasive Engine.  (this is part of the bug above!)
4:  Delete C:\PVSW and C:\PVSWARCH directories.
5:  Reboot
6: Install Pervasive 10 Server or Workstation and/or Client. (yes the above has to be done on the clients also!
7:  Enter PCC and recreate your Server DSN (Not the name(s) in step 1!  When creating the DSNs do not select Version 2!  If you do you will not be able to see tables or read data!  
8:  Verify Evo and any ODBC connections (Crystal Reports)
9:  Repeate steps 1-8 for all workstations and terminals.
 
Failure to follow these steps can result in corruption of DSNs, and failure to install Pervasive 10 with the with removeal of all previous versions!  If you do miss a step,  you will have to reinstall your previous version of Pervasive then follow the steps above.
 
Couple of great things about version 10:
 
1: Terminals have full use of PCC and monitor without changes to the registry!
2: Data can be compressed for higher throughput!
3: the path to .B files can be 128 characters long (was 20)!
4: The file names themselves can be 128 characters long (was 8.3)!
5: True 64 bit processesing without playing with the registry or memory!
6: Accelerated I/O (for systems that qualify) and data sets larger that 2 GB!
7:  ADO.NET 2.0 and Visual Studio 2005 support.
8: True ODBC compatability with OEM/ANSI conversion!
9:  Includes a backup app, Improved security, and a DDF builder.
 
Hope it helps,
 
 
Tim
Back to top
 
 

Tim
Email WWW timgolds timgolds   IP Logged
kkmfg
Senior Member
****


Ghost of the code

Posts: 411
Gender: male
Re: Pervasive 10 (Summit)
Reply #1 - 12/24/07 at 07:21:38
 
Sounds like they finally saw the light and decided to attempt to make their product at least half decent.  Some of those changes were 10 years over due.
Back to top
 
 

Collin
K & K Manufacturing, Inc

EvoERP Version 1-22-10 SP3
5 User Workgroup Pervasive 10
Email WWW   IP Logged
chrisbowden
Full Member
***


Doing it all with
DBA.

Posts: 106
Gender: male
Re: Pervasive 10 (Summit)
Reply #2 - 01/28/08 at 18:45:19
 
Tim, I'm working the boss over trying to get him to let me upgrade from 2000i to ver 10.  Since you've been through a conversion, see if you can help me with something.  I currently use Access to publish some custom-written reports and I of course pull the data into Access through the ODBC interface.  I know that the System Data Source Name (DSN) must be explicitly named, and all of my reports depend on queries which are linked directly to the System DSN setup on each user's ODBC Administrator's Control Panel.  So, as part of the uninstall/re-install process, do you anticipate that I would be able to re-create the System DSN under PSQL 10 with the same naming scheme so that all of my Access queries & reports would function as before without any re-writing?  I want to try to avoid having to re-create all of the queries under a new System DSN name as this would take quite a bit of time (and frankly be a pain in the butt!)
 
Also, Lynn said that Pervasive has improved the ODBC performance over 2000i.  Any idea about how much performance (say 10%, 20%, etc.) we might hope to see if we upgraded to PSQL 10?  We have a 5-user license and our "server" is just an XP Pro machine, and Lynn expressed some doubt about us achieving much through-put improvements because we are so small.  Just wondered what you're opinion on this is.
 
Thanks!
Chris
Back to top
 
 

Chris Bowden
Amstar Foods LLC
ISTech 2004.1 12/21/08 - 5 user - Classic & Evo - patch as of 01/07/09
Pervasive 2000i SP3 / XP Pro
  IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Re: Pervasive 10 (Summit)
Reply #3 - 05/16/08 at 13:07:57
 
Tim, is the above mentioned install bug still a bug?  This post is pretty old.  I am hoping that maybe it has been fixed by Pervasive....
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print