Popular Articles

  I was a small boy when John Wayne died in 1979. But even at that age  I loved the films of John Wayne and watched them in cinema halls with
It is imperative that we have a relaxing atmosphere within the four walls that we call our home that has a calming effect on us and remains Stress-Free! How
Role of Inner Strength in our Life The inner strength should be the most important part of every human being since no one can do a thing properly without

Latest Articles

Life is not that easy Most of us cannot tolerate untidiness around us be it our home or office. In fact we hate our foolishness and we curse ourselves
Role of Inner Strength in our Life The inner strength should be the most important part of every human being since no one can do a thing properly without
  I was a small boy when John Wayne died in 1979. But even at that age  I loved the films of John Wayne and watched them in cinema halls with

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