[PB] DBMS is not supported in your current installation Solution

Source: Internet
Author: User
Tags sybase

First case:

If you click the db profile toolbar button in the PB environment, select the corresponding interface, and click "new ...",

Solution:

When we use native drivers of PowerBuilder to connect large databases such as Sybase or Oracle, sometimes the database cannot be connected, the system prompts "dbms xxx is not supported inyour current installation ".

This is because we have not correctly installed or set up PB native driver or database Client software (such as Sybase's Open Client ). There are three specific reasons:

1. powerBuilder is installed with 32 bits, while Database client software is installed with 16 bits; or PowerBuilder is installed with 16 bits, the database client software is installed with 32 bits.

2. The path of the native driver's DLLs is not included in the machine's system path.

3. The path of the database client software's DLLs is not included in the machine's system path.

The solution for the above three reasons is as follows:

1. Confirm that PB and database client software are both 32-bit or 16-bit.

2. path of the pb running environment (5.0 32-bit long name: \ Program Files \ CommonFiles \ Poweresoft Shared, 5.0 32-bit short name or 5.0 16-bit: \ pwrs \ sys32, 6.0: \ Program Files \ Powersoft \ shared) to the machine's system path (autoexec. bat path ). Or, for example, use the sqlserver database to copy ntwdblib. dll to the system32 folder.

3. add the path of the database Client software DLLs (for example, Sybase Open Client path \ sybase \ bin, Oracle SQL * NET Path \ orawin \ sys32) to the system path of the machine.

Case 2:

When there is no problem in the first case, and a prompt appears when the program is running

Solution:

This error is not caused by SQL ANYWHERE. It is because the DBMS attribute of SQLCA is not correctly set. Most people often love to use the ProfileString function for SQLCA attribute settings when using PB development programs,The file name parameters often do not contain paths.,Or the absolute path is used.. In either case
The file cannot be found in ProfileString. In this way, the DBMS attribute of SQLCA is not assigned a value. Therefore, the message "dbms not Support..." appears.
Of course, if it is a relative path, it will only appear in the PB development environment. In this case, you only need to use the PB text editor to open the INI file once, so that the current directory of PB is returned to the directory where the INI file is located.
There are still many beginners who use the INI file PB. INI, that is, Sqlca. dbms = ProfileString ("pb. ini "," database "," dbms "," "). This file exists in the installation directory of pb. Therefore, do not use this file name when setting the database connection, PB changes every time you connect to a different database. iNI. This is often the case. In addition, this program cannot be run on another machine unless you Copy PB. INI

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.