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.

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.