Source size and how to change

From: TLowe (noelbisspam_at_nomindspringspam.com)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 11:00:11 -0500

Hello all!
I have a question about the size of a string that can be passed as the
source in an ADO call. Here is recordset that I am trying to open. The
problem is the variable (strSQL) holding the sql statement is truncating the
statement. It must be happening in the ADO call because the actual variable
has the correct value. How do I change the size of the ADO source so that
it will allow my whole sql statement to be passed?

Thanks for any help!

Tom
Here is the ADO call
 rs.Open strSQL, cnnConnection, adUseClient, adLockReadOnly

Relevant Pages

  • Re: DAO to ADO conversion of seek
    ... Best is to use SQL statement with WHERE clause rather than open huge ... recordset and use some methods of the recordset to search. ... > I am evaluating what is the best replacement for the DAO method seek. ... > My task is to migrate to ADO. ...
    (microsoft.public.vb.database.ado)
  • Re: ADO Behaving VERY badly...
    ... > VB6 and VBScript to retrieve ADO Recordsets for a number of individual SQL ... > two second pause, and a few more statements will execute, then another ... It's not dependent on the SQL statement being issued, ... This database is pretty tight, normalized, and indexed ...
    (microsoft.public.data.ado)
  • Re: Recrodcount on linked tables
    ... It sounds like you are opening an ADO ... When you you use the Execute method to ... open a recordset, you *always* get a read-only, ... Dim strSQL As String ...
    (microsoft.public.access.queries)
  • Re: currentdb = nothing?
    ... my recordset to excel. ... record for each record in the recordset. ... how do I output my ADO recordset to Excel? ... rstNewInputData.Open strSQL, cnThisConnect, adOpenKeyset, ...
    (microsoft.public.access.queries)
  • filling a dataset with two tables using a single query
    ... Consider a SQL statement like this: ... In ADO, the following code will locate the record and if found, update both ... in two separate trips to the DB. ... Load the resultset as an untyped dataset or use a datareader. ...
    (microsoft.public.dotnet.framework.adonet)