Sending information to a SQL Server

[chmilz]

Hello all,

I am a webmaster for an IT Consulting Comapany's website. The company wants employees to be able to enter their timesheet information on line by way of a form (easy enough) then they want that information sent to a table in an SQL Database on the company server. Can THIS be done using VBScript?? Thanks for your ideas and replies in advance!

 

[HowardMarks]

Is this just a straight forward 'save to database' thing or am i missing something more complex?

If so are you after a basic explanation of adding and deleting records from a database? Nick (Web Developer)

http://www.retrographics.co.uk

nick@retrographics.co.uk

 

[chmilz]

Nick,

Yes,


I just want to be able to insert the data into a table on the SQL Server. Nothing to complex...

Thanks,
Chmilz

 

[ryan101]

A simple insert command that I use:

set ad = CreateObject("ADODB.Connection&quot
strConnect = "Provider=SQLOLEDB;Server=169.254.1.1;database=testdatabase;uid=dbaseuser"
ad.Open strConnect

form1 = Request.Form("field1&quot
form2 = Request.Form("field2&quot
form3 = Request.Form("field3&quot

strSQL= "INSERT INTO YOUR_TABLE(column1, column2, column3) VALUES('" & form1 & "','" & form2 & "','" & form3 & ')"
ad.execute(strSQL)