Analytica Business Systems: Pervasive.SQL and Btrieve Specialists

Pervasive.SQL, Btrieve and More KnowledgeBase | Article #51 | DSN Issues
View an Article   Back
Title: DSN Issues 
Category: Pervasive ODBC 
Keywords: dsn, system, user, create 
Description: Here are some issues regarding DSNs:

If you're going to use a DSN to connect to a database on a Pervasive.SQL server, it's usually best to create a System DSN rather than a User or File DSN, so that anyone who logs in to the workstation will be able to access the database. The usual method of creating a DSN is to use the ODBC Administrator. This is time-consuming due to the wizardy nature of the interface, so if you have lots of clients that you need to establish DSNs for, you can get around it several ways:

1. Automate the DSN creation. You can do this via:
a. Registry imports
b. Writing a standard MS/ODBC application
c. Writing a Pervasive DTI/DTO application
d. Writing an automation routine using a scripting language such as WinBatch.
2. Use a DSN-less connection (have the application provide the needed sonnection string to go right to the server).


If you like our free Pervasive Knowledge Base Service, please consider purchasing your next Pervasive Software Product from our online store or call or email us!

In the meantime, to help us keep this service free, would you mind clicking on one of the ads at the left? Thanks for visiting!