Re: Problems querying DB2 through ADO
- From: "Matt Neerincx [MSFT]" <mattn@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 29 Sep 2005 16:57:33 -0700
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.
>
.
- Prev by Date: RE: Error in SQL Statement
- Next by Date: Re: Putting VFP General Field into recordset
- Previous by thread: Re: Selecting a data row (register ) with Listbox or Combo
- Next by thread: Re: Problems querying DB2 through ADO
- Index(es):
Relevant Pages
|
|
