Wrox Programmer Forums
|
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
 
Old July 13th, 2003, 02:24 PM
Registered User
 
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error Type: (0x80004005) Unspecified error

Hi Everyone,

I got the following error trying to run an ASP page:

Technical Information (for support personnel)

Error Type:
(0x80004005)
Unspecified error
/chamber/board.asp, line 56

If I use the following code I get no errors:

strSql = "SELECT PORTAL_MBOARD.ID, PORTAL_MBOARD.FIRST, PORTAL_MBOARD.LAST"
strSql = strSql & " FROM " & strMemberTablePrefix & "MBOARD "
        set rs = Server.CreateObject("ADODB.Recordset")
        rs.open strSql, my_Conn, 3

but, if the first line is replaced by:
strSql = "SELECT PORTAL_MBOARD.ID, PORTAL_MBOARD.FIRST, PORTAL_MBOARD.LAST, PORTAL_MBOARD.POSITION"

it is already not working. The field "POSITION" has the same settings as the other ones (type: TEXT, required: NO. allow zero length: YES)

Any ideas where the problems is coming from?
Thanks.


Wilfred
 
Old July 13th, 2003, 02:37 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Wilfred,

It looks like Position is a reserved keyword. I changed the column name to Position2 and then it works correctly.

Funny thing is that when you don't prefix the column name with the table name (Position instead of PORTAL_MBOARD.POSITION) no error occurs.

Try changing the name of the column and the error will go away.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old July 14th, 2003, 06:35 PM
Registered User
 
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Imar,

Thanks for your suggestions.

You were correct, as soon as I renamed "POSITION" to "MPOSITION", the code started to run properly.

Thanks again,

Wilfred
 
Old April 3rd, 2007, 09:04 AM
Registered User
 
Join Date: Apr 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to moud_gersy
Default

Hi there
I got the same error, but in a deff place
'//////
Set conn2 = Server.CreateObject("ADODB.Connection")
conn2.Open xDb_Conn_Str
set rs2 = Server.CreateObject("ADODB.Recordset")
rs2.Open sSql_, conn2, 1, 2 (**)
    if Not rs2.Eof then
            Cost_Score_=rs2(CImp)
    end if

'//////
(**)the error refers this line
so can any one helps me
thanx alot


Mahmoud_Ramzy





Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC Error Type 0x80004005 hbansal Classic ASP Professional 22 February 25th, 2009 12:57 AM
Error Type:Server.MapPath(), ASP 0171 (0x80004005) phantom3008 ASP.NET 1.0 and 1.1 Basics 2 April 26th, 2007 02:28 PM
Unspecified Error??? werD420 Classic ASP Databases 2 April 10th, 2005 01:00 PM
(0x80004005) Unspecified error MiltonAbreu Classic ASP Components 6 July 7th, 2004 11:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.