MS SQL problemer
Lige siden jeg skiftede fra min Access database til en MS SQL database har jeg fået en Intern HTTP Serverfejl (500) ved denne kode når jeg skullet tilføje en record:Set rs = Server.CreateObject(\"ADODB.RecordSet\")
strSQL = \"Select * From profiles\"
rs.Open strSQL, Conn, 1, 3
rs.AddNew
rs(\"username\") = username
rs(\"sex\") = sex
rs(\"age\") = age
rs(\"realname\") = realname
rs(\"country\") = country
rs(\"email\") = email
rs(\"icq\") = int(icq)
rs(\"website\") = website
rs(\"password\") = password
rs(\"job\") = job
rs(\"datecreated\") = strDate
rs(\"picture\") = \"nopic.jpg\"
rs(\"lastupdated\") = strDate
rs(\"hits\") = \"0\"
rs(\"birthday\") = birthday
rs(\"freetext\") = freetext
rs.Update
errormsg = \"<font>Your profile was succesfully created, you may now login using:<br>Username: \" & server.htmlencode(username) & \"<br>Password: \" & server.htmlencode(password) & \"</b></font><br>\"
end if
Nogen forslag til hvad problemet kan være?
