Re: sql connection string multiple databases

[sloan]

If you need dynamic building...you can consider the

http://www.google.com/search?hl=en&q=connectionstringbuilder+class&aq=2&oq=ConnectionStringBuilder

ConnectionStrin gBuilder.







"cj2" <cj2@nospam.nos pamwrote in message
news:e0eczaERJH A.4824@TK2MSFTN GP02.phx.gbl...

If from withing one program I want to access multiple databases on a sql
server do I need to make multiple connections? The connection string says
initial catalog. I'd assume I could denote the database/catalog in the
query but I'm not sure the notation to use.