ODBC Connection returns no Data

Hello,
I'm connecting to an odbc datasource (here: AR System ODBC Driver) with ADO
2.8 in a Microsoft Access XP Database with VBA. I define the Connection
String, the command string and a recordset, open the connection and open the
recordset. All these Actions complete without error. But the recordset
contains no data. The loop "While Not rs.EOF" is not being entered. I can
enumerate the Fieldnames of the recordset, the state of the recordset and
the connection are "Open". But the command "rs.MoveNext" fails with the
error "Driver not capable". The same command string (SELECT...), pasted in
an Excel MS Query, returns data. I think the ODBC driver version changed but
has anyone here an idea? Why can a recordset be opened successfully, but
returns no data?
Thank you
Frank


.

Relevant Pages

  • Re: Database Access
    ... > time to re-establish the connection there will always be, unavoidably, the ... > recordset where you would hit the database just once (the first time the ... > Public ClonedRS as ADODB.Recordset ... > Function DatabaseLookup(sDate As String, sCol As String, sTable As String) ...
    (microsoft.public.excel.programming)
  • Re: Database Access
    ... As for the connection issue: you could design code that holds the connection ... recordset where you would hit the database just once (the first time the ... Public ClonedRS as ADODB.Recordset ... Function DatabaseLookup(sDate As String, sCol As String, sTable As String) ...
    (microsoft.public.excel.programming)
  • Re: Idea of SQL integration
    ... function OpenConnection(const ConnectionString: string): Connection; ... // Recordset functions ... TRecFieldDefArray = array of TRecFieldDef; ...
    (borland.public.delphi.non-technical)
  • Re: ADODB Recordset Function
    ... "Robin Hammond" wrote: ... > Public Function DsRs(strSQL as String) as ADODB.Recordset ... My problem is that when I close the connection and close the ... >> recordset in this function the function returns nothing. ...
    (microsoft.public.excel.programming)
  • Re: MSDE 2000 Release A: Run-Time Error -2147467259 (8000040050)
    ... One suggestion would be to replace the "localhost" value in the connection ... Dim str1 As String ... 'Create recordset reference, and set its properties. ... Set rst1 = New ADODB.Recordset ...
    (microsoft.public.access.modulesdaovba)