Server Undefined

[HotBob]

Hi there I wanted to insert a record into a database using javascript, such as

function InsertSP()
		{
		var strConn = 'Driver={SQL Server};Server=**;Database=**;Uid=**;Pwd=*;';
		var oConn = Server.CreateObject("ADODB.Connection");
		oConn.Open(strConn);
		var oRS = Server.CreateObject("ADODB.Recordset");
		oRS.ActiveConnection = oConn;
		oRS.CursorType = 3;
		oRS.LockType = 3;
		oRS.CursorLocation = 3;

		oRS.Source = "INSERT INTO tblName(StoredProcedure) VALUES ('Test')";
		oRS.Open();
		oRS.Close();

}

However, I get the error Server Undefined?

Any ideas?

 

[BabyJeffy]

You will need to put in valid values for the server, database, UID and Password.

Cheers,
Jeff

[tt]Jeff's Page @ Code Couch

http://www.codecouch.com/jeff/blog/

http://www.coedit.co.uk/

[/tt]

What is Javascript? FAQ216-6094

 

[BillyRayPreachersSon]

The code you have given is server-side JS - if you are running it client-side, it will fail.

Hope this helps,
Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

[tt]Dan's Page [blue]@[/blue] Code Couch

http://www.codecouch.com/dan/

[/tt]