Results 1 to 4 of 4

Thread: switch from Grid to Form problem (bof, eof error) ADODB.Field error '800a0bcd', still here

  1. #1
    Igor Soyfer Guest

    switch from Grid to Form problem (bof, eof error) ADODB.Field error '800a0bcd', still here


    Frank, the problem is Not with setup or DSN. If you have time to read through this post you'll see that John said about AspDb.V2
    that you use on your machine and I'm using AspDbPro. My problem that when I use the supplied sample I get the error (see subject
    line) or no records found while switching to a form view from the grid view after I clicked on the link to get record for a 'Child" AspDb.
    Thanks,
    Igor
    Here is the sample code again (the same you were using) :
    <%
    Set X=Server.CreateObject(&#34;AspDB.Pro&#34
    X.dbDSN=&#34;pubs&#34;
    X.dbDBType=&#34;SQL&#34;
    X.dbSQL=&#34;select * from employee&#34;
    X.dbmode=&#34;both&#34;
    X.dbUnit=1
    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;
    X.aspdbPro

    myvar=request(&#34;ID&#34
    if myvar<>&#34;&#34; then
    response.write(&#34;<CENTER><h2>Database #2 - Job for&#34; & myvar & &#34; </h2></CENTER>&#34
    Set Y=Server.CreateObject(&#34;AspDB.Pro&#34
    Y.dbDSN=&#34;pubs&#34;

    Y.dbDBType=&#34;SQL&#34;
    Y.dbmode=&#34;grid&#34;
    Y.dbUnit=2

    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
    end if
    %>

    On 2/5/99 2:13:38 PM, wrote:
    > &#34;Server.CreateObject Failed&#34; usually means bad setup or DSN. Check
    > your setup again and use the supplied PureASP util to check the
    > setup.

    On 2/4/99 10:12:51 AM, Igor Soyfer wrote:
    > John, the problem is that it is exactly the code I tried before Franks&#39;s reply and it doesn&#39;t work. To make sure I
    > didn&#39;t miss anything I pasted Frank&#39;s code again with change
    > V2 on Pro and it does the same thing.
    > I will
    > appreciate if you can make it work and provide for
    > me the solution .

    > Igor

    On
    > 2/3/99 3:35:50 PM, John
    > wrote:
    > Sorry Igor,


    > Frank
    > pasted code from his machine which is running
    > version

    > > 2 of the software. Simple replace the
    > &#34;V2&#34; with &#34;Pro&#34;
    > (in
    > two
    > places) and you&#39;ll be all set.


    > Sorry for
    > the
    > inconvenience,


    >
    > John




  2. #2
    Frank Guest

    switch from Grid to Form problem (bof, eof error) ADODB.Field error '800a0bcd', still here

    Igor,

    I got it... it is a bug ... nasty one. Thanks for the bug report. Will issue a new version.

    Frank


    On 2/9/99 9:10:01 AM, Igor Soyfer wrote:
    >
    Frank, the problem is Not with setup or DSN. If you have time to read
    > through this post you&#39;ll see that John said about AspDb.V2
    that
    > you use on your machine and I&#39;m using AspDbPro. My problem that when I
    > use the supplied sample I get the error (see subject
    line) or no
    > records found while switching to a form view from the grid view after I
    > clicked on the link to get record for a &#39;Child&#34;
    > AspDb.
    Thanks,
    Igor
    Here is the sample code again
    > (the same you were using) :
    <%

    > Set X=Server.CreateObject(&#34;AspDB.Pro&#34

    > X.dbDSN=&#34;pubs&#34;
    X.dbDBType=&#34;SQL&#34;

    > X.dbSQL=&#34;select * from employee&#34;

    > X.dbmode=&#34;both&#34;
    X.dbUnit=1

    > 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;

    > X.aspdbPro


    > myvar=request(&#34;ID&#34
    if myvar<>&#34;&#34;
    > then
    response.write(&#34;<CENTER><h2>Database #2 -
    > Job for&#34; & myvar & &#34; </h2></CENTER>&#34
    Set
    > Y=Server.CreateObject(&#34;AspDB.Pro&#34

    > Y.dbDSN=&#34;pubs&#34;

    Y.dbDBType=&#34;SQL&#34;

    > Y.dbmode=&#34;grid&#34;
    Y.dbUnit=2
    >

    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
    end if
    %>


    > On 2/5/99 2:13:38 PM, wrote:
    >
    > &#34;Server.CreateObject Failed&#34; usually means bad setup or DSN. Check
    >
    > your setup again and use the supplied PureASP util
    > to check the
    > setup.

    On
    > 2/4/99 10:12:51 AM, Igor Soyfer wrote:
    > John, the
    > problem is that it is exactly the code I tried before Franks&#39;s reply
    > and it doesn&#39;t work. To make sure I
    > didn&#39;t
    > miss anything I pasted Frank&#39;s code again with change

    > > V2 on Pro and it does the same thing.
    > I
    > will
    > appreciate if you can make it work and
    > provide for
    > me the solution .


    > > Igor

    On
    > 2/3/99
    > 3:35:50 PM, John
    > wrote:
    >
    > Sorry Igor,


    > Frank
    >
    > pasted code from his machine which is running
    >
    > version

    > > 2 of the software. Simple replace the
    >
    > &#34;V2&#34; with &#34;Pro&#34;

    > > (in
    > two
    > places) and
    > you&#39;ll be all set.


    > Sorry for

    > > the
    > inconvenience,



    > >
    > John




  3. #3
    Igor Guest

    switch from Grid to Form problem (bof, eof error) ADODB.Field error '800a0bcd', still here

    Any ideas when ?

    On 2/9/99 10:29:49 AM, Frank wrote:
    > Igor,

    I got it... it is a bug ... nasty one. Thanks for the bug report.
    > Will issue a new version.

    Frank

  4. #4
    Guest

    switch from Grid to Form problem (bof, eof error) ADODB.Field error '800a0bcd', still here

    Frank, thanks !
    It seems to work now great.
    Igor

    On 2/9/99 11:36:01 AM, Frank wrote:
    > Igor,

    Now, I already send over the fix (ver. 1314f) to MMS. Call them or
    > E-mail them for a copy.

    Frank

Posting Permissions

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