Connection between PowerBuilder and Sybase SQL Server

Connection between PowerBuilder and Sybase SQL Server

Although PowerBuilder and Sybase SQL Server are both products of Sybase, they use PowerBuilder as the front-end. When Sybase SQL Server is used as the back-end, they may fail to connect properly due to improper settings and other reasons. Of course, the open client should have been installed and correctly configured, and the data in the server database can be queried through wisql or Sybase advantage.

Generally, PowerBuilder cannot connect to the Sybase Database because of the following reasons:

1) locales. dat is incorrectly set

Locales. dat is a client-side character set file, which is generally in the C:/Sybase/locales/directory. If the operating system platform is Windows 95, modify the content in [nt]; if the operating system platform is Windows 3.x, modify the content in [win3.
A. There should be a line of country settings related to China:
Locale = CHS, us_english, iso_1
B. The default Character Set settings on the client side should be consistent with those on the server side.
In this example, set the default Character Set of the client to iso_1:
Locale = default, us_english, iso_1

2) After the SQL Server is reinstalled, pbsyc. SQL is not run:

Pbsyc. SQL is used to create the system tables and stored procedures required by PowerBuilder In the Sybase Database. It is located in the server directory of the PowerBuilder installation disk. Before PowerBuilder connects to the database for the first time, or after Sybase reinstalls, you must log on to the "master" database with "sa" in iSQL or Sybase advantage to run

Pbsyc. SQL

In addition, if the connection is Adaptive Server 11.5, you must first pair pbsyc. make the following changes to the SQL file: Replace "@" with "@", but retain "@ error" and "@ isolation"

3) Powerbuilder is 32-bit, but open client is 16-bit:

Since PowerBuilder needs to connect to the database through open client, open client must be 32-bit or 16-bit with PowerBuilder.

4) The native driver or ODBC driver of Sybase is not installed ):

PowerBuilder must use native driver or ODBC driver to access the database. Therefore, if you need to access the Sybase Database, native driver or ODBC driver is required.

5) The server name defined in the open client is inconsistent with the value set by sqlca. servername in the powerbuilder application.

6) The Path Name Of The dll library of PowerBuilder is not added to the system search path.ProgramSome DLL libraries are required for running, so you need to add the path of the PowerBuilder dll library to the system search path.

The default dll library installation path is as follows:

Long file name installation: (pb6.0) C:/program files/powersoft/shared/

Long file name installation: (pb5.0) C:/program files/common files/powersoft shared/

when installing short file names: C:/PWRs/sys32/