NOTE: If you have an automatic installation of Scriptcase, the Sybase PDO DBLIB and Sybase PDO ODBC drivers are already enabled.
Here is how to create a connection in your Scriptcase project using the Sybase database.
1 - Access any project from your Scriptcase.
2 - Click on the New connection icon to create a connection.
or go to the Database > New Connection menu.
After that a new page will appear with all the database connections.
3 - Select the Sybase connection.
Enter the parameters for connecting to your Sybase database as follows:
Connection Name: Define the name of your new connection. By default, Scriptcase adds the prefix conn along with the database name.
DBMS Driver: Select the Sybase Driver used to connect. In this example, we use the Sybase Driver.
serverdomain.com
or 192.168.254.170
Port: Inform the number port for your database server.
Username: Inform the user to authenticate the connection to your Sybase database.
Password: Enter the password to complete the authentication process.
Accessing this tab, you can configure which Database items will be displayed on the connection, depending or not on the owner.
It allows the Sybase connection to see tables, views, system tables and procedures depending on the items selected by the user. By default, the items Tables and Views are already selected by Scriptcase.
System Tables: By selecting this option, the system tables of your database will be displayed.
Allows you to define which tables and owners are displayed.
PREFIX%
or name of the tables to display.NOTE: By using table filtering, you eliminate unnecessary tables for your project and improves the performance of your database connection.
In this tab, you have access to specific settings for the connection. The changes made in this session impact the data display and application performance.
client_encoding: Select the encoding used in your database. In the example above, we use the client_encoding UTF-8.
.
is selected as a separator.By default, Scriptcase enables this option.
E.g.
Doubts or Connection Problems? Contact our Support Team in case of connection problems or questions regarding this database.