Pervasive.SQL Connection Properties
This dialog is used to help form a connection string to a secured Pervasive database.
If your Pervasive database is not configured as a secured P.SQL database, then you will not use a connection string.
For more information about Pervasive connection properties, refer to Pervasive.SQL Database and Security.
Connection Properties
Table
- The table in the database to open.
Server Name
- Enter the server name, or host, where the P.SQL database is located.
User Name
- Enter the user name to use for authentication when you log on to the P.SQL database.
Password
- Enter the password for your user name.
Database Name
- Enter the name of the database that needs to be accessed.
Test Connection
- Click the Test Connection button to test the connection properties that you have entered.
- The Studio will attempt to connect to the database using these settings.
- If a connection is established, a 'success' message will be displayed.
- If the connection fails, an error is displayed showing the full connection string that was used.
Make Default
- Click the Make Default button to make the connection properties in this dialog the new default connection settings for the current workspace.
OK
- Click OK to use the entered connection properties to form the connection string for the new table that you are creating.
Cancel
- Click Cancel to close this dialog without using the entered connection properties.