ASP insert

[ecurtin]

Hi there

This has probably been touched on a few times in here previously but after searching this forum and google I have not found an answer. And online tutorials seem useless and don't help me.

I am writing some ASP to connect to my SQL database - both on the same server, but on different HDDs. I have created a form and am now writing the insert page. I am copying the code from an existing form and insert page that works fine. I'll copy the code I am trying to recreate below:

<!--#include virtual="/DBconns/connTACSupport.asp"-->
<%
    set oUpload = server.createobject("ASPUpLoad.clsUpload")
 
    If oUpload.Form("RequestDesc") = "" Then
        Response.Redirect "newticket.asp?error=true"
    End If
 
    Dim strFileName, Requester, Department, RequestDesc, TicketStatus
 
strFileName = oUpload.FileName
Requester = oUpload.form("ID")
Username = Session("LOGON_USER")
Department = oUpload.form("DeptID")
RequestDesc = oUpload.form("RequestDesc")
Cause = oUpload.form("Cause")
Resolution = oUpload.form("Resolution")
TicketStatus = "Open"
EngineerDetail = "Ticket Opened"
ScreenShot = "Screenshot"
 
' insert ticket into tbltickets
insertTicket = "INSERT INTO tblTickets (Requester, Username, Department, TicketStatus) VALUES ('" & Requester & "', '" & Username & "', '" & Department & "', '" & TicketStatus & "')"
    connTACSupport.execute(insertTicket)
 

Now this does not include any connection open strings but when I create the same thing with different fields, it says:

Microsoft VBScript runtime error '800a01a8' 
 
Object required: 'connTACSupport' 
 

I have tried adding a line like this instead:

 data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _ 
            Server.MapPath("tblcontractreview")
 
sql_insert = "INSERT INTO tblContracts (Requester, Username, Director, Department, TicketStatus) VALUES ('" & Requester & "', '" & Username & "', '" & Department & "', '" & Director & "', '" & ContractStatus & "')"
 

But I don't know what to put in the Server.MapPath would be as it is on a different drive.

Any thoughts anyone?

Thanks in advance!

[jhardman]

But I don't know what to put in the Server.MapPath would be as it is on a different drive.

Any thoughts anyone?

Thanks in advance!

you don't need a mapPath statement, you just need the actual file path beginning with drive letter. alternatively you can create a DSN entry (in your settings --> administrative tools --> data sources) and just refer to that in your data source. I'm not sure I could walk you through making a DSN, but you could google that. If I remember right, w3schools.com has a database tutorial under "ado" which covers a lot of it.

Personally, I dislike using insert statements, I would rather use Select statements along with "addnew", and I wrote an article about how to use that to insert a new record in a db in the articles section, but that is just my own preference.

Jared