Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Provider error ’80004005’  Error no escif
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Provider error ’80004005’ Error no escif

 Post Reply Post Reply
Author
TCL_ZIP View Drop Down
Newbie
Newbie
Avatar

Joined: 03 June 2005
Location: Spain
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote TCL_ZIP Quote  Post ReplyReply Direct Link To This Post Topic: Provider error ’80004005’ Error no escif
    Posted: 03 June 2005 at 8:54am
Cuando entro en el foro me sale el siguiente error:

Provider error '80004005'

Error no especificado

/forum/common.asp, línea 260

y no me detecta ningun foro :S
_____________________________________________________________
When I start the forum, send me this error:

Provider error '80004005'

Error no especificado

/forum/common.asp, línea 260



Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 03 June 2005 at 9:57am
im not to sure on that as i can't speak/read spanish, but it looks like a connection erorr.

make sure you have the correct folder permsssions on the database, also try re uplkoading the files to make sure they haven't/weren't corruptted during the transferr.
Back to Top
fastlane View Drop Down
Newbie
Newbie
Avatar

Joined: 09 June 2005
Location: Singapore
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote fastlane Quote  Post ReplyReply Direct Link To This Post Posted: 09 June 2005 at 10:45am
I think "Error no especificado" means "Unspecifed Error".
I got the same error too. It happens when I tried to execute the following SQL statement:
 
SELECT TOP 5 *
FROM tblTopic
WHERE Locked = False
AND Forum_ID IN
(SELECT Forum_ID FROM tblForum WHERE Locked=False AND Read=1)ORDER BY Last_entry_date DESC
 
For my problem, I think it has something to do with the criteria 'Read=1' in the sub-query, I don't get any error when I remove it.
 
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 09 June 2005 at 11:02am
try change read=1 to read=True

you are cross coding your query there using an Access (true/False ) with MSSQL (1/0)
Back to Top
fastlane View Drop Down
Newbie
Newbie
Avatar

Joined: 09 June 2005
Location: Singapore
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote fastlane Quote  Post ReplyReply Direct Link To This Post Posted: 09 June 2005 at 12:06pm
Originally posted by dj air dj air wrote:

try change read=1 to read=True

you are cross coding your query there using an Access (true/False ) with MSSQL (1/0)
Tried that and doesn't work. In fact, Read field in tblForum has values of 1,2,3,4, so I don't think it's boolean.
 
If I do the query directly in MS Access, no problem, but the same SQL statement doesn't work when I execute it from my asp page.
 
Back to Top
fastlane View Drop Down
Newbie
Newbie
Avatar

Joined: 09 June 2005
Location: Singapore
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote fastlane Quote  Post ReplyReply Direct Link To This Post Posted: 09 June 2005 at 12:31pm
It's ok now. Got a clue from another post.
Have to use [Read]=1 instead of Read=1, in my SQL statement.
 
 
 
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.