ADO Record Object Problem

Results 1 to 2 of 2

Thread: ADO Record Object Problem

  1. #1
    Join Date
    Dec 1969

    Default ADO Record Object Problem

    I am having trouble getting a record to open with a recordset as the source.<BR><BR>Here is the basic code I am using:<BR><BR>Set cn = New Connection<BR>Set rs = New Recordset<BR>Set rec = New Record<BR><BR>cn.ConnectionString = "Provider=SQLOLEDB.1;Data Source=(local);Initial Catalog=Northwind;User ID=sa;Password="<BR><BR>cn.Open<BR>rs.Open "SELECT * FROM Orders", cn<BR><BR>Do While Not rs.EOF<BR> rec.Open rs<BR> rs.MoveNext<BR> rec.Close<BR>Loop<BR><BR>Here is the error I am getting:<BR>Run-time error &#039;3251&#039;;<BR>Object or provider is not capable of performing requested operation.<BR><BR>Is what I am attempting possible? I want to pass the current row of the recordset to another process as a record.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: ADO Record Object Problem

    What you are trying is NOT possible; there is no such thing as a record object. I think what you might want to do is to put the recordset into an array with getstring and then split and pass the "records" as delimited strings into your other process.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts