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:
-
Install and configure the required database server, network, and client software.
-
Install the SQL Server (MSOLEDBSQL) or SQL Native Client (SNC) database interface.
-
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:
-
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.
-
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.
-
Install the required Microsoft OLE DB Driver for SQL Server or SQL Server Native Client software on each client computer on which PowerBuilder is installed.
You must obtain the Microsoft OLE DB Driver for SQL Server or 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.
-
Make sure the Microsoft OLE DB Driver for SQL Server or 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.
-
Make sure the directory containing the Microsoft OLE DB Driver for SQL Server or SQL Native Client software is in your system path.
-
(For SQL Native Client) Make sure only one copy of the Sqlncli.dll file is installed on your computer.
Step 2: Install the database interface
If you install PowerBuilder using the PowerBuilder Installer (an online setup program), the SQL Server database interface and the SQL Native Client database interface are automatically installed. If you install PowerBuilder using the downloaded installation package (an offline setup program), select Native Database Interfaces | SQL Server (MSOLEDBSQL) or SQL Native Client (SNC) from the list of components.
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.
