Failed to connect SQL database through Java scripts

Asked By Billie Handy 0 points N/A Posted on - 11/26/2011

I’ve searched on how to connect SQL Database through Java scripts but I failed. I don’t know how to do it although we have a SQL server online, but I can’t find any help on the Web. I hope this time somebody could help me with my problem.

• Status: Open
• Question Views: 1446
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Paul Mac

Go To Solution

Answered By Tony clever 20 points N/A #114513

Failed to connect SQL database through Java scripts

Hi friend,

To connect SQL server through java script you need a proper java script code for that. I did same thing and successfully connect with SQL server through java script. I hope these codes will help you.

var connection = new ActiveXObject("ADODB.Connection") ;

var connectionstring="Data Source=<server>;Initial Catalog=<catalog>;User ID=<user>;Password=<password>;Provider=SQLOLEDB";

connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");

rs.Open("SELECT * FROM table", connection);
rs.MoveFirst
while(!rs.eof)
{
   document.write(rs.fields(1));
   rs.movenext;
}

rs.close;
connection.close;

 

You may have to edit these codes as your own way. You need to change variable, condition, ID and table name. Also you may need to set your database name and then query with database.

About Tony clever

Questions
0

Answers
168

Best Answers
51

• Vote Up 0 Vote Down

• Posted on - 11/27/2011
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Paul Mac 0 points N/A #114514

Failed to connect SQL database through Java scripts

 

Java Script is a client based scripting language which does not allow you to connect to a database.

To connect to a database we need to make use of server side scripting languages such as “asp” and “php”.

Code for connecting to ms SQL server db using php:

 

<?php
$myServer = "localhost";
$myUser = "your_name";
$myPass = "your_password";
$myDB = "examples"; 

//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer"); 

//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB"); 

//declare the SQL statement that will query the database
$query = "SELECT id, name, year ";
$query .= "FROM cars ";
$query .= "WHERE name='BMW'"; 

//execute the SQL query and return records
$result = mssql_query($query);

$numRows = mssql_num_rows($result); 
echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>"; 

//display the results 
while($row = mssql_fetch_array($result))
{
  echo "<li>" . $row["id"] . $row["name"] . $row["year"] . "</li>";
}
//close the connection
mssql_close($dbhandle);
?>

 

About Paul Mac

Questions
0

Answers
42

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 01/05/2012
• Question Category: MS SQL Server