Connecting to the DBMS

To connect VISUAL PLANNING to the installed DBMS, open the VISUAL PLANNING portal.

In Microsoft Windows, go to Start > All Programs > VPServer Enterprise 6 > VP application portal.

The first time you open this portal, the following page appears:

Choose the server language and click Next.

The DBMS connection configuration page opens.

Select the DBMS. The following options are available:

SQL Server

When using Microsoft SQL Server, select SQL Server in the list.

Click Next to continue.

Then enter the information about the SQL Server that has already been installed (see Installing the DBMS):

  • Server Name / IP​​: to use a particular instance name for VISUAL PLANNING, add it with the IP ​​address​​ of the server (e.g., 127.0.0.1\​​sqlexpress​​ ) where ​​sqlexpress​​ is the name of the instance,​
  • Port: The default value is 1433. If a different port is used, replace 1433 with the value of the port,

  • User: see Installing the DBMS

  • Password: see Installing the DBMS

Click Next to continue.

MySQL

When using MySQL, select MySQL in the list.

Click Next to continue.

Then enter the information about the MySQL server that has already been installed (see Installing the DBMS):

  • Server name / IP: if the version of MySQL supplied by STILOG I.S.T. is used, leave the server address 127.0.0.1. Otherwise, enter the IP address of the MySQL server.

  • Port: The default value is 3306. If a different port is used, replace 3306 with the value of the port,

  • User: see Installing the DBMS,

  • Password: see Installing the DBMS.

Click Next to continue.

Oracle

When using Oracle, select Oracle in the list.

Click Next to continue.

Then enter the information about the Oracle server that has already been installed (see Installing the DBMS):

To avoid problems with uppercase and lowercase, enter all the information (except the password) in UPPERCASE.

Click Next to continue.

MS Access

Caution

Using Microsoft Access is not recommended for configurations with more than five users.

When using MS Access, select MS Access in the list.

Click Next to continue.

Then enter the information about MS Access that has already been installed (see Installing the DBMS):

  • Directory: the default value is {vp.home}/msadatas, where {vp.home} is the root of the VISUAL PLANNING installation. If the data is stored in another director, change this value accordingly.

Click Next to continue.

PostgreSQL

When using PostgreSQL, select PostgreSQL in the list.

Click Next to continue.

Then enter the information about PostgreSQL that has already been installed (see Installing the DBMS):

Click Next to continue.

MariaDB

When using MariaDB, select MariaDB in the list.

Click Next to continue.

Then enter the information about the MariaDB server that has already been installed (see Installing the DBMS):

Click Next to continue.

ghostghostghostghostghost
loading table of contents...