Solved

(0x80004005) Non specific error (ASP page)

Posted on 2009-04-06
3
237 Views
Last Modified: 2012-05-06
Hi All,

I am getting this non specific error and cannot fugure why. Any ideas.
-------------------------------------------------------------------------------------------
set rsData = Server.CreateObject("ADODB.Recordset")

rsData.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\Data\MyDataBase.mdb; Persist security Info=False"

strSQL = "SELECT ID, LangActive, PageLang, Language, VarFolderName FROM tblLanguages Where LangActive And LangBought Order By ID;"
rsData.Source = strSQL
rsData.Open  <<<<<<<<<<<<<<<<<<<<<<<<< This line throws the error !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Kind regards

A.
0
Comment
Question by:Abiel de Groot
3 Comments
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 250 total points
ID: 24076093
Try changing your code to the following and seeing if you get any more information:
set rsData = Server.CreateObject("ADODB.Recordset")
 

rsData.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\Data\MyDataBase.mdb; Persist security Info=False" 
 

strSQL = "SELECT ID, LangActive, PageLang, Language, VarFolderName FROM tblLanguages Where LangActive And LangBought Order By ID;"

rsData.Source = strSQL
 

On Error Resume Next
 

rsData.Open
 

For Each error In rsData.ActiveConnection.Errors

    Response.Write "error: " & error.Number & ", " & error.Description & "<br/>"

Next
 

On Error Goto 0

Open in new window

0
 
LVL 49

Assisted Solution

by:Ryan Chong
Ryan Chong earned 250 total points
ID: 24076145
>>SELECT ID, LangActive, PageLang, Language, VarFolderName FROM tblLanguages Where LangActive And LangBought Order By ID

Doesn't seems a valid SQL statement for me, try something like:

SELECT ID, LangActive, PageLang, Language, VarFolderName FROM tblLanguages Where LangActive = 1 And LangBought = 'balbal' Order By ID


in your "where" cause, try compare it with a value.....
0
 
LVL 5

Author Comment

by:Abiel de Groot
ID: 24076699
Hi Guys,

Many thanks. Both of your ideas helped in finally respoving the issue. It was a very stupid thing look at the select statement again:

SELECT ID, LangActive, PageLang, Language ...

The word "Language" is a reserved ASP word.

That caused the error.

Many thanks again.

Kind regards

Abiel M de groot

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now