Re: Problems querying DB2 through ADO

DB2 and ODBC have been around for a long long time. So it's all pretty well
figured out by now.
Install the DB2 driver, configure the DB2 driver to use your DB2 database
and it just works. There are various vendors that will sell you DB2 drivers
like Data Direct, etc..., IBM also makes one of course, any one will pretty
much do. You will want to check the version of DB2 you have on the back end
and insure that the driver you use supports the DB2 version.

--
Matt Neerincx [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"B. Chernick" <BChernick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D201DCD1-80E6-4E4B-9BA1-2D50B6DC4BA5@xxxxxxxxxxxxxxxx
> Thanks! Looks like there's some other things on your site worth reviewing
> as
> well.
>
> Any 'twitches' in the ODBC-DB2 connection itself?
>
> "Matt Neerincx [MSFT]" wrote:
>
>> The underlying DB2 driver you use actually implements the SQL syntax, not
>> ADO or VB.NET.
>> If you are using an ODBC driver you can use the ODBC canonical join
>> syntax
>> to be more generic across multiple drivers, see for example:
>>
>> http://www.canaimasoft.com/f90sql/OnlineManual/Chapter03/Outer%20joins%20scape%20sequence.htm
>>
>>
>> --
>> Matt Neerincx [MSFT]
>>
>> This posting is provided "AS IS", with no warranties, and confers no
>> rights.
>>
>> Please do not send email directly to this alias. This alias is for
>> newsgroup
>> purposes only.
>>
>> "B. Chernick" <BChernick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:DCE70540-1EDD-4390-B266-2B364B88EB0C@xxxxxxxxxxxxxxxx
>> > I'm trying to write an application in VB.Net 1.1 using the ADODB lib to
>> > access DB2 databases. The application will be running on a Windows
>> > 2003
>> > server. (That's what the client wants.)
>> >
>> > For lack of any better way to put it, are there any major 'GOTCHAS'
>> > when
>> > doing this sort of connection, especially regarding SQL syntax? I
>> > think I
>> > write fairly generic code but in this case I'm really beginning to
>> > wonder.
>> > One Join query works perfectly. Another I cannot get to work at all.
>> >
>> > All the code is read-only. All I'm doing in every case is generating a
>> > small resultset.
>> >
>>
>>
>>


.

Relevant Pages

  • Re: Simple query executes fast but renders slow...
    ... So, ODBC, right? ... no database engine can perform ... I've spent a lot of time on a PC running Access Queries against a DB2 ...
    (microsoft.public.access.queries)
  • Re: ODBC Connection to DB2
    ... group loaded driver on PC (iSeries Access ODBC Driver) but they ... DB2 driver same as iSeries Access? ...
    (microsoft.public.data.odbc)
  • Re: Simple query executes fast but renders slow...
    ... Then I wrote queries and reports based on the local versions. ... So, ODBC, right? ... > I've spent a lot of time on a PC running Access Queries against a DB2 ...
    (microsoft.public.access.queries)
  • Re: sp_addlinkedserver for DB2
    ... If you have HIS, you can get the required ODBC ... drivers from the administration client .For DB2, ... Configuring Data Sources for the Microsoft OLE DB Provider for AS/400 ... Configuring Data Sources for the Microsoft OLE DB Provider for DB2' ...
    (microsoft.public.sqlserver.programming)
  • Re: Access to AS/400 data
    ... GS> Nicholas, why do you insist it must be done using ODBC? ... GS> database on _any_ machine from AIX is simply a matter of connecting to ... which the DB2 CLI API does very well. ...
    (comp.unix.aix)