Wednesday, March 7, 2012

IIS 6.0 with sql backend connectivity

Can somebody please send me a link or reference on how to
configure a website using IIS 6.0 to connect to a SQL on
the backend?
Thank you.Bahij,
the topics you need to check out are ASP, ASP.NET, ADO, ADO.NET (there are
alternatives but this is a good starting place).
Searching for these topics on Google will give loads of decent sites. If you
are stuck, then email me and I can give you a simple demo page which works
against Northwind and you can just stick it in IIS to see the whole thing
working.
Regards,
Paul Ibison|||Paul,
can you please email me that code sample to bnahhas@.austin.rr.com ?
Thank you so much for your time and effort.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Bahij,
actually found this for you on MSDN which is simpler than my example:
http://msdn.microsoft.com/library/d...evbscriptx.asp.
To get it to work, you'll need to add the windows user IUSR_IISCOMPUTERNAME
as a login on your sql server. If IIS and SQL are on the same box, nothing
else is required, but if not you'll need to change the following:
Data Source=" & _
Request.ServerVariables("SERVER_NAME")
to
Data Source=YourSQLServer
HTH,
Paul Ibison

No comments:

Post a Comment