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
TestFile.doc 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

 

[MAK9974]

Please take a look at this.

http://support.microsoft.com/default.aspx?scid=KB;en-us;q163475

 

[mwolf00]

This error is different (same code) than the one you posted in that asp forum...

"TestFile.doc database insert failed. "

The ".doc" indicates that you are not working on the server-side (indicated by ".asp" in this case). Simply try renaming your document "testFile.asp" and make sure that you are calling it through the server (the path in the address bar should not begin with a local drive letter "c:\testFile.asp" - It should be something like : "

http://localHost/mySite/testFile.asp")

Get the Best Answers! faq333-2924
Merry Christmas!
mikewolf@tst-us.com
[santa2]

 

[JGresko]

mwolf00 Thanks for your help.

I may not have identified my problem specific enough so here's a clarification:

The file isn't being inserted to the database, just a reference to it's location (in string format)

I think the problem is at the cmd.Execute line... the sql that is created works fine if I execute it on it's own (outside ASP)... so this is really an ASP problem, but I hoped someone on this list would have experience executing insert statements via ASP against an SQL Server database.

Just for reference, the insert statement I'm trying to execute is:

INSERT INTO FileCheck
(id, Path, Document, UserName, CreateDate)
VALUES (NEWID(), 'D:\InetPub\

http://wwwroot\FE_with_DB\Docs',

'TestFile.doc', 'JGresko', GETDATE())

 

[mwolf00]

Like I said in the .asp forum:

Change
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]

 

[JGresko]

and as I also said in the other forum... that was it

Thank You and Happy Holidays