Manual ODBC Connection for Updating to RDPWin Version 2.xxx
Article ID: KWin0040 - Updated
6/12/08
Added by Suzette and Steve W.
Issue
The first time you run RDPWin Version 2.xxx
you will be prompted with the Administrator Logon screen this screen sets up the
ODBC connection on the Pervasive data server and is needed to successfully run
RDPWin Version 2.xxx.
Enter the password for the Administrator and click OK. If this process
fails, this screen will continue to be displayed and the customer should contact
RDP Support immediately at 970-845-7108.
Steps for Pervasive 9.0 or
higher users
Steps for Pervasive 8.7 users
Steps Using ODBC Administrator
Pervasive's website
offers the following link for
Error 1918. Error Installing ODBC driver.
Steps for Pervasive 9.0 or Higher Users
- Login to the RDP Data server and set Registry for Pervasive access
See K000163.HTM
- Go to Start/Programs/Pervasive/Control Center.
- Expand Engines.
- Expand "Server".
- Right-click on Database and select New, then Database as shown here.
At the New Database screen:
- Enter the Database Name as RDP01.
- Enter the Location as "c:"\RDPNT (Location of DDFs).
- Bound should NOT be checked.
- "Create dictionary files" should NOT be checked.
- "Relational integrity enforced" should be checked.
- "Create DSN" should be checked.
- Set "Open Mode:" to Normal.
- Metadata - Version 1 should always be checked.
- Click Finish.
- Right-click the new connection that was created and select Properties.
- In the Properties window, click Remove to eliminate the directory listed in the Data
Directories section.
- Click the New button, enter the path shown below, and click OK.
- The Properties window should display as:
- Click Apply
- Click OK
- Still have a connection issue? See
Pervasive 10 ODBC Connection Issue.
Steps for Pervasive 8.7 Users
- Login into the data server & Set Registry for Pervasive
interface
See K000163.HTM.
- Go to Start/Programs/Pervasive.sql8/Control Center
- Expand Engines.
- Expand "Server".
- Right-click on Databases (Engine) and select New DataBase....
- Fill in the Name field with the name of the RDP directory you are
creating the OBDC connection. For most customers this will be RDP01.
- Fill in the Directory field with the path to the RDP directory.
You must use the UNC path. For example: \\"rdpdataserver"\rdpnt\rdp.
- Check "Use advanced settings".
- Click the Next button.
- Verify that all fields on the "Create Database Wizard for Pervasive.SQL"
match the sample screen below:
- Click the Create button (located next to the "Database name"
drop-down) to create a new DSN
(Data Source Name).
- Check "Integrity enforced".
- Uncheck "Bound (DDF created)".
- Set "Betrieve security policy" to Classic.
- Change "Dictionary location" to the location of .ddf files
(Data Dictionary Files). For example:
\\'rdpdataservername'\rdpnt\rdp.
- Verify the data file location is correct. The
location should be where the RDP data files are filed. For
example:
\\'rdpdataserver'\rdpnt\rdp\rdp01.
- Click OK, and then Next.
- Verify all information is correct, and click Finish.
The database should be successfully created.
- Click Close.
Use ODBC Administrator to Create ODBC Connection
- Login to the RDP Data server & set Registry for Pervasive
See K000163.HTM
- Control Panel, Administrative Tools, Data Sources (ODBC).
- Click the System DSN Tab.
- Click the Add button. Note: If RDP01 exists and
you are still having problems, see Correcting Pervasive Java
Error K-Base Article.
- Select "Pervasive ODBC Engine Interface".
- Click Finish to open the Pervasive ODBC Engine Setup Screen.
- Set following fields:
- "Data Source Name" - RDP Directory (i.e. RDP01).
- Description - leave as default.
- Click the Create button.
- At the Create Database screen (shown below):
- Database Name = RDP Directory (i.e. RDP01).
- Integrity Enforced = CHECKED.
- Bound (DDF’S Created) = UNCHECKED.
- Btrieve security policy = Classic (OS authentication and authorization).
- Dictionary Location = C:\RDPNT\RDP or RDP root directory location.
- Data File Locations = Delete current location and add the following:
- C:\RDPNT\RDP\RDP01 or corresponding RDP Data folder.
- By default, the data dictionary location is added, RDP’s data is one
level deeper. This is why the original entry is deleted and re-added.
- Click OK.
- Click the Test button to make sure the connection can be made. (This
can
take several seconds).
- Click OK at the "Connection Successful" prompt.
- Click OK.
- Click OK to complete the process.
ODBC Connection Problem
with Pervasive 10?
How do I turn off Data Execution
Prevention Errors?
- Check the RDPWinPath.txt file. Confirm the path is
correct. If it is a client computer, make sure it is using
the UNC path.
- Open Pervasive control center and verify the Database
(canister) RDP01 exists with the correct dictionary location and
data directory paths. This is usually the problem.
- Go to ODBC source administrator and verify the System DSN
RDP01 exists.
- Run the pervasive system analyzer. The relational test
should point to the RDP01 DSN. If this passes, go to Step
5. If it does not pass, skip to Step 7.
- Verify the RDP01 tables are visible in the Pervasive Control
Center. If not, skip to Step 7. Otherwise, continue with
Step 6.
- Run a select statement in Pervasive Control Center on a
small data file in the RDP01 directory. If this passes, try to
restart RDPWin.
- Delete the System DSN in ODBC Data Source Administrator, and
Delete the RDP01 database in Pervasive Control Center.
- Reboot.
- Add the RDP01 database with the correct Dictionary and Data
Directory paths in the Pervasive Control Center. Verify
that the DSN exists in Data Source Administrator.
- Repeat Step 5 & 6.
- If all fails, call RDP Support and/or reload pervasive.
