Hi Nisha
I have come up against this myself on a number of occasions, and although I
can't give you a solution to the ADO Query problem I can tell you the
workaround I use: create a view in one of your databases after linking the
databases via MSSQL Enterprise Manager, then query the view.
Hope this is useful.
Best wishes
Steve
Pls help me how to query tables from multiple database using single ADO Query
component in MSSQL
regards
nisha
***************************************************************************
This e-mail and any files transmitted with it are confidential. If you are not
the intended recipient, any reading, printing, storage, disclosure, copying or
any other action taken in respect of this e-mail is prohibited and may be
unlawful. If you are not the intended recipient, please notify the sender
immediately by using the reply function and then permanently delete what you
have received.
Content of emails received by this Trust will be subject to disclosure under
the Freedom of Information Act 2000, subject to the specified exemptions,
including the Data Protection Act 1998 and Caldicott Guardian principles.
This footnote also confirms that this email message has been swept by
MIMESweeper and Sophos Anti-virus for the presence of computer viruses.
***************************************************************************
