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