I use Vbscript in asp file....

This is my code.

PHP Code:

Set conn=OpenConnection(MyDb(0)) 

Dim rs2

set rs2=CreateObject("ADODB.Recordset")
sql2="select * from TV" 
rs2.Open sql2, conn

Insert data into database
rs2.AddNew 'This is line 102
rs2("Jobfile") = "File 12"
rs2.Update 


This error occured.

PHP Code:

Object required: 'rs2'
/somis/drafttitles/TvGenerate.asp, line 102 


What does this mean?

it means rs2 wasn't created / opened in the previous line

Anything amiss in my code?

nothing obvious but not sure about the use of the OpenConnection method because I have no idea what MyDb(0) is

do some basic debugging and response.write out the various variables so you can see if they are created and valid.

And for a good connection strings resource:

Connection String Home Page
http://www.carlprothman.net/Default.aspx?tabid=81