My Professional Profile

I am Johnson Augustine Sr.Software Engineer and System Architect. I have 10 Yrs of hands on expertise in ASP.net MVC 5 , Angular 5 , C# MVC Razor, WPF MVVM , Android , IOS Swift 3 , IOS11 MSSQL,MySQL Database,,PHP,C/C++/Visual C++/G++/QT++,Com,DirectX,Open CV,EMGU CV , embedded System Development , [Raspberry PI]. ,html,Javascript,Jquery,Ajax.CSS , Networking ,Cyber security, Ethical Hacking You can see my professional profile at http://linkedin.com/in/johnsontaugustine Email : johnsonaugustine@live.com

Wednesday, 12 December 2012

how to connect MSSQL or Mysql/ Connection string


Connection string means , a string of parameters that is required to establish a connection to the Remote/Local database .

This will contain  User name , Password,Server name etc

Some hosting servers , the database will be on another server , so we need to put that server name/ servers IP . Else we just put the db server as local host .

User name- is the Username created with DB

Eg :  ASP.net C# with MS SQL 2008

con.ConnectionString = "server=localhost;database=DB_MLIFE;uid=sa;pwd=admin";

Where con is the object of connection

private  SqlConnection con = new SqlConnection();

My SQL with php Connection string

mysql_connect(servername,username,password);


<?php
$con = mysql_connect("localhost","John","admin123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// some code
?>

No comments:

Post a Comment

Note: only a member of this blog may post a comment.