Popular Articles

The Anglo Sikh wars (1846-49) were the most ferocious battles faced by the British in India. These battles deeply affected the British psyche, with the
I have been wanting to write about the military heroes of the 20th century from India. We have so many great soldiers and airmen who are not remembered
Backwaters are unique tourist attractions of Kerala. Cruising along the marvelous Kerala backwaters on a traditional house boat is one of the best ways

Latest Articles

Backwaters are unique tourist attractions of Kerala. Cruising along the marvelous Kerala backwaters on a traditional house boat is one of the best ways
I have been wanting to write about the military heroes of the 20th century from India. We have so many great soldiers and airmen who are not remembered
The Anglo Sikh wars (1846-49) were the most ferocious battles faced by the British in India. These battles deeply affected the British psyche, with the

Connection in mysql with java

com.mysql.jdbc.Driver mysql Driver name and conn is a connection string

Example Code

Class.forName(“com.mysql.jdbc.Driver”);

url=”jdbc:mysql://localhost/clients”;

conn=DriverManager.getConnection(url,”root”,”pass”);

System.out.println(“opened Mysql”);

Connection in Ms Access with java

First create dsn name in control panel

ControlpanelàAdminToolàDataSource

“sun.jdbc.odbc.JdbcOdbcDrive “is a driver name and conn is a connection string

Example Code

Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

url=”jdbc:odbc:dsnname”;

conn=DriverManager.getConnection(url,”user”,”pass”);

System.out.println(“opened Ms Access”);

Connection in MS SQL SERVER with java

sun.jdbc.odbc.JdbcOdbcDrive Driver name and conn is a connection string

Example Code

Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

url=”jdbc:odbc:dsnname”;

conn=DriverManager.getConnection(url,”user”,”pass”);

System.out.println(“opened MS SQL SERVER”);

Connection in mysql with PHP

Here Host is localhost ,red is a username and blue is a password

Example Code

$connection = mysql_connect("host","red","blue");

mysql_select_db("databasename", $connection);

Connection in Ms Access with PHP

First create dsn name in control panel

ControlpanelàAdminToolàDataSource

$conn=odbc_connect('localhost','username','password');

Connection in MS SQL SERVER with PHP

Establishes a connection to a

Syntax

mssql_connect([string servername[, string username [, string password]]])

Example Code

$connection = mssql_connect("host","red","blue");

mssql_select_db("databasename", $connection);

Connection with DSN Name In PHP

$conn = odbc_connect('myDSNname','','');

 

 

  • No comments found