1. sivaraj manoharan
  2. PowerBuilder
  3. Tuesday, 3 April 2018 09:25 AM UTC

We have recently migrated Powerbuilder application from 6 to 2017. We are using MS SQL Server 2012.In PB6 we have used MSS Microsoft SQL Server 6.x as connection string. in PB2017 we have changed the connection string to "SNC SQL Native Client(OLE DB) " . After migration and Build, EXE is working from developer machine but not from User Machine. Copied all SQLNCLI* files to the application folder. but no luck. Please help us to resolve the issue.

Accepted Answer
Michael Hartnett Accepted Answer Pending Moderation
  1. Tuesday, 3 April 2018 11:14 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Sivaraj

You might also need to install the SQL Native Client Driver on the Client PCs in order to connect to the DB using the SQLNC interface.

For SQL Server 2012, you can use the SQLNCI11 driver 

32 BIt - http://go.microsoft.com/fwlink/?LinkID=239647&clcid=0x409

64 Bit - http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409

Hope that helps.

Michael

Comment
There are no comments made yet.
sivaraj manoharan Accepted Answer Pending Moderation
  1. Sunday, 15 July 2018 05:11 AM UTC
  2. PowerBuilder
  3. # 1

Dear Michael, Installed SQL Server Native Client 9 and 11 and tested with SQLNCLI and SQLNCLI11 and copied the DLLs to application folders. Both are working. Thanks for your support.

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.