-
ADODB.Field error '800a0bcd', still here
John, the problem is that it is exactly the code I tried before Franks's reply and it doesn't work. To make sure I didn't miss anything I pasted
Frank'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 "V2" with "Pro" (in
> two places) and you'll be all set.
Sorry for the
> inconvenience,
John
On 2/3/99 1:12:38 PM, Igor wrote:
>
What is
> the AspDb.V2 ?
When I try it it gives me an error:
Server
> object
> error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
>
>
/hsCShow/tstAspdb2db.asp, line 10
Invalid class string
On 2/3/99
>
> 12:04:48 PM, Frank wrote:
> Try the following -
<%
Set
>
>
> X=Server.CreateObject("AspDB.V2"
X.dbDSN="pubs"
X.dbDBTyp
>
>
> e="SQL"
X.dbSQL="select * from
>
>
> employee"
X.dbmode="both"
X.dbUnit=1
>
>
>
X.dbcolor="7,auto,lightgrey"
X.dbGridColSort=true
X.dbGridtablet
>
>
>
>
> ag="border=1"
X.dbFormtabletag="border=1"
X.dbGridInc=3
X
>
>
> .dbMagicCell="4,,<A HREF=""#me#?ID=#4#"">Click
> for
>
> details of #4#</a>"
>
X.aspdbV2
myvar=request("ID"
if
>
> myvar<>""
> then
response.write("<CENTER><h2>Database #2 -
> Job
> for" &
> myvar & " </h2></CENTER>"
Set
>
>
> Y=Server.CreateObject("AspDB.V2"
Y.dbDSN="pubs"
>
>
>
Y.dbDBType="SQL"
Y.dbmode="grid"
Y.dbUnit=2
>
>
>
Y.dbcolor="4,auto"
Y.dbGridTableTag="BORDER=1"
Y.dbNavig
>
>
> ation="none"
Y.dbSQL="select * from jobs where
>
> job_id=" &
> myvar '& "'"
Y.aspdbV2
end
>
> if
%>
On 2/3/99
> 9:53:57 AM, Igor wrote:
> Hi, Frank, here
>
> is my code, AspDb sample
> applied to Pubs database on Sql
>
>
> Server.
When in a grid form - it
> works. When switch to a form view
>
> for a
> parent AspDb things get messed
> up.
All what you need to
> do
> to see it just
> click on the Next
> buton.
<%@
> Language=VBScript
> %>
<HTML>
<HEAD>
<META
>
>
> NAME="GENERATOR"
> Content="Microsoft Visual Studio
>
>
> 6.0">
</HEAD>
<BODY>
> <%
Set
>
>
>
> X=Server.CreateObject("AspDB.Pro" '** 01
>
>
>
> X.dbDSN="pubs" '**
> 02
X.dbDBType="SQL"
>
>
>
> X.dbSQL="select * from employee"
>
>
>
> X.dbmode="both"
X.dbUnit=1 '** 04
>
>
>
> X.dbcolor="7,auto,lightgrey"
>
>
>
> X.dbGridColSort=true
>
> X.dbGridtabletag="border=1"
>
>
>
> X.dbFormtabletag="border=1"
>
>
>
> X.dbGridInc=3
X.dbMagicCell="4,,<A
>
>
>
> HREF=""#me#?ID=#4#"">Click for details of #4#</a>"
>
>
>
> '** 05
X.aspdbPro' '** 06
>
>
>
> %>
<%
>
> myvar=request("ID"
> '**
> 07
if
>
> myvar<>"" then '** 08
>
> %>
>
> <CENTER><h2>Database #2 - Job for
>
> #<%=myvar%></h2></CENTER>
>
> <%
Set
>
>
>
> Y=Server.CreateObject("AspDB.Pro" '** 09
>
>
>
> Y.dbDSN="pubs" '** 10
Y.dbDBType="SQL"
>
>
>
> Y.dbmode="grid"
Y.dbUnit=2
> '**
> 11
>
> Y.dbcolor="4,auto"
>
>
>
> Y.dbGridTableTag="BORDER=1"
>
>
>
> Y.dbNavigation="none"
Y.dbSQL="select
> * from
>
>
> jobs where job_id=" & myvar '&
> "'"
>
>
> Y.aspdbPro '** 13
> end if
>
>
>
> %>
<P> </P>
</BODY>
</HTML>
Thanks,
Igor
-
ADODB.Field error '800a0bcd', still here (reply)
"Server.CreateObject Failed" usually means bad setup or DSN. Check your setup again and use the supplied PureASP util to check the setup.
Frank
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's reply and it doesn't work. To make sure I didn't miss
> anything I pasted
Frank'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 "V2" with "Pro"
> (in
> two places) and you'll be all set.
> Sorry for the
> inconvenience,
> John
On 2/3/99 1:12:38 PM, Igor
> wrote:
>
What is
> > the AspDb.V2 ?
When I try it it gives me
> an error:
Server
> object
> > error 'ASP 0177 : 800401f3'
> Server.CreateObject Failed
>
> >
/hsCShow/tstAspdb2db.asp, line 10
> Invalid class string
On 2/3/99
> >
> 12:04:48 PM, Frank wrote:
> > Try the following -
<%
> Set
>
>
> > X=Server.CreateObject("AspDB.V2"
> X.dbDSN="pubs"
X.dbDBTyp
> >
>
> e="SQL"
> X.dbSQL="select * from
>
> >
> employee"
> X.dbmode="both"
X.dbUnit=1
> >
>
>
> X.dbcolor="7,auto,lightgrey"
> X.dbGridColSort=true
X.dbGridtablet
> >
>
>
> >
> ag="border=1"
> X.dbFormtabletag="border=1"
X.dbGridInc=3
> X
>
>
> > .dbMagicCell="4,,<A
> HREF=""#me#?ID=#4#"">Click
> for
> >
> details of #4#</a>"
> >
X.aspdbV2
> myvar=request("ID"
if
> >
> myvar<>""
> then
>
response.write("<CENTER><h2>Database #2 -
> > Job
> for" &
> > myvar & " </h2></CENTER>"
Set
> >
>
>
> Y=Server.CreateObject("AspDB.V2"
> Y.dbDSN="pubs"
>
>
> >
Y.dbDBType="SQL"
> Y.dbmode="grid"
Y.dbUnit=2
> >
>
>
> Y.dbcolor="4,auto"
> Y.dbGridTableTag="BORDER=1"
Y.dbNavig
> >
>
>
> ation="none"
Y.dbSQL="select * from jobs
> where
>
> job_id=" &
> > myvar '& "'"
> Y.aspdbV2
end
>
> > if
%>
On
> 2/3/99
> 9:53:57 AM, Igor wrote:
> > Hi, Frank, here
>
> is
> my code, AspDb sample
> applied to Pubs database on
> Sql
>
>
> > Server.
When in a grid form - it
> > works. When switch to a form view
>
> > for a
> parent AspDb things get
> messed
> up.
All what you need
> to
> do
> to see it just
> > click on the Next
> buton.
> <%@
> Language=VBScript
> > %>
<HTML>
<HEAD>
> <META
>
>
>
> NAME="GENERATOR"
>
> Content="Microsoft Visual Studio
>
> >
> 6.0">
> </HEAD>
<BODY>
> <%
> Set
>
>
> >
>
> X=Server.CreateObject("AspDB.Pro" '** 01
> >
>
>
> > X.dbDSN="pubs" '**
> 02
> X.dbDBType="SQL"
>
> >
>
>
> X.dbSQL="select * from employee"
>
> >
>
>
> X.dbmode="both"
X.dbUnit=1 '** 04
> >
>
>
> > X.dbcolor="7,auto,lightgrey"
> >
>
>
> > X.dbGridColSort=true
>
> > X.dbGridtabletag="border=1"
>
> >
>
>
> X.dbFormtabletag="border=1"
>
> >
>
>
> X.dbGridInc=3
X.dbMagicCell="4,,<A
> >
>
>
> > HREF=""#me#?ID=#4#"">Click for details of
> #4#</a>"
>
>
> >
> '** 05
> X.aspdbPro' '** 06
>
> >
>
> %>
> <%
>
>
> myvar=request("ID"
> '**
> > 07
if
>
> > myvar<>"" then '** 08
>
> > %>
>
>
> <CENTER><h2>Database #2 - Job for
>
> > #<%=myvar%></h2></CENTER>
>
> > <%
Set
>
> >
>
>
> Y=Server.CreateObject("AspDB.Pro" '** 09
> >
>
>
> > Y.dbDSN="pubs" '** 10
> Y.dbDBType="SQL"
>
> >
>
>
> Y.dbmode="grid"
Y.dbUnit=2
> > '**
> 11
>
> > Y.dbcolor="4,auto"
>
>
>
>
>
> Y.dbGridTableTag="BORDER=1"
>
> >
>
>
> Y.dbNavigation="none"
Y.dbSQL="select
>
> * from
>
> >
> jobs where job_id=" & myvar '&
> > "'"
>
> >
> Y.aspdbPro '** 13
> > end if
>
>
> >
> %>
<P>
> </P>
</BODY>
</HTML>
> Thanks,
Igor
-
ADODB.Field error '800a0bcd', still here (reply)
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.
Here is the sample again:
<%
Set X=Server.CreateObject("AspDB.Pro"
X.dbDSN="pubs"
X.dbDBType="SQL"
X.dbSQL="select * from employee"
X.dbmode="both"
X.dbUnit=1
X.dbcolor="7,auto,lightgrey"
X.dbGridColSort=true
X.dbGridtabletag="border=1"
X.dbFormtabletag="border=1"
X.dbGridInc=3
X.dbMagicCell="4,,<A HREF=""#me#?ID=#4#"">Click for details of #4#</a>"
X.aspdbPro
myvar=request("ID"
if myvar<>"" then
response.write("<CENTER><h2>Database #2 - Job for" & myvar & " </h2></CENTER>"
Set Y=Server.CreateObject("AspDB.Pro"
Y.dbDSN="pubs"
Y.dbDBType="SQL"
Y.dbmode="grid"
Y.dbUnit=2
Y.dbcolor="4,auto"
Y.dbGridTableTag="BORDER=1"
Y.dbNavigation="none"
Y.dbSQL="select * from jobs where job_id=" & myvar '& "'"
Y.aspdbPro
end if
%>
On 2/5/99 2:13:38 PM, wrote:
> "Server.CreateObject Failed" 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's reply and it doesn't work. To make sure I
> didn't miss anything I pasted Frank'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
> "V2" with "Pro"
> (in
> two
> places) and you'll be all set.
> Sorry for
> the
> inconvenience,
>
> John
On 2/3/99 1:12:38 PM, Igor
> wrote:
> >
What is
>
> > the AspDb.V2 ?
When I try it it gives me
> an
> error:
Server
> object
>
> > error 'ASP 0177 : 800401f3'
>
> Server.CreateObject Failed
>
>
> >
/hsCShow/tstAspdb2db.asp, line 10
>
> Invalid class string
On
> 2/3/99
> >
> 12:04:48 PM,
> Frank wrote:
> > Try the following -
> <%
> Set
>
> >
> >
> X=Server.CreateObject("AspDB.V2"
>
> X.dbDSN="pubs"
X.dbDBTyp
>
> >
>
> e="SQL"
>
> X.dbSQL="select * from
>
>
> >
> employee"
>
> X.dbmode="both"
X.dbUnit=1
>
> >
>
> >
> X.dbcolor="7,auto,lightgrey"
>
> X.dbGridColSort=true
> X.dbGridtablet
> >
>
> >
> >
>
> ag="border=1"
>
> X.dbFormtabletag="border=1"
X.dbGridInc=3
>
> X
>
>
>
> > .dbMagicCell="4,,<A
>
> HREF=""#me#?ID=#4#"">Click
> for
>
> >
> details of #4#</a>"
>
> >
X.aspdbV2
>
> myvar=request("ID"
if
>
> >
> myvar<>""
> > then
>
> response.write("<CENTER><h2>Database #2 -
> >
> Job
> for" &
> > myvar
> & " </h2></CENTER>"
Set
>
> >
>
>
>
> Y=Server.CreateObject("AspDB.V2"
>
> Y.dbDSN="pubs"
>
>
>
> >
Y.dbDBType="SQL"
>
> Y.dbmode="grid"
> Y.dbUnit=2
> >
>
> >
> Y.dbcolor="4,auto"
>
> Y.dbGridTableTag="BORDER=1"
> Y.dbNavig
> >
>
> >
> ation="none"
> Y.dbSQL="select * from jobs
> where
>
> > job_id=" &
> > myvar '&
> "'"
> Y.aspdbV2
> end
>
> > if
> %>
On
> 2/3/99
> > 9:53:57 AM, Igor wrote:
> > Hi, Frank, here
>
>
> is
> my code, AspDb
> sample
> applied to Pubs database on
> Sql
> >
>
> >
> Server.
When in a grid form - it
>
> > works. When switch to a form view
>
>
> > for a
> parent AspDb things
> get
> messed
> up.
All what
> you need
> to
> do
> to see
> it just
> > click on the Next
> > buton.
> <%@
>
> Language=VBScript
> > %>
> <HTML>
<HEAD>
> <META
> >
>
>
>
> NAME="GENERATOR"
>
>
> Content="Microsoft Visual Studio
>
>
> >
> 6.0">
>
> </HEAD>
<BODY>
> <%
>
> Set
>
>
>
> >
>
>
> X=Server.CreateObject("AspDB.Pro" '** 01
>
> >
>
>
>
> > X.dbDSN="pubs" '**
> 02
>
> X.dbDBType="SQL"
>
>
> >
>
>
>
> X.dbSQL="select * from employee"
>
>
> >
>
>
>
> X.dbmode="both"
X.dbUnit=1 '**
> 04
> >
>
> >
> >
> X.dbcolor="7,auto,lightgrey"
> >
> >
>
> >
> X.dbGridColSort=true
>
> >
> X.dbGridtabletag="border=1"
>
>
> >
>
>
>
> X.dbFormtabletag="border=1"
>
>
> >
>
>
>
> X.dbGridInc=3
X.dbMagicCell="4,,<A
>
> >
>
>
>
> > HREF=""#me#?ID=#4#"">Click for details
> of
> #4#</a>"
>
>
>
> >
> '** 05
>
> X.aspdbPro' '** 06
>
>
> >
>
> %>
>
> <%
>
> >
> myvar=request("ID"
> '**
>
> > 07
if
>
>
> > myvar<>"" then '** 08
> >
> > %>
>
> >
> <CENTER><h2>Database #2 - Job for
> >
> > #<%=myvar%></h2></CENTER>
> >
> > <%
Set
> >
> >
>
> >
> Y=Server.CreateObject("AspDB.Pro" '**
> 09
> >
>
> >
> > Y.dbDSN="pubs" '** 10
>
> Y.dbDBType="SQL"
>
>
> >
>
> >
> Y.dbmode="grid"
Y.dbUnit=2
>
> > '**
> 11
> >
> > Y.dbcolor="4,auto"
> >
>
>
>
> >
> Y.dbGridTableTag="BORDER=1"
> >
> >
>
> >
> Y.dbNavigation="none"
> Y.dbSQL="select
>
> * from
> >
> >
> jobs where
> job_id=" & myvar '&
> >
> "'"
>
> >
> > Y.aspdbPro '** 13
> >
> end if
>
>
>
> >
> %>
<P>
>
> </P>
</BODY>
</HTML>
>
> Thanks,
Igor
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
|
|