Preparing to use the SQL Server database

Before you define the database interface and connect to a Microsoft SQL Server database in PowerBuilder, follow these steps to prepare the database for use:

  1. Install and configure the required database server, network, and client software.

  2. Install the SQL Native Client database interface.

  3. Verify that you can connect to the Microsoft SQL Server server and database outside PowerBuilder.

Step 1: Install and configure the database server

You must install and configure the database server, network, and client software for SQL Server.

To install and configure the database server, network, and client software:

  1. Make sure the Microsoft SQL Server database software is installed and running on the server specified in your database profile.

    You must obtain the database server software and required licenses from Microsoft Corporation. For installation instructions, see your Microsoft SQL Server documentation.

    Upgrading from an earlier version of SQL Server

    For instructions on upgrading to a later version of SQL Server or installing it alongside an earlier version, see your Microsoft SQL Server documentation.

  2. If you are accessing a remote SQL Server database, make sure the required network software (for example, TCP/IP) is installed and running on your computer and is properly configured so that you can connect to the SQL Server database server at your site.

    For installation and configuration instructions, see your network or database administrator.

  3. Install the required Microsoft SQL Native Client software on each client computer on which PowerBuilder is installed.

    You must obtain the SQL Native Client software from Microsoft. Make sure the version of the client software you install supports all of the following:

    The operating system running on the client computer

    The version of the database that you want to access

    The version of PowerBuilder that you are running

    For installation instructions, see your Microsoft SQL Server documentation.

  4. Make sure the SQL Native Client client software is properly configured so that you can connect to the SQL Server database server at your site.

    For configuration instructions, see your Microsoft SQL Server documentation.

  5. Make sure the directory containing the SQL Native Client software is in your system path.

  6. Make sure only one copy of the Sqlncli.dll file is installed on your computer.

Step 2: Install the database interface

In the PowerBuilder Setup program, select the Custom install and select the SQL Native Client database interface.

Step 3: Verify the connection

Make sure you can connect to the SQL Server server and database you want to access from outside PowerBuilder.

To verify the connection, use any Windows-based utility that connects to the database. When connecting, be sure to specify the same parameters you plan to use in your PowerBuilder database profile to access the database.