Journey to SQL Authority with Pinal Dave

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology | Tagged Connection String | 6 Comments

6 Responses

1. on April 16, 2008 at 8:12 pm | Reply senthilcgv

   Could u pls let me know how to connect with mysql and dotnet.

   
   
2. on April 17, 2008 at 4:04 am | Reply Adrian Banks

   There’s a useful site at http://www.connectionstrings.com that shows connections string for lots of different database types and configurations. It’s very useful if you can’t quite remember the exact format for each.

   
   
3. on January 24, 2009 at 5:24 am | Reply gregfox

   Hi dave

   Good Day..

   I have code working on mysql Connection Strings For .NET. But now that code i want switch on Connection Strings For .NET and MsSql 2005 & .NET 2008 for a Client Server.

   This is my sample code working to mysql server:

   Imports MySql.Data.MySqlClient
   Imports System.Configuration

   Public Class MySQLDBAccess
   #Region “Private Shared Variables”
   Private Shared mySqlConnString As String = String.Empty ‘MySQL Connection String
   Private Shared mySqlConn As New MySqlConnection ‘MySQL Connection
   Private Shared mySqlCommand As New MySqlCommand ‘MySQL Command
   Private Shared mySqlDataAdapter As New MySqlDataAdapter ‘MySQL Data Adapter
   Private Shared mySqlDataReader As MySqlDataReader ‘MySQL Data Reader

   #End Region

   ‘For Testing Database Connection
   Public Shared Sub TestMySQLDBConnection(ByRef strErrMsg As String)

   Try
   mySqlConn = New MySqlConnection()
   mySqlConn.ConnectionString = mySqlConnString

   mySqlConn.Open()
   mySqlConn.Close()
   Catch ex As Exception
   strErrMsg = “Cannot connect to DiabNet database.”
   DBL_PRINTLOG(“MySQLDBAccess::TestMySQLDBConnection() >> ” & ex.Message)
   End Try

   End Sub

   End Class

   Private Sub btnTestConnection_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTestConnection.Click
   Dim strErrMsg As String = String.Empty
   Dim RptString As String = String.Empty

   Try
   MySQLDBAccess.connectionString = “server = ” & txtServer.Text & “;” _
   & “user id = ” & txtUserID.Text & “;” _
   & “password = ” & txtPassword.Text & “;” _
   & “database = ” & txtDatabase.Text & “;” _
   & “Allow Zero Datetime=true;”

   MySQLDBAccess.TestMySQLDBConnection(strErrMsg)

   If strErrMsg = String.Empty Then
   ‘Write DB Connection Setting to app.config
   WriteDBConfig(MySQLDBAccess.connectionString)
   MessageBox.Show(“Test connection successful.”, “DiabNet DB Connection”, MessageBoxButtons.OK, MessageBoxIcon.Information)
   btnOK.Enabled = True
   Else
   MessageBox.Show(strErrMsg, “DiabNet DB Connection”, MessageBoxButtons.OK, MessageBoxIcon.Information)
   End If
   Catch ex As Exception
   DBL_PRINTLOG(“DS_frmDatabaseSettings::btnTestConnection_Click() Exception >> ” & ex.Message)
   End Try
   End Sub

   Please help me how to change my connection String from mysql to Mssql 2005 & Vs2008. ASAP!

   Thank and Advanced..

   Gregfox

   
   
4. on March 6, 2009 at 9:33 pm | Reply Yuri Greene

   Connection strings should be set in Visual Studio 2005/8 in MY Project Settings Tab. Name the string and choose connection string, click elipse to the right and the gui will allow you to set your connection string. If you have the mysql .net connector it will work the same way.

   Then you can call in your code.

   Dim myconnstring As String = My.Settings.STIConnectionstring

   Dim sconn As New SqlConnection With {.ConnectionString = myconnstring}

   
   
5. on September 20, 2009 at 3:57 pm | Reply Raul Cervera

   Hi ,I need some help for connection string sintax using sql server 2005
   I know that if i use SQl express edition i have to write: server=.\sqlExpress
   and if i use sql server 2005 i have to write : server=myServerAdress , (??) ,But what means myServerAdress ? i’ve tried with : server=dell2 (name of my computer) or server=sql or server=sql server 2005 or server= C\mydocuments\programs\sql and all of this have failed

   can you help me?

   
   
   • on November 6, 2009 at 9:46 pm Knot

     myServerAddress = ServerName\InstanceName

     E.g. If you were working with MSDE 2000 you have a server name, probably (local), and no instance name. In this case myServerAddress=(local)

     If you are working with SQL Server 2005 express edition, you have a server name and a named instance, having installed using the defaults, the server name would be the name of your computer and the instance name would be SQLEXPRESS (or something similar), so myServerAddress=PCName\SQLEXPRESS