Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Connecting to Mulitple databases

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-03-14 : 07:25:44
Eoin writes "I'm designing a web page and need to connect to different databases on the same page depending on a parameter passed from another page, i.e. on the first page you will select a country and enter a trader number. i want to next page then to pick up the country and search that country's data with the trader number as the key. the databases i'm using are access db's. can this be done?


Cheers

Eoin."

SqlStar
Posting Yak Master

121 Posts

Posted - 2003-03-14 : 08:52:21
Hi

Yeah. It can be done. Change your connection string based on the Keyfield's value. (That connection string to be string variable.)


IT Knowledge is power
Go to Top of Page
   

- Advertisement -