Avatar billede styrelse Nybegynder
13. december 1999 - 09:49 Der er 1 kommentar og
1 løsning

Logon user i global.asa

Helo

Jeg får en fejl efter jeg har tilføjet server variablen "logon_user". Fejlmeddelelsen er:

Microsoft OLE DB Provider for ODBC Drivers fejl '80040e07'

[Microsoft][ODBC Microsoft Access-driver] Datatyperne stemmer ikke overens i kriterieudtrykket.

/aida2/global.asa, linje 78 (Conn.Execute SQL)

Global.asa ser således ud:

<Script Language=VBScript RUNAT="server">
Sub Session_OnStart
Connection = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("statistik.mdb") & ";UID=admin;PWD=;"
set conn = server.CreateObject ("adodb.connection")
Conn.Open Connection

DateTimeEntrance = Now()
if len(Request.Cookies("Sample")) > 0 then
  CookieID = Request.Cookies("Sample")
else
  conn.execute "insert into cookies (DateCreated) " _
  & "values (#" & DateTimeEntrance & "#)"
  Set RSCookieID = conn.Execute("select CookieID from Cookies where " _
  & "DateCreated = #" & DateTimeEntrance & "#")
  CookieID = RSCookieID("CookieID")
  Response.Cookies("Sample") = RSCookieID("CookieID")
  Response.Cookies("Sample").Expires = #12/31/1999 00:00:00#
end if

set BC = server.createobject("MSWC.BrowserType")

IPAddress = Request.ServerVariables ("remote_addr")
UserAgent = Request.ServerVariables ("HTTP_USER_AGENT")
Browser = BC.Browser & "  " & BC.Version
DHTMLSupport = cstr(BC.dhtml)
FramesSupport = cstr(BC.frames)
TablesSupport = cstr(BC.tables)
CookiesSupport = cstr(BC.cookies)
BackgroundSounds = cstr(BC.backgrounds)
JavaScriptSupport = cstr(BC.javascript)
JavaAppletsSupport = cstr(BC.javaapplets)
ActiveXControlsSupport = cstr(BC.activexcontrols)
AOL = cstr(BC.aol)
Platform = cstr(BC.platform)
VBScriptSupport = cstr(BC.vbscript)

FullReferer = Request.ServerVariables("http_referer")
if len(FullReferer) <= 7 then
  RefererDomain = "-"
  RefererQuery = "-"
else
  SlashPosition = instr(8, FullReferer, "/")
  if SlashPosition = 0 then
    RefererDomain = FullReferer
    RefererQuery = "-"
  else
    RefererDomain = left(FullReferer, SlashPosition - 1)
    RefererQuery = right(FullReferer, len(FullReferer) - slashPosition)
  end if
end if

Logon = Request.ServerVariables("LOGON_USER")
  NTLogon = Right(Logon, 3)

SQL = "insert into Visitors (DateTimeEntrance, IPAddress, UserAgent, Browser, "
SQL = SQL & "DHTML, Frames, Tables, Cookies, BackgroundSounds, Javascript, "
SQL = SQL & "JavaApplets, ActiveXControls, AOL, Platform, VBScript, "
SQL = SQL & "RefererDomain, RefererQuery, CookieID, NTLogon) values ("
SQL = SQL & "'" & DateTimeEntrance & "', "
SQL = SQL & "'" & IPAddress & "', "
SQL = SQL & "'" & UserAgent & "', "
SQL = SQL & "'" & Browser & "', "
SQL = SQL & "'" & DHTMLSupport & "', "
SQL = SQL & "'" & FramesSupport & "', "
SQL = SQL & "'" & TablesSupport & "', "
SQL = SQL & "'" & CookiesSupport & "', "
SQL = SQL & "'" & BackgroundSounds & "', "
SQL = SQL & "'" & JavaScriptSupport & "', "
SQL = SQL & "'" & JavaAppletsSupport & "', "
SQL = SQL & "'" & ActiveXControlsSupport & "', "
SQL = SQL & "'" & AOL & "', "
SQL = SQL & "'" & Platform & "', "
SQL = SQL & "'" & VBScriptSupport & "', "
SQL = SQL & "'" & RefererDomain & "', "
SQL = SQL & "'" & RefererQuery & "', "
SQL = SQL & "'" & NTLogon & "', "
SQL = SQL & "'" & CookieID & "')"
Conn.Execute SQL

Set RSRecordID = Conn.Execute("select RecordID from Visitors where DateTimeEntrance = #"_
& DateTimeEntrance & "#")
Session("RecordID") = clng(RSRecordID("RecordID"))
End Sub

Sub Session_OnEnd
Connection = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("statistik.mdb") & ";UID=admin;PWD=;"
set conn = server.CreateObject ("adodb.connection")
Conn.Open Connection
Connection.execute "update Visitors set DateTimeExit = '" & Now() _
& "' where RecordID = " & Session("RecordID")
End Sub
</script>

Avatar billede styrelse Nybegynder
13. december 1999 - 09:56 #1
Ja - den løste jeg selv ;-)
Avatar billede mit Nybegynder
13. december 1999 - 09:57 #2
Det er samme fejl som sidst ;-)
http://www.eksperten.dk/spm.asp?id=8426

..Du mangler de 2 #'er..3-4 sidste linie
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester