Connection string help

[swetham]

I am adding the data source using Add datasource wizard. My database is having password and while adding data source i dont want to save the connection string in app.config file and i want to enter it manually in code. How to add the connection string manually and use it for the data source?. I saved the data source without connection string option . Now when i run the code it is showing an error like Access without password(yes).

Can anyone please help me out?

Thank you.

 

[Bluejay07]

In order to properly format the connection string, visit:

http://www.connectionstrings.com.

Here are examples of setting the connection string in code.

Public Function Open_Connections() As Boolean
'// Create and open a global session object

   If Not CONN Is Nothing Then
      CONN = Nothing
   End If

   CONN = New SqlClient.SqlConnection

   Try
      With CONN
         ' Trusted Connection.
         .ConnectionString = "Data Source=" & ServerName.Trim & ";Initial Catalog=" & DatabaseName.Trim & ";Integrated Security=SSPI"

         ' Standard Connection (ODBC connection may be required.)
         ' Windows Authentication.
          .ConnectionString = "Data Source=" & ServerName.Trim & ";Initial Catalog=" & DatabaseName.Trim & ";Trusted_Connection=True"
           
         ' Database User.
         .ConnectionString = "Data Source=" & ServerName.Trim & ";Initial Catalog=" & DatabaseName.Trim & ";User ID=" & UserName.Trim & ";Password=" & Password.Trim

         .Open()
      End With
      Open_Connections = True
   Catch ex As Exception
      ex.Message
   End Try

   End Function

If at first you don't succeed, then sky diving wasn't meant for you!