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??
tan3587
0
Newbie Poster
Recommended Answers
Jump to PostIf your web layer includes SQL code, yes, you can access the tables on D1 by running the queries against ServerA.
All 2 Replies
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
If your web layer includes SQL code, yes, you can access the tables on D1 by running the queries against ServerA.
tan3587
0
Newbie Poster
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.