Dynamic AI - Pervasive SQL

Support information related to Pervasive SQL Databases

Dynamic AI - Pervasive SQL

Postby Carsten Sørensen » Fri Jan 16, 2009 10:33 pm

Connecting Dynamic AI to Pervasive SQL

To connect Dynamic AI to a Pervasive SQL database, open the database connection screen in Dynamic AI and select Pervasive SQL from the Type list.

Enter the ODBC name/System DSN (or create an ODBC connection - see below).

Specifying Owner/Catalog is optional. However in some cases it will be needed when a table is used more than once in the same database.

In most cases dbo.tablename is used.

Depending on the Pervasive SQL setup Username and Password might be needed.

Image

Test the connection by pressing the ‘Test Connection’ button.

Click SAVE to save the connection. Now you should see the database in the database Explore and be able to browse and use Tables and Views of the database

Pervasive Control Center

The Pervasive Control Center must be installed to get a Pervasive SQL database. In the control center the database can be made. User rights can be given to the database.

Image

The Pervasive database and the Pervasive control center are delivered with the software with the Pervasive database included.

A trial can be downloaded from: http://ww2.pervasive.com/Database/Trial ... loads.aspx

ODBC

To get the connection to work, the ODBC driver for Pervasive SQL should be installed. This can be checked in the Control Panel -> Administrative Tools -> ODBC Driver.

Under the tab System DSN press ‘Add’. Check whether the Pervasive SQL Engine Interface ODBC driver is installed.

Image

Follow the next steps:
- Go to the Control Panel
- Go to Administrative Tools
- Go to ODBC data Sources
- Go to the tab System DSN
- Click ‘Add’
- Select the Pervasive ODBC Engine Interface

The next screen will appear:

Image

- Provide the name for the data source. (this name is used in Dynamic AI)
- Provide a description (optional)
- Provide the database name
- Press ‘OK’

The data source is now installed and can be used in Dynamic AI.


Interested in a free Dynamic AI Personal edition? Download the latest version from: http://www.dynamicai.com/download.htm

Would you like a Dynamic AI Server edition trial version please contact: info@dataaccess.nl

If you have any questions, you are always welcome to contact one of our partners (more information available at: www.dynamicai.eu , www.dynamicai.com) in your country, or e-mail your questions directly to: info@dataaccess.nl




Copyright © 1998-2009 CINTAC A/S and/or its suppliers. All rights reserved. Dynamic AI ™, Dynamic Financials ® and CINTAC Dynamic are registered trademarks or trademarks of CINTAC A/S.
PERVASIVE, PERVASIVE SOFTWARE, PERVASIVE SOFTWARE LOGO, PERVASIVE.SQL, PERVASIVE PSQL V9, BTRIEVE, CLIENT/SERVER IN A BOX, SOLUTION NETWORK, DATA JUNCTION, TANGO, ULTRALIGHT, PRIMe METHODOLOGY BUILT ON PERVASIVE, BUILT ON PERVASIVE SOFTWARE, PERVASIVE DATARUSH, PERVASIVE DATATOOLS, PERVASIVE INTEGRATION MANAGER, PERVASIVE BUSINESS INTEGRATOR, PERVASIVE DATA INTEGRATOR, PERVASIVE SAAS BUSINESS INTEGRATOR, PERVASIVE SAAS DATA INTEGRATOR, PERVASIVE DATA PROFILER, PERVASIVE MESSAGESTORE, PERVASIVE AUDITMASTER, PERVASIVE DATAEXCHANGE, and PERVASIVE BACKUP AGENT are trademarks, service marks or registered trademarks of Pervasive Software Inc. in the United States and/or other countries. All other company, product, and service names may be trademarks or service marks of their respective owners.
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Return to Pervasive SQL

cron