ASP insert to SQL Server database 1

[JGresko]

I'm attempting to insert a record to a SQL Server database from an ASP webpage. I'm having trouble determining the best method to use to do this. My MSDN help files seem to be on vacation because they're not giving me what I need today.

Any pointers will be much appreciated!

Thanks, Judy

When I run the code below I get the following error:

Error#: 424 - Object required
Thatexplainsit.html database insert failed.


'open a database connection

strDSN = Application("FileExchange_ConnectionString")
 Set conn = Server.CreateObject("ADODB.Connection")	
 conn.Open strDSN

'Create a command object

Dim cmd
Set cmd = New ADODB.Command
Set cmd.ActiveConnection = conn
cmd.CommandTimeout = 15
cmd.CommandType = adCmdText

'Create the Insert SQL

tsql = "INSERT INTO FileCheck (id, Path, Document, UserName, CreateDate) VALUES (NEWID(),'" & Dir & "','" & newfilename0 & "','" & session("User") & "', GETDATE())"

cmd.CommandText = tsql
cmd.Execute

'Catch Errors

if Err <> 0 Then 
     errtext = &quot;Error#: &quot; & err & &quot; - &quot; & err.description
     & &quot;<BR>&quot; & newfilename0 & &quot; database insert failed.&quot;
End If

 

[mwolf00]

Before I get into this too far....

"Thatexplainsit.html database insert failed."

Is this page's extension ".html"? It should be ".asp" for server-side coding.... Get the Best Answers! faq333-2924
Merry Christmas!
mikewolf@tst-us.com
[santa2]

 

[JGresko]

This code is part of a file upload system.
"Thatexplainsit.html" is just a test document I was using.

The name of the uploaded file is just a text string and doesn't inpact the code at all.

 

[Tarwn]

What uis this doibng in your sql statement?
NEWID()

-Tarwn ________________________________________________________________________________
Want to get great answers to your Tek-Tips questions? Have a look at faq333-2924

 

[mwolf00]

try changing:
Set cmd = New ADODB.Command

to:
Set cmd = Server.CreateObject("ADODB.command&quot Get the Best Answers! faq333-2924
Merry Christmas!
mikewolf@tst-us.com
[santa2]

 

[onpnt]

ya, looks like a sub procedue/function call in there. hmm.. not going to work possibly? ---------------------------------------
{ str = "sleep is good for you. sleep gives you the energy you need to function";
ptr = /sleep/gi;Nstr = str.replace(ptr,"coffee"alert(Nstr); }
---------------------------------------
for the best results to your questions: FAQ333-2924

http://www.onpntwebdesigns.com

 

[Tarwn]

Nice catch
-Tarwn ________________________________________________________________________________
Want to get great answers to your Tek-Tips questions? Have a look at faq333-2924

 

[JGresko]

Thank you mwolf00 ! That was my problem!

Happy Holidays