• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Error when creating database profile in PB2017R2-1756 to connect to SQL Server

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

Resolved Error when creating database profile in PB2017R2-1756 to connect to SQL Server

  1. New
  2. Issue
0
Votes
Undo
  1. Daniel Seguin
    Daniel Seguin
  2. PowerBuilder
  3. Friday, 22 November 2024 00:18 AM UTC

I have a client that is using using PB 2017 R2 - build 1756

I will be migrating it to PB 2022 R3 in the new year 2025.

But before we do that migration, the client wants to migrate from Sybase ASE to SQL Server

In order to test the connectivity between PB 2017 and SQL Server, I have created this database profile, but I am getting this error

 

Can you advise please,

 

Thanks,

 

Daniel Seguin

 

Powergen Documentation
Software fails to execute after migration from PB1...
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 22 November 2024 01:09 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Daniel;

  FYI: newer SS DBMS installations no longer provide the SNC DB Client. Microsoft deprecated that driver in 2015. So unless you have an old installation of SNC, the newest SS's will not have it. The last SS version with the SNC driver was SS2016.

  Even if you did install the old SNC DB Client, it's last supported SS version was also 2016. So using that DB driver with SS2022 would not support all of that SS version's DML features.

  Since SS2016 & higher, Microsoft replaced SNC with the the new MSOLEDBSQL DB client driver. Newer PB versions now also support this latest driver. I would suggest to that to condider switching over to that newer SS connectivity going forward.

HTH

Regards ... Chris 

Comment
Daniel Seguin
  1. Daniel Seguin
  2. Friday, 22 November 2024 01:19 AM UTC
Hi Chris,



Thanks for the info.

In PB 2022, I have MSO SQL Server driver integrated

So I think we should move to PB 2022 R3 at the same time of doing the database migration, right?

Daniel



  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 22 November 2024 01:25 AM UTC
That sounds like a prudent move to me. ;-)
  1. Helpful 1
There are no comments made yet.
Responses (2)
Daniel Seguin
Daniel Seguin Accepted Answer Pending Moderation
  1. Friday, 22 November 2024 02:06 AM UTC
  2. PowerBuilder
  3. # 1

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.