Solved

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

Posted on 2010-08-17
3
267 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

770 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