Member Avatar for tan3587

I have created a linked server in ms sql 2005 on server machine A . It links to another database(say D1) located physically on a different server machine B. I have jsp code on Server A which accesses local database on server A. Can I access the remote database D1 using the link server in my jsp code the same way as I access other local tables??

  • 2 Contributors
  • 2 Replies
  • 184 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by tan3587
Member Avatar for JorgeM

If your web layer includes SQL code, yes, you can access the tables on D1 by running the queries against ServerA.

Member Avatar for tan3587

SQL code

my web layer is written in JSP that has java code embedded in it to connect to MS SQL Server.
Thanks a lot for clearing my doubt!!1:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.