Pervasive 7 to 8 DSN query 1

[TomKane]

Hi,

I'm currently looking at upgrading from P.SQL7 to P.SQL8 and would be grateful if you could advise me on the DSN element of this.

Our environment is that we have 5 data sets on our server and each client that accesses the data has a dsn configured per data set.

We have a production server and a brp server and the dsns are pointed at a network share. With this being the case if we needed to switch to the brp server we would just change the network share to point at the brp server equivalent.

I have read the documentation and understand that the old v7 DSNs will have to be deleted and new ones created.

The issues that I'm wondering about are as follows:

1) Can I just recreate my DSNs on the client side - do I need a server side or engine dsn as well?

2) It appears that you have to specify a server name in the client dsn that indicates where the data is - are client dsns dedicated to a particular server or can this be overridden.

Thanks a million,
Tom

 

[mirtheil]

To answer your questions:
1. You'll need to create a client and an engine (server) DSN.
2. WHen the DSN is created, they point to a specific server. If the server being accessed is variable, you would need to create a new DSN for each server. You could also use a DSNless connection from the client side (you would still need the engine DSN).


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[TomKane]

Thanks for that mirtheil - I've been doing some testing and think we'll go the dsn less route.