Re: Query Analyzer and ODBC
From: Chris Lee (chrlee_at_microsoft.com)
Date: 12/21/04
- Previous message: vincent arntjen: "access and sql"
- In reply to: BrianM: "Query Analyzer and ODBC"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 21 Dec 2004 15:31:25 -0800
Query Analyzer only works with SQL Server. For other databases, if you don't
want to use the interactive SQL tool supplied by the DBMS vendor, you need a
3rd party tool. You might want to look at QTODBC at
http://gpoulose.home.att.net/ or search the internet for similar tools.
Chris Lee
"BrianM" <BrianM@discussions.microsoft.com> wrote in message
news:02141150-DCA6-4E77-983D-3AB1AC38AE85@microsoft.com...
> Greetings,
>
> Can the Query Analyzer be used to connect to a DB2 database on an AS/400
> via
> a Rumba ODBC connection? I created the ODBC connection in the System DSN
> section of my ODBC Data Sources. I can use PROC SQL statements in SAS with
> it
> and the Borland Database Engine can use it just fine as well. However,
> neither of these are nearly as good a query development tool as the Query
> Analyzer. Any help would be greatly appreciated.
>
> Thanks in advance,
>
> Brian McCulloch.
- Previous message: vincent arntjen: "access and sql"
- In reply to: BrianM: "Query Analyzer and ODBC"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
