Is it possible to create a virtual directory to access a remote SQL
server on a web server that does not have SQL installed on it? I have
previously used the Configure SQL XML Support in IIS tool, and I was
hoping that this could still be installed on a server that has IIS but
not SQL on it. If it can, I would be very grateful to anyone who could
tell me how to do it. If it cannot, I would be equally grateful for
any other solutions to my problem.
Many thanksYou access remote SQL Server, typically, via TCP at certain port (1433 as
default) at certain location (computer name or IP address), plus appropriate
authentication. It has nothing to do with virtual directory on the web
server.
<clockemail@.alltel.net> wrote in message
news:1181750810.617111.24060@.i38g2000prf.googlegroups.com...
> Is it possible to create a virtual directory to access a remote SQL
> server on a web server that does not have SQL installed on it? I have
> previously used the Configure SQL XML Support in IIS tool, and I was
> hoping that this could still be installed on a server that has IIS but
> not SQL on it. If it can, I would be very grateful to anyone who could
> tell me how to do it. If it cannot, I would be equally grateful for
> any other solutions to my problem.
> Many thanks
>|||On Jun 13, 12:04 pm, "Norman Yuan" <NotR...@.NotReal.not> wrote:
> You access remote SQL Server, typically, via TCP at certain port (1433 as
> default) at certain location (computer name or IP address), plus appropriate
> authentication. It has nothing to do with virtual directory on the web
> server.
> <clockem...@.alltel.net> wrote in message
> news:1181750810.617111.24060@.i38g2000prf.googlegroups.com...
>
> > Is it possible to create a virtual directory to access a remote SQL
> > server on a web server that does not have SQL installed on it? I have
> > previously used the Configure SQL XML Support in IIS tool, and I was
> > hoping that this could still be installed on a server that has IIS but
> > not SQL on it. If it can, I would be very grateful to anyone who could
> > tell me how to do it. If it cannot, I would be equally grateful for
> > any other solutions to my problem.
> > Many thanks- Hide quoted text -
> - Show quoted text -
Sorry, I should have been more specific. I need to make JavaScript
XMLHttpRequests to an SQL Server on a remote server, which I can
currently do by using virtual directories as both the database and
website are on the same server. However, both are moving to different
servers, and the web server does not have SQL installed on it.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment