Opening a database in .ASP?

  • Thread starter Thread starter thenewmadmax
  • Start date Start date
T

thenewmadmax

Guest
I'm trying to open a database in .asp but for the life of me my code wont work. Can anybody figure out what I'm doing wrong?

<!-- #include file="adovbs.inc" -->
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "databasename"
sql = "SELECT * FROM repair"
Set rsadd = Server.CreateObject("ADODB.RecordSet")
rsadd.Open sql, conn, adLockOptimistic, adCmdTable
'set the recordset space to write a new record
rsadd.Addnew


I keep getting the error "ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."
on the line: rsadd.Open sql, conn, adLockOptimistic, adCmdTable

Please, any input would help.
 
Back
Top