sql server connect: 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?

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.developersdex.com ***

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

Bahij,
actually found this for you on MSDN which is simpler than my example:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthopenclosevbscriptx.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