Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved PB use SNC protocol

  1. Advice
0
Votes
Undo
  1. william yau
    william yau
  2. PowerBuilder
  3. Wednesday, 20 January 2021 07:17 AM UTC

Hi Guru

 

 I upgraded PB 7 to PB 2019 r2 version.  if PB connect to Ms  SQL use SNC protocol. PB 

datawinodws cannot display the field that have more than 100 characters.  datawindow can shows more than 100 words if use odbc or OLE DB. but I would like to generate 64 bits PB executable file. I found OLE DB cannot not

create 64 bit executable file. 

 My question is how to make datawindow field display  more than 100 characters use SNC protocol 

 

best regards

William  

Powerbuilder 2017R3 and TFS Source control
Security patches of embedded CEF-browser
Responses (2)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 20 January 2021 17:09 PM UTC
  2. PowerBuilder
  3. # 1

Hi William,

Just FYI, the SNC is obsolete per Microsoft's website and PowerBuilder 2019 R3 supports the new MSOLEDBSQL driver.

Here is a Webinar recording about how to switch over to the new driver... very easy: https://youtu.be/tSaUqXHQ85Y

Best regards,
Armeen

Comment
william yau
  1. william yau
  2. Thursday, 21 January 2021 10:20 AM UTC
but PB connect MSILEDB , cannot generate 64 bit executable file
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 21 January 2021 15:08 PM UTC
You need PB 2019 R3 not R2 and the correct string is MSOLEDBSQL and you need a new runtime DLL of R3. I can guarantee you it works for 64-bit... we have tested this.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 20 January 2021 16:26 PM UTC
  2. PowerBuilder
  3. # 2

Hi William ;

  PB's DWOs in general can support handling 32K worth of textual datum per column regardless of the DB driver type used to connect to SS. It has been that was since PB 1.0. I currently use PB2019 R2 over to SS2019 using SNC with no data text limits <=32K).

  Your problem sounds like it could be either:

  1. The DWO definition for the column is not correct respective to the SS table's schema definition
  2. You have a limiting factor in your SQLCA's DBParm field settings (ie: "PBMaxTextSize=nnn" - where nnn is too small)
  3. The column data type is TEXT vs Char or VarChar.

  What happens if you create a new DWO on that textual based Table/column?

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.