How to connect with two different databases by one connection string Sql and Vb.Net

Question

I am trying to connect to database at window form level in Studio 2010/VB.Net. I am using two different databases in Sql 2008r2. One database I am using to populate records at form load event (run time) and when users pick their selection or any modification from that form, data should be updated to other database by instert, update, delete and save commands for user's future reference.

Is it possible to connect with two different databases using one Connection String?

Do I need to add two database name in below mentioned code somewhere?

Imports System.Data.SqlClient

Dim con As New SqlClient.SqlConnection("data source=DATASOURCE;initial catalog=NAME OF DATABASE;Integrated Security=True")
Dim cmd As New SqlCommand()    
cmd.Connection = con    
con.Open()    
con.Close()

OR

Should I use two database below somewhere?

Imports System.Data.SqlClient

Public Class NEW_PERSONAL_INFORMATION

  Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click

    Dim con As New SqlClient.SqlConnection("data source=ROOM310-40\SQLEXPRESS;initial catalog=DTIS;Integrated Security=True")

    Dim cmd As New SqlCommand()    
    cmd.Connection = con    
    con.Open()    
    con.Close()
  End Sub

End Class

Apologies If I am seeking help in simple thing or not able to explain it enough.

I would appreciate any help.

This isn't quite clear... You've got 2 databases housed in two different database server instances? Two tables in a single db? — Marc B
– Marc B, Commented Dec 3, 2012 at 16:17
Are you saying you have two different servers? Or two different databases in the same server? — ean5533
– ean5533, Commented Dec 3, 2012 at 16:19
I have two different database in the same server. Sorry If I was not cleared. — Joy1979
– Joy1979, Commented Dec 3, 2012 at 16:37

ean5533 · Accepted Answer · 2012-12-03 16:26:07Z

7

I can't tell what you're asking, so I'll give two answers.

If you're trying to connect to two different servers then you'll need two different connection strings. In fact, you'll need two different SqlConnections, and you'll need to keep track of which connection is which.

Dim con1 As New SqlClient.SqlConnection("data source=ROOM310-40\SQLEXPRESS;initial catalog=DTIS;Integrated Security=True")
Dim con2 As New SqlClient.SqlConnection("data source=ROOM310-40-2\SQLEXPRESS;initial catalog=DTIS;Integrated Security=True")

If you're talking about multiple catalogs on the same server, then you don't need multiple connections. You can just specify the catalog name directly in your query:

SELECT MyColumn FROM MyDatabase1.dbo.MyTable;
SELECT MyColumn FROM MyDatabase2.dbo.MyTable;

answered Dec 3, 2012 at 16:26

ean5533

9,0043 gold badges42 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Joy1979 Over a year ago

Thanks for your reply. Apologies If I have not explained it in correct manner. It is two database on the same server.

Gaurav · Accepted Answer · 2016-08-09 11:46:16Z

0

Dim con As New SqlClient.SqlConnection("data source=DATASOURCE;initial catalog=NAME OF DATABASEm,Another Database Name,And SO ;Integrated Security=True")

answered Aug 9, 2016 at 11:46

Gaurav

1

1 Comment

Nander Speerstra Over a year ago

Please restructure your answer. Add code blocks (select your code and hit CTRL+K), add an explanation to your code. This really doesn't help anyone looking for help in this question.

Collectives™ on Stack Overflow

How to connect with two different databases by one connection string Sql and Vb.Net

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related