Hi 

 How can I connect an HTML Page to Sql server?

 What could be the best way for it?

Thanks

Vikash 

Turn the .html page into a aspx page, or configure your IIS to treat .html pages as if they were .aspx files, so they are processed by ASP.NET:

IIS -> select the web site -> Properties -> Home Directory -> Configuration -> Mappings

Actually, there is probably an awful lot more to it than that, so just re-doing the pages as .aspx is probably going to be easier. 

Thanks  Mikesdotnetting

 But I have the need of this functionality in only 4-5 pages.

So I am not able to change the complete project so please suggest me any other alternative or should I use the VB Script?

Thanks

. 

Yes, you could use (server-side) VBScript, but then you would have to map the .html files to asp.dll, so they are treated by IIS as classic asp pages.  I'm afraid .html files are not capable on their own of any server-side processing.  That means you only have the two choices I outlined above: change the .html files to server-side files, or fool IIS into thinking they are.

 Ok. I am using these HTML page in my vb 2005 Project.

 Thanks

Hi viki,

        You need to use server side language to access your database.... Html pages are client side that executes on the client side. You will need to convvert your html pages to asp.net to connect to your server..

Hope this helps U....