Unable to open registry key 'Temporary (volatile) Jet DSN
HejNår jeg forsøger at kører min bannerrotation, får jeg følgende besked:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x510 Thread 0x54c DBC 0x477d024 Jet'.
/banner/vis.asp, line 6
Her er hele scriptet:
<% @ LANGUAGE = VBScript %>
<%
DS = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DS = ds & "DBQ=D:\inetPub\data\banner.mdb"
Set DB_Banner = server.createobject("ADODB.connection")
dette er linie 6: DB_Banner.Open ds
Set RedirectInfo = DB_Banner.Execute("SELECT * FROM BannerData WHERE BannerID = "&Request.QueryString("ID")&"")
BannerCount = RedirectInfo("BannerKlik") + 1
DB_Banner.Execute("UPDATE BannerData SET BannerKlik = "&BannerCount&" WHERE BAnnerID = "&Request.QueryString("ID")&"")
URL = RedirectInfo("BannerLink")
DB_Banner.Close
'response.write url
'response.write BannerCount
Response.Redirect(URL)
%>
Hvad er der galt og hvad gør jeg?
Mvh
Mogens