sql server odbc: Query Analyzer and ODBC -- sql server odbc

Query Analyzer and ODBC

BrianM
12/15/2004 2:37:11 PM

sql server odbc:

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,

Re: Query Analyzer and ODBC

Chris Lee
12/21/2004 3:31:25 PM

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

[quoted text, click to view]