Vbscript error Object required:'server'

[rathiagu]

the below is my part of


set cn = Server.CreateOb ject("ADODB.Con nection")

strCS = "Provider=Syste m.Data.SqlClien t; Data Source=" & _
Server.MapPath( "management.mdb ")& ";"

cn.open strCS

cn.Execute "INSERT INTO contract_covera ge ([coverage_id], [contract_covera ge]) VALUES (1111,'hi')"
cn.close

when executed the error "OBject required:'serve r'" occurs in the first line. I am not sure why this occurs.Can please anyone help me?

[debasisdas]

Moved to Visual Basic forum.

[QVeen72]

the below is my part of


set cn = Server.CreateOb ject("ADODB.Con nection")

strCS = "Provider=Syste m.Data.SqlClien t; Data Source=" & _
Server.MapPath( "management.mdb ")& ";"

cn.open strCS

cn.Execute "INSERT INTO contract_covera ge ([coverage_id], [contract_covera ge]) VALUES (1111,'hi')"
cn.close

when executed the error "OBject required:'serve r'" occurs in the first line. I am not sure why this occurs.Can please anyone help me?

Hi,

Somewhat confused here.. You have mentioned provider as SQL Client, but are refering to an Access DB.
ConnString for Access is :

"PROVIDER=MICRO SOFT.JET.OLEDB. 4.0;DATA SOURCE=" & Server.MapPath( "mydatabase.mdb ")

Regards
Veena

[rathiagu]

hi QVeen72,
Thanks for ur reply.i found ou the error ,the eroor was due to Server.Createob ject line, because i was running the script from windows and so it must be Wscript.Createo bject.Sorry for wasting all of your time.Thank you Again QVeen72

Hi,

Somewhat confused here.. You have mentioned provider as SQL Client, but are refering to an Access DB.
ConnString for Access is :

"PROVIDER=MICRO SOFT.JET.OLEDB. 4.0;DATA SOURCE=" & Server.MapPath( "mydatabase.mdb ")

Regards
Veena