ODBC connection to a seperate machine

I'm curious, can you set up a ODBC connection on one server, that points
to another computer on the network where the database is? I've tried
the computer name as //server2, but it doesn't seem to find it, yet, I
can get to it via the RDC within WinXP Pro.
Thanks,
Steve"Steve Grosz" <boise_bound@.hotmail.com> wrote in message
news:eZknx$7UEHA.2520@.TK2MSFTNGP10.phx.gbl...
> I'm curious, can you set up a ODBC connection on one server, that points
> to another computer on the network where the database is? I've tried
> the computer name as //server2, but it doesn't seem to find it, yet, I
> can get to it via the RDC within WinXP Pro.
I do not believe that is allowed as which security credentials would be used
from the ODBC connection from server1 to server2? There are work-arounds,
for example you could use a linked server from SQL Server (say on server1)
and access the database on server2 from server1.
Stevesql

ODBC connection to a seperate machine

I'm curious, can you set up a ODBC connection on one server, that points
to another computer on the network where the database is? I've tried
the computer name as //server2, but it doesn't seem to find it, yet, I
can get to it via the RDC within WinXP Pro.
Thanks,
Steve
"Steve Grosz" <boise_bound@.hotmail.com> wrote in message
news:eZknx$7UEHA.2520@.TK2MSFTNGP10.phx.gbl...
> I'm curious, can you set up a ODBC connection on one server, that points
> to another computer on the network where the database is? I've tried
> the computer name as //server2, but it doesn't seem to find it, yet, I
> can get to it via the RDC within WinXP Pro.
I do not believe that is allowed as which security credentials would be used
from the ODBC connection from server1 to server2? There are work-arounds,
for example you could use a linked server from SQL Server (say on server1)
and access the database on server2 from server1.
Steve