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