Unanswered: need help with asp connection to sql server 2003
i am new to ASP. i'm trying to create a small application on my default website on my computer. this application is supposed to connect to an SQL server (which i already have configured) and return rows from a table. but it's giving me an error saying th OLE DB provider for SQL server does nnot exist or acess denied. error numbe is HTTP 500.100
could anyone help me?
can u also suggest any online asp tutorials that are trustworty???
It sounds like you may need to install the OLEDB provider for SQL Server. There isn't an SQL Server version 2003 that I'm aware of, so I'll assume that's the Windows version and guess you're running SQL Server 2005? Make sure that's correct before installing the following: