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

Resolved Powerbuilder EXE is connecting to SQL Server.

  1. Issue
1
Votes
Undo
  1. sivaraj manoharan
    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.

  1. Build
Verify dw filter by PB
SQL Server Bit value converts from 1 to -1 automat...
Accepted Answer
Michael Hartnett
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.
Responses (2)
sivaraj manoharan
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.