Possible to have link server in the connection string?

Hi,
I have an application which requires a server name (connection string)
in the configuration for connection. There isn't any big issue if I am
just connecting to a regular server. e.g. just entering the server
name (server1), however, now my question is is it possible to put in a
linked server within a server name e.g. server1..linkserver1? In fact,
I need the connection to linkserver1 instead. I have a linkserver
since the server can't be connected directly.
Please advice the exact format (e.g. server1..linkserver1 ) if there
is any. Thanks in advance. And your help would be greatly appreciated.On Feb 28, 12:26=A0pm, sweetpota...@.gmail.com wrote:
> Hi,
> I have an application which requires a server name (connection string)
> in the configuration for connection. There isn't any big issue if I am
> just connecting to a regular server. e.g. just entering the server
> name (server1), however, now my question is is it possible to put in a
> linked server within a server name e.g. server1..linkserver1? In fact,
> I need the connection to linkserver1 instead. I have a linkserver
> since the server can't be connected directly.
> Please advice the exact format (e.g. server1..linkserver1 ) if there
> is any. Thanks in advance. And your help would be greatly appreciated.
Or
If this is the configuration setup:
Server Name: Server1
Database Name: linkserver1..DB1
Will that work?
Thanks

Possible to have link server in the connection string?

Hi,
I have an application which requires a server name (connection string)
in the configuration for connection. There isn't any big issue if I am
just connecting to a regular server. e.g. just entering the server
name (server1), however, now my question is is it possible to put in a
linked server within a server name e.g. server1..linkserver1? In fact,
I need the connection to linkserver1 instead. I have a linkserver
since the server can't be connected directly.
Please advice the exact format (e.g. server1..linkserver1 ) if there
is any. Thanks in advance. And your help would be greatly appreciated.
On Feb 28, 12:26Xpm, sweetpota...@.gmail.com wrote:
> Hi,
> I have an application which requires a server name (connection string)
> in the configuration for connection. There isn't any big issue if I am
> just connecting to a regular server. e.g. just entering the server
> name (server1), however, now my question is is it possible to put in a
> linked server within a server name e.g. server1..linkserver1? In fact,
> I need the connection to linkserver1 instead. I have a linkserver
> since the server can't be connected directly.
> Please advice the exact format (e.g. server1..linkserver1 ) if there
> is any. Thanks in advance. And your help would be greatly appreciated.
Or
If this is the configuration setup:
Server Name: Server1
Database Name: linkserver1..DB1
Will that work?
Thanks