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','','');

 

 


Like it on Facebook, Tweet it or share this article on other bookmarking websites.

No comments