powerbuilder 12.6 connection to a MSSQL linked server

1
0
-1

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

Question Tags: 

Answers

Chris Pollach answered powerbuilder 12.6 connection to a MSSQL linked server

1
0
-1

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