 |
| Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
September 19th, 2004, 01:59 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
"Insert into" close reopen table2 for display
where do I go wrong?
I tried closing the first connection and then reopen so that I can view the "results" table. But it doesn't work entirely.
Quote:
quote:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/kjvresp.asp, line 298
|
Here is the text file:
http://n.1asphost.com/wheelofgod/kjvresp.txt
|
|
September 19th, 2004, 08:23 PM
|
|
Friend of Wrox
|
|
Join Date: Sep 2003
Posts: 363
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Hello
check this statement
set outpostDB = Server.CreateObject("ADODB.Connection")
outpostDB.Open "kjv"
|
|
September 19th, 2004, 08:26 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Hi,
What is on line 298?
Is this the one?
outpostDB.Open "kjv"
If so what is "kjv"? Check out for parameters that are used in connection object's OPEN method. It won't understand what KJV is.
Cheers!
_________________________
- Vijay G
Strive for Perfection
|
|
September 20th, 2004, 09:00 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
kjv is the name of the database.
|
|
September 20th, 2004, 09:09 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
WHen I tested my asp page on the web things worked out except that the results page is giving the table is awkward. And the results are repeated twice. Example:
http://n.1asphost.com/wheelofgod/kjv...s&optAction=on
|
|
September 20th, 2004, 08:18 PM
|
|
Friend of Wrox
|
|
Join Date: Sep 2003
Posts: 363
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Hi,
When i click the link, it displays message by free service provider "The bandwidth quota has been exceeded".
If it(kjv) is database name, how come it executes fine in your system. Coz, u included in quotes jus as a string. no extension, no specific path
Make it clear.
|
|
September 20th, 2004, 08:40 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
it'll be active for tommorrow. I didn't expect that. But I think it should be working since I made adjustments on Front Page.
|
|
September 22nd, 2004, 06:47 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
What adjustments you made in frontpage pertaining to KJV to get that work? To my knowledge it is not a valid usage for Connection object's open method.
_________________________
- Vijay G
Strive for Perfection
|
|
September 25th, 2004, 06:05 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
The adjustments were on the html table.
|
|
|
