June 21, 2005 at 7:27 am
Hi everybody,
The subject is explict. I want to access a database in memory from a URL. I know that with Microsoft SQL Server 2000 it is possible.
Can somebody help on this please ?
Thank you very much.
June 21, 2005 at 7:29 am
What do you mean by Access???
You can interact with a db with an asp page (or .net C#/ASP.net). But the access work is done on the server, not in the url. The only thing remotely related to the url is the parameters sent from the previous pages, which are used to display the relevent data on the page.
June 21, 2005 at 7:36 am
Thank you for responding.
Actually what i want to do is to type an URL in wich i can retreive data from a db on another computer.
Is this possible ?
June 21, 2005 at 7:43 am
Yes, but as I said, this is something that needs to be coded in some asp page. Or any web language. You need to find tutorials to do this... I can't show you from scratch.
June 22, 2005 at 6:30 am
I'm not sure exactly what you want to do, but you might want to look at the Microsoft SQL Server Web Data Administrator:
June 22, 2005 at 8:08 am
Check in Books Online, if you have it, under "XML and Internet Support",
there is a section on "Accessing SQL Server using HTTP"
A link to the online version:
http://msdn.microsoft.com/library/en-us/xmlsql/ac_xml1_022c.asp?frame=true
Hope this helps you get started!
-- J.Kozloski, MCDBA, MCITP
June 27, 2005 at 10:16 am
You need to configure SQL XML support in IIS
Then you can execute query to you DB from the IE
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply