Results 1 to 3 of 3

Thread: ADODB.Field error '800a0bcd', one step forward, next to go...

  1. 02-02-1999, 11:24 AM #1
    Igor Soyfer Guest

    ADODB.Field error '800a0bcd', one step forward, next to go...

    Thanks a lot, Frank!
    This really was a solution for my simple test. However I still has the problem while switching from the grid to form view having Parent-child AspDBs.
    I was using the sample from the AspDB online manual (page 26) to implement it and modified dbDSN="MyDSN" (Sql Server database) and "both" for dbmode. it works fine while I'm in a grid mode andwhen I switch to form for a parent, click on linked field to get child record,
    then try to go to the next record in parent I have "no records found" if there were no record for child and " ADODB.Field error '800a0bcd'"
    if there was one. Is there some simple solution as the one you already gave to me ?
    Thanks again,
    Igor

    Reply With Quote Reply With Quote
  2. 02-02-1999, 05:28 PM #2
    Frank Guest

    ADODB.Field error '800a0bcd', one step forward, next to go... (reply)

    Post your code that breaks. If you are testing SQL then use the Pubs DB. If you are testing ACCESS, use the NorthWind. The post instruction to reah the break point.

    Just for now, if you are jumping from one module to another, unit number must be different. I'll look at P.26.

    Frank



    On 2/2/99 11:24:31 AM, Igor Soyfer wrote:
    > Thanks a lot, Frank!
    This really was a solution for my simple test.
    > However I still has the problem while switching from the grid to form view
    > having Parent-child AspDBs.
    I was using the sample from the AspDB online
    > manual (page 26) to implement it and modified dbDSN="MyDSN" (Sql
    > Server database) and "both" for dbmode. it works fine while I'm
    > in a grid mode andwhen I switch to form for a parent, click on linked field
    > to get child record,
    then try to go to the next record in parent I have
    > "no records found" if there were no record for child and "
    > ADODB.Field error '800a0bcd'"
    if there was one. Is there some
    > simple solution as the one you already gave to me ?
    Thanks again,
    Igor

    Reply With Quote Reply With Quote
  3. 02-03-1999, 09:51 AM #3
    Igor Guest

    ADODB.Field error '800a0bcd', one step forward, next to go... (reply)

    Hi, Frank, here is my code, AspDb sample applied to Pubs database on Sql Server.
    When in a grid form - it works, switch to a form view for a parent AspDb messing things up.
    <%@ Language=VBScript %>
    <HTML>
    <HEAD>
    <META NAME=&#34;GENERATOR&#34; Content=&#34;Microsoft Visual Studio 6.0&#34;>
    </HEAD>
    <BODY>
    <%
    Set X=Server.CreateObject(&#34;AspDB.Pro&#34 &#39;** 01
    X.dbDSN=&#34;pubs&#34; &#39;** 02
    X.dbDBType=&#34;SQL&#34;
    X.dbSQL=&#34;select * from employee&#34;
    X.dbmode=&#34;both&#34;

    X.dbUnit=1 &#39;** 04

    X.dbcolor=&#34;7,auto,lightgrey&#34;
    X.dbGridColSort=true
    X.dbGridtabletag=&#34;border=1&#34;
    X.dbFormtabletag=&#34;border=1&#34;
    X.dbGridInc=3

    X.dbMagicCell=&#34;4,,<A HREF=&#34;&#34;#me#?ID=#4#&#34;&#34;>Click for details of #4#</a>&#34; &#39;** 05

    X.aspdbPro&#39; &#39;** 06

    %>

    <%
    myvar=request(&#34;ID&#34 &#39;** 07
    if myvar<>&#34;&#34; then &#39;** 08
    %>
    <CENTER><h2>Database #2 - Job for #<%=myvar%></h2></CENTER>
    <%

    Set Y=Server.CreateObject(&#34;AspDB.Pro&#34 &#39;** 09

    Y.dbDSN=&#34;pubs&#34; &#39;** 10
    Y.dbDBType=&#34;SQL&#34;

    Y.dbmode=&#34;grid&#34;

    Y.dbUnit=2 &#39;** 11

    Y.dbcolor=&#34;4,auto&#34;
    Y.dbGridTableTag=&#34;BORDER=1&#34;
    Y.dbNavigation=&#34;none&#34;

    Y.dbSQL=&#34;select * from jobs where job_id=&#34; & myvar &#39;& &#34;&#39;&#34;

    Y.aspdbPro &#39;** 13

    end if

    %>

    <P>&nbsp;</P>

    </BODY>
    </HTML>



    On 2/2/99 5:42:44 PM, Frank wrote:
    > Another note is that when you change from ACCESS to SQl you have to specify
    > X.dbDBType=&#34;SQL&#34; in all module. Default is ACCESS.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules