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.

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, then a 'success' message will be displayed. If the connection fails, then 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.

 

 

See Also

Configure Database Drivers

Creating a New Table