Dynamic AI - Pervasive SQL
Posted: 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.
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.
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.
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:
- 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.
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.
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.
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.
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:
- 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.