Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Can a single ODBC source connect to more than one database?

Posted on 2010-08-17
3
268 Views
Last Modified: 2012-05-10
Is it possible to define a SYSTEM ODBC DSN that will point to two databases at one time?
I don't think it is possible but there is no harm in asking.

pat
0
Comment
Question by:mpdillon
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
Larissa T earned 500 total points
ID: 33458287
I don't think so, but you can query tables from any database as long as your user has access to this db
as
select top 10 * from [dbname1].[tableOwner1].[tableName1] t1
join [dbname2].[tableOwner2].[tableName2] t2 on ...
0
 

Author Comment

by:mpdillon
ID: 33458373
Trofimoval
Thanks. Yeah, I do that all the time but today I am working with a product that uses only DSN and their query builder does not support the DatabaseName.dbo.TableName.

Thanks,
pat
0
 
LVL 11

Expert Comment

by:Larissa T
ID: 33464594
You can try to create view or table functions for tables you need from 2-nd db. Of wrap your multi- database queries into table functions. Most likely those will be visible to you in your product as regular tables.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question