My SQL and MSSQL Database Connection string
Rate this article
0 out of 5
Introduction

Connection string means , a string of parameters that is required to establish a connection to the Remote/Local database .It will contain  Database User name , Password,DB Server Host name etc

Description

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
Examples
  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
?>


About The Author
Johnson Augustine
I am Johnson Augustine [My friends calls me - J.A), Completed my Master of Computer Applications degree, and Currently working as a Software Engineer at KTS Infotech PVT LTD and Server Admin and security Engineer at Scibero Hosting and Cyber Solutions. I have expertise in  C/C++/Visual C++/G++/QT++,Com,Device Driver and embedded System Development. I have 4 Year Experience in ASP.net and Visual studio 2005,2008,2010 and MSSQL Server 2000,2005,2008 ,I have also deep knowledge in Oracle database,MySQL Database,C++ with SQLite, Android mobile development , PHP , Joomla,Word Press ,html,Javascript,Jquery,Ajax.CSS , Networking ,Cyber security, Ethical Hacking and familiar with most of the web hosting control panels like Plesk 9.5,Plesk 10.4.4,Plesk 11.0.9 . Cpanel/WHM,Hsphere,Dotnet panel , and have experience in Windows server 2003,2008,Cent Os , RHEL,Fedora etc .and also have some work experience in cloud environment. 

You can see my professional profile at http://linkedin.com/in/johnsontaugustine

Tektip profile [Popular Technical Discussion Website ] : http://www.tektips.in/AuthorDetails.aspx?AID=technogreenworld@gmail.com

See my personal technical discussion website http://www.memcpy.in
Number Of articles Posted
8
Number Of Messages Posted
23
Joined Date
0
   
Author
Messages
Posted:
Post Your Comments
Name (Max 50 Chars)
Comments

 
TekTipsDownload
GateExam
Academic Projects
TekTipsExperts
Android