1. Prasad Neelapala
  2. PowerBuilder
  3. Monday, 28 March 2022 11:42 AM UTC

Hi team,

 

we are using powerbuilder 2019R3 version and we are migrating from sybase to mssql. 

In which after connecting to sql server we did add sql server in db profile.

;Autocommit defaults to false if no entry here - can be overridden in users registry
Name=****
AutoCommit=true
DataBase=****
DBMS=SYC
DBParm=CharSet='iso_1',PWEncrypt = 'Yes'
Lock="RR"

 

and tried to run the exe but it gives "could not find dbms value error "

 

So kindly please advice how to resolve this please answer quickly its urgent

mike S Accepted Answer Pending Moderation
  1. Monday, 28 March 2022 17:22 PM UTC
  2. PowerBuilder
  3. # 1

did you install the MS SQL server client from microsoft?

 

as an alternative to SNC, you can use the very old oledb interface - it is deployed with the windows OS so you don't need to deploy/install the  sql server driver.

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Monday, 28 March 2022 15:49 PM UTC
  2. PowerBuilder
  3. # 2

Hi, Prasad - 

If you are switching to use SQL Server, you might wish to consider using the newer MSOLEDBSQL interface.

Regardless of whether you choose the SNC or MSOLEDBSQL interfaces, there is going to be a Microsoft-supplied component that needs to be installed on each client's PC in addition to the Appeon-supplied database interface (PBSNC.dll or PBMSO.dll).

Here is a link to download the MS-supplied SQL Server Native Client driver:

   https://www.microsoft.com/en-us/download/details.aspx?id=50402

Here is the download for the MS-supplied MSOLEDBSQL driver:

   https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

Please note there are separate installs for the 32-bit and 64-bit versions of the MSOLEDBSQL driver..

Below is a link to helpful information using the PB 2019 R3 SQL Server DB interfaces:

   https://docs.appeon.com/pb2019r3/connecting_to_your_database/ch03s04.html

Regards, John

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 28 March 2022 12:36 PM UTC
  2. PowerBuilder
  3. # 3

You need to have PBSNC.DLL available to the deployed app in the folder with the other PB runtime DLL files.

Comment
There are no comments made yet.
Prasad Neelapala Accepted Answer Pending Moderation
  1. Monday, 28 March 2022 12:35 PM UTC
  2. PowerBuilder
  3. # 4

I did not understand but can you describe briefly why this issue is caused and let me know what is the dbms value error and how do we fix it

Comment
There are no comments made yet.
Prasad Neelapala Accepted Answer Pending Moderation
  1. Monday, 28 March 2022 12:25 PM UTC
  2. PowerBuilder
  3. # 5

I added sql profile in database profile 

// Profile  SQL
SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = <********>
SQLCA.ServerName = "mss-nm-7057-aol.nam.nsroot.net,2431"
SQLCA.LogId = "prcmsdev"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Provider='SQLNCLI11',Database='PrcDb'"

 

connection is successful for sql but when i try to exe within powerbuilder i am getting the above error"could not find dbms value"

Comment
There are no comments made yet.
Prasad Neelapala Accepted Answer Pending Moderation
  1. Monday, 28 March 2022 12:23 PM UTC
  2. PowerBuilder
  3. # 6

Hi ,

 

I am able to connect to sybase successfully . 

we are using dbvis.exe for database

i am not able to connect to SNC sql native client 

Please let me know what should i do too resolve this

 

Comment
  1. Chris Pollach @Appeon
  2. Monday, 28 March 2022 12:31 PM UTC
The SNC interface is pretty straight forward. It's hard to say why your IDE cannot connect with a lot more information but, the major reason I find is that after installation, the DBA might have forgotten to turn on the TCP/IP protocol in SS itself. HTH
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 28 March 2022 12:17 PM UTC
  2. PowerBuilder
  3. # 7

Hi Prasad;

  Is the PB IDE able to connect to SS OK? Also, what DB client software are you using to connect to SS?

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.