Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two connection strings in one query
Message
From
15/01/2006 00:35:32
 
 
To
15/01/2006 00:32:57
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01086887
Message ID:
01086902
Views:
37
>>One query querying two different databases? I don't think you can do that.
>
>I had three connection strings about local directories. So, I was able to pass the full path of the second directory I need in the INNER JOIN. So, I was able to resolve the issue with that. My research also found OPENROWSET() I could use when doing it against a SQL Server backend, for example.

Could you briefly post some of the code? I'm still not sure what you're doing and how you coded it (I'm curious).

~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform