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.
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.
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);
?>
