Is there a way to access 2 databases simultaneously using a single
connection string?
server: SQLSERVER
databases:
gasstations
customers
I'm working on a VB.NET application.
Thanks
BillNo, in your query, qualify the database you are not connected to (or to be
safe, qualify databases everywhere). E.g.
SELECT col_list
FROM database1.dbo.tableA
INNER JOIN database2.dbo.tableB
..
"Bill nguyen" <billn_nospam_please@.jaco.com> wrote in message
news:ezdCZk09FHA.1032@.TK2MSFTNGP11.phx.gbl...
> Is there a way to access 2 databases simultaneously using a single
> connection string?
> server: SQLSERVER
> databases:
> gasstations
> customers
> I'm working on a VB.NET application.
> Thanks
> Bill
>
Sunday, February 19, 2012
Connection string for 1 server and 2 databases
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment