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

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

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

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