Connecting to SQL server via another server using ODBC

[dmaranan]

Hello,

I have a SQL Server (MSSQL 2000) whose port is blocked by my IS department, but is accessible through a web server (Adv. Serv 2003). Is there a way to connect to the SQL server via my web server using an ODBC connection?

Bacially I want to make ODBC calls from my desktop to the database server via the webserver using ODBC.

 

[SQLDenis]

How about OPENROWSET look it up in BOL

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/