I have an ASP Page using this code:
Set rs = Server.CreateObject("ADODB.RecordSet")
h = 20
sql = "SELECT [Code], [Temp], [FLike], [Cond], [Icon], [City], [Sort] FROM [tblWeather] ORDER BY [Sort]"
rs.Open sql, conn, 1, 3
IIS Is returning this error:
0x80004005 Unspecified error
Both the data server and the IIS server are part of the same domain. The user running the ASP pages in IIS has access to the mdb file. The mdb file is not currently locked (no ldb). There is no one in the database.
The only way I can get this to work is to have an Administrator run the page. I have restarted the server, triple checked the database, everything!
Do any of you have any help?