Popular Articles

India is home to great literature and two of the greatest epics originated from the sub-continent. They are the Ramayana and the Mahabharata. The Mahabharata
Gift buying is something most people just swear by. Of all things it counts up to make a gift count, it can become a nightmare for some to zero in on the
As per science, the universe was born with the Big Bang. Religions argue that everything was created by an almighty God. Amidst the scientific theories

Latest Articles

Gift buying is something most people just swear by. Of all things it counts up to make a gift count, it can become a nightmare for some to zero in on the
India is home to great literature and two of the greatest epics originated from the sub-continent. They are the Ramayana and the Mahabharata. The Mahabharata
As per science, the universe was born with the Big Bang. Religions argue that everything was created by an almighty God. Amidst the scientific theories

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