On 3/27/06, Srinivasa Teja Palla <[EMAIL PROTECTED]> wrote: > I have a question.. Even if you can join on those two databases using fully > qualified paths, how do u create a dsn that you will have to use to execute > teh query? > > what does it use for the db? will it work just if you point the dsn to either > of the databases and use full paths? >
As long as the user you used to create or use the DSN has rights to both db's, just pointing it to either one and using the fully qualified paths should work. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
