03. oktober 2002 - 17:34
Der er
5 kommentarer og 1 løsning
Object doesn't support this property or method: 'Open'
Jeg får følgende fejlmeddelelse: Object doesn't support this property or method: 'Open' /workstatistics/index.asp, line 27 Min kode ser sådan her ud: If Request.Form("WhatWasChosen") = "ConvertNowChosen" Then Set objConn = Server.CreateObject("ADODB.Connection") strConnString = "Provider=SQLOLEDB;" & _ "Persist Security Info=FALSE;" & _ "USER ID=sa;" & _ "Password=pb16950;" & _ "Initial Catalog=Workstatistics;" & _ "Initial File Name = C:\Programmer\Microsoft SQL Server\MSSQL\" & _ "DATA\WorkStatistics_Data.mdf;" objConn.Open strConnString strSQL = "SELECT Arbejdstimer_IN, Primary_Key_BI FROM WorkProjects_T" objRS = Server.CreateObject("ADODB.Recordset") objRS.Open strSQL, objConn, AdOpenStatic, AdLockOptimistic, AdCmdText objRS.MoveFirst strSQL = "UPDATE WorkProject_T SET Arbejdstimer_IN = '" & intMin & "'" & _ " WHERE Primary_Key_BI = '" & intPrimaryKey & "'" Do While Not ObjRS.EOF intHours = objRS("Arbejdstimer_IN") intMin = intHours * 60 intPrimaryKey = objRS("Primary_Key_BI") objConn.Execute (strSQL) objRS.MoveNext Loop objRS.Close Set objRS = Nothing objConn.Close Set objConn = Nothing End If Hvad er der galt?
Annonceindlæg tema
Forsvar & beredskab
Cybersikkerhed, realtidsdata og robuste it-systemer er blevet fundamentet for moderne forsvar.
03. oktober 2002 - 17:35
#1
Linje 27 er der hvor der står objRS.Open.
03. oktober 2002 - 17:37
#2
objRS = Server.CreateObject("ADODB.Recordset") skal være Set objRS = Server.CreateObject("ADODB.Recordset")
03. oktober 2002 - 17:43
#3
Tak for det ;0)
03. oktober 2002 - 17:43
#4
Forudsat at din connectstreng er korrekt burde dette kunne gøre det: If Request.Form("WhatWasChosen") = "ConvertNowChosen" Then strConnString = "Provider=SQLOLEDB;" & _ "Persist Security Info=FALSE;" & _ "USER ID=sa;" & _ "Password=pb16950;" & _ "Initial Catalog=Workstatistics;" & _ "Initial File Name = C:\Programmer\Microsoft SQL Server\MSSQL\" & _ "DATA\WorkStatistics_Data.mdf;" set conn=server.createobject("adodb.connection") objConn.Open strConnString strSQL = "SELECT Arbejdstimer_IN, Primary_Key_BI FROM WorkProjects_T" Set objRS = objConn.Execute(strSQL) strSQL = "UPDATE WorkProject_T SET Arbejdstimer_IN = '" & intMin & "'" & _ " WHERE Primary_Key_BI = '" & intPrimaryKey & "'" While Not ObjRS.EOF intHours = objRS("Arbejdstimer_IN") intMin = intHours * 60 intPrimaryKey = objRS("Primary_Key_BI") objConn.Execute(strSQL) objRS.MoveNext Wend objRS.Close Set objRS = Nothing objConn.Close Set objConn = Nothing End If
03. oktober 2002 - 17:44
#5
Skriv lige et svar!
03. oktober 2002 - 17:50
#6
svar
Kurser inden for grundlæggende programmering