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

Resolved PB17 connects with OLE DB, PB19 does not

  1. Issue
0
Votes
Undo
  1. JOHN THOMAS
    JOHN THOMAS
  2. PowerBuilder
  3. Thursday, 12 March 2020 20:47 PM UTC

Gents  - I am picking up the baton from this earlier question which is marked resolved:

https://community.appeon.com/index.php/qna/q-a/sql-native-client-support#reply-12700

After installing PB19 we have this problem now whereby the connection to our SQL Server db  (Microsoft SQL Server 2005 - 9.00.4035.00 ) will not connect using the OLE DB parm.  All the current PB17 stuff does connect still, with same parm. I have tried uninstall/reinstall of PB19 and still error. I have also tried using the MSOLEDBSQL in place of the current  PROVIDER='SQLOLEDB'  but no effect. See attached for my reinstall setup and error. Thanks in advance. 

Attachments (1)
ERROR on application run.pdf
App closed by itself
Performance RDP vs. TeamViewer
Responses (2)
JOHN THOMAS
JOHN THOMAS Accepted Answer Pending Moderation
  1. Friday, 13 March 2020 21:03 PM UTC
  2. PowerBuilder
  3. # 1

All - this turned out to be a problem with file paths/locations rather than a SQL Server mismatch. I am at a loss a little bit because in spite of our SQL Server 2005 only versions on the the two boxes we are working on the PB19 builds still connected. Not going to bother chasing it down now. Thanks.

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 13 March 2020 21:14 PM UTC
Thanks for letting us know the solution!
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 13 March 2020 00:14 AM UTC
  2. PowerBuilder
  3. # 2

Hi John;

   Note that SS2005 and even SS2008 are no longer supported by Microsoft.

SS2005:  EOL - 2016-04-12

SS2008:  EOL - 2020-01-14

   PB2019 supports SS2008R2 through SS2019 currently.

Note: You must install the SS DB Client that matches your DBMS version on the PB IDE machine.

Regards ... Chris

Comment
JOHN THOMAS
  1. JOHN THOMAS
  2. Friday, 13 March 2020 13:59 PM UTC
hey again Chris, thanks much for the fast answers as always. I guess that spells it out and we're behind enough already so they need to get on the stick. This whole PB upgrade we're doing is in tandem with a long-overdue Windows update also (I don't want to tell you how old the Windows version is on our prod box, yikes) so they might as well get the MSS updated too. I'm going to leave this "unresolved" and resolve it when we get everything working so I can give this a "works!" stamp of approval.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 13 March 2020 15:01 PM UTC
Hi John ... sounds like a good plan! Please keep us informed on your progress.
  1. Helpful
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.