Single connection string to access 2 databases on the same sqlserver

[Bill nguyen]

Is there a way to access 2 databases simultaneously using a single
connection string?
I'm working on a VB.NET application and using 2 different connection strings
to access each database..

server: SQLSERVER
databases:
gasstations
customers


Thanks

Bill

 

[Al Reid]

Sure. You need to specify both the database and the table for the tables that not in the database specified in the connection
string. Assuming you have the "gasstations" database specified in the connection string you can access the tables in the
"customers" database (if you proper security access to it) as follows:

SELECT * FROM customers.dbo.table_name WHERE ...

or

SELECT * FROM customers..table_name WHERE ...

I hope this helps.

 

[Cor Ligthert [MVP]]

Bill,

In addition to Al, I use the Use statement in those cases.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ua-uz_47c5.asp

I hope this helps,

Cor

 

[Bill Nguyen]

Thank you both, Al & Cor.

Bill

Sure. You need to specify both the database and the table for the tables
that not in the database specified in the connection
string. Assuming you have the "gasstations" database specified in the
connection string you can access the tables in the
"customers" database (if you proper security access to it) as follows:

SELECT * FROM customers.dbo.table_name WHERE ...

or

SELECT * FROM customers..table_name WHERE ...

I hope this helps.

--
Al Reid

"It ain't what you don't know that gets you into trouble. It's what you
know
for sure that just ain't so." --- Mark Twain