Jscript connection string help 1

[biry]

Hi, i not too familkiar with JScript and an getting this error of Expected ";"
at this part:
connobj.open "DRIVER={SQL
------------^

any thoughts on this?

connobj.open "DRIVER={SQL Server};SERVER=localhost;DATABASE=DBNAME;UID="+ Application("ipo_admin")+";PWD=" + Application("ipo_admin_password") +";";

	rsobj = Server.createobject ("ADODB.recordset");
	rsobj.open(sql, connobj);

thanks

 

[chessbot]

Javascript, being client-side, is unable to interact with databases. Is this server-side?

--Chessbot

There is a level of Hell reserved for probability theorists in which every monkey that types on a typewriter produces a Shakespearean sonnet.

 

[cLFlaVA]

while I know negative zero about client-side js, if it even exists, my first suggestion would be to add parentheseseseseseses.

connobj.open("DRIVER={SQL Server};SERVER=localhost;DATABASE=DBNAME;UID="+ Application("ipo_admin")+";PWD=" + Application("ipo_admin_password") +";");

*cLFlaVA
----------------------------
[tt]insert funny quotation here.[/tt]

 

[tgreer]

It looks like Visual Basic, not JScript or JavaScript. Maybe even C#, since that terminates lines with semicolons.

If it IS C#, then your method arguments are wrapped in parens, as cLFlaVA suggested.



Thomas D. Greer

http://www.tgreer.com

Providing PostScript & PDF
Training, Development & Consulting

 

[biry]

the code works with a dsn connection but i wanted to change it to dsnless this is the page:
page which combines ASP and JScript, its the db connection with the problem in the first post:

<%@ Language=JavaScript%>
<%//response.buffer=false%>
<script language='vbscript' runat='server'>

<%
	var table = String(Request.QueryString("t"));
	var sortby = String(Request.QueryString("s"));
	var dir = String(Request.QueryString("d"));
	var cc = String(Request.QueryString("c"));

	if (table == "undefined") table = "sec10K";
	if (sortby == "undefined") sortby = "date_filed";

	if ((cc != sortby) || (dir == "undefined")) {
		if (sortby == "date_filed")
			dir = "desc";
		else
			dir = "asc";
	}

	var countSQL;

	if (cc == "undefined") cc = sortby;

	if (table == "sec45"){
		var sql = "select * from secfilings where form_type='4a' or " +
				"form_type='4' or form_type='5' order by " + sortby + " " + dir;
		countSQL = "select count(*) as count from secfilings where form_type='4a' or form_type='4' or form_type='5'";
	}else {
		countSQL = "select count(*) as count from " + table;
		var sql = "select * from " + table + " order by " + sortby + " " + dir;
	}

	if (sortby == "date_filed") {
		sql += ", company_name ";
		if (dir == "asc") {
			sql += "desc";
		} else {
			sql += "asc";
		}
	}


//'Database Connection

	if ( ! (connobj = Server.CreateObject("ADODB.Connection")) )
		Response.write("Connection failed");

connobj.open "DRIVER={SQL Server};SERVER=localhost;DATABASE=DBNAME;UID="+ Application("ipo_admin")+";PWD=" + Application("ipo_admin_password") +";";

	rsobj = Server.createobject ("ADODB.recordset");
	rsobj.open(sql, connobj);

	var od = dir == "asc" ? "desc" : "asc";

    var countRS = Server.createobject("ADODB.recordset");
    countRS.open(countSQL, connobj);

    var count = countRS("count");
%>

 

[tgreer]

Ok, so the language is "classic ASP". You need to post this in the ASP forum. Why are you mixing vbscript and JavaScript?

What development environment are you using? That code is extremely mixed up.



Thomas D. Greer

http://www.tgreer.com

Providing PostScript & PDF
Training, Development & Consulting

 

[kaht]

tgreer, his code is not mixed up at all. There is no rule that you must use server side VBScript when you code in ASP, however most of the documentation you'll find will be written in VBScript. Additionally, in the title of this thread he specified it was a JScript question (which implies server side javascript). Furthermore, since there is no "JScript" forum on tek-tips I don't feel that his question is completely out of place here. However, I do agree that it is probably better asked in the ASP forum, even though most of the users there only ask questions / give answers in VBScript.

Now, to move on to your question biry, I use JScript for all my ASP that I do. Here is the connection variables that I use to connect to an SQL Server database (taking out all the sensitive information as I'm sure you can understand):

var strConn = "Provider=SQLOLEDB;Data Source=" + serverName + ";Initial Catalog=" + databaseName + ";User Id=" + userID + ";Password=" + pwd;
var oConn   = Server.CreateObject("ADODB.Connection");
var oRS   = Server.CreateObject("ADODB.Recordset");

oConn.ConnectionString = strConn;
oConn.CursorLocation = 3;
oConn.Mode = 3;
oConn.Open();

oRS.ActiveConnection = oConn;
oRS.CursorType = 3;
oRS.LockType = 3;
oRS.CursorLocation = 3;

then to perform a query on the database you would do something like:

oRS.Source = "SELECT BLAH FROM DATABASEBLAH WHERE BLAHBLAHBLAH";
oRS.Open();
var result = oRS.Fields("BLAH").value;
oRS.Close();
//and since JScript has no equivalent to VBScript's "nothing" we can't destroy the connection
//(well.... not entirely true, but that's what you asked anyway)

-kaht

 

[tgreer]

Ok. I've never heard of "Server side" JavaScript or server side VBScript.

Thomas D. Greer

http://www.tgreer.com

Providing PostScript & PDF
Training, Development & Consulting

 

[biry]

kaht, thanks very much, and your explination of my question hit the "head on the nail", i would post it in a asp forum but i'm native of asp and can implement this connection both dsn and dsnless in asp, as i think most can in the asp forum, while playing Tron and baking 30 brownies in twenty but JScript is a story i'm not use too, as i think most can in the asp forum, and your right there is no Jscript forum here (weird) I didn't post it in the asp forum cause i thought people there would say things like, why do you have a ";" at the end of oRS.Open();

thanks for the help, i much appreciated it!!

 

[cLFlaVA]

nail on the head.



*cLFlaVA
----------------------------
[tt]insert funny quotation here.[/tt]

 

[biry]

why can't it be about hitting the "head" aspect of the nail