• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • powerbuilder 12.6 connection to a MSSQL linked server

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

Resolved powerbuilder 12.6 connection to a MSSQL linked server

  1. Issue
0
Votes
Undo
  1. Giuseppe moglia
    Giuseppe moglia
  2. PowerBuilder
  3. Friday, 17 March 2017 16:47 PM UTC

Hi Guys

do you know how to set SQLCA connection parameters in order to connect my pb 12.6 app to a linked server on MSSQL 2012?

We already connect to a MSSQL Server Database but we also need to connect to a linked server on this DB (customer requirement)

Any hints?

Thanks

  1. Build
PB Example Code for Adding a Member to a Active Di...
64 bit migration: Are all Hwnd & Handles the same...
Responses (3)
Giuseppe moglia
Giuseppe moglia Accepted Answer Pending Moderation
  1. Wednesday, 22 March 2017 15:51 PM UTC
  2. PowerBuilder
  3. # 1

Thank you guys

I've already connected in SQL Management studio this DB so I've a DB named A from a server B as a linked server on a C MSSQLServer, my goal is set up the SQLCA parameters in order to connect to server C and database A

Do you think it's possible?

Thanks

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 17 March 2017 17:16 PM UTC
  2. PowerBuilder
  3. # 2

You can add linked servers using visually in SQL Server Management Studio (SSMS).

The 'linked server' is linked to the server you are already connecting to in your app. It will appear to your app as another database on the existing server.

 

Comment
There are no comments made yet.
Chris Pollach
Chris Pollach Accepted Answer Pending Moderation
  1. Friday, 17 March 2017 17:11 PM UTC
  2. PowerBuilder
  3. # 3

Hi Guiseppie;

  You would access the "Linked" server through your local SQL Server. The key would be to ...

  1. Create a linked server definition by running sp_addlinkedserver in your local SQL Server.
  2. Connect to your local SS as per normal a normal SS connection.
  3. Now Access the linked server from your regular DML.

Client tier, server tier, and database server tier

HTH

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.