473,327 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

(0x80004005) Unspecified error

I need serious help with this. I can not work out why the database can't connect when using a certain SQL query.

My database DOES connect when I use certain fields, but not when I use other fields.

My code (which uses an Access database) - THIS VERSION WORKS

rs127mmPCB.Source = "SELECT * FROM 127mm WHERE (Orientation like 'Straight') "


My code (which uses an Access database) - THIS VERSION DOES NOT WORK

rs127mmPCB.Source = "SELECT * FROM 127mm WHERE (Rows like 'Dual row') "

There are NO spelling mistakes, and the word Rows is used in the access database. Is the word/term Rows a reserved term? Any help would be greatly appreciated.

Thank you

Dave
Jan 7 '08 #1
2 1147
jhardman
3,406 Expert 2GB
I need serious help with this. I can not work out why the database can't connect when using a certain SQL query.

My database DOES connect when I use certain fields, but not when I use other fields.

My code (which uses an Access database) - THIS VERSION WORKS

rs127mmPCB.Source = "SELECT * FROM 127mm WHERE (Orientation like 'Straight') "


My code (which uses an Access database) - THIS VERSION DOES NOT WORK

rs127mmPCB.Source = "SELECT * FROM 127mm WHERE (Rows like 'Dual row') "

There are NO spelling mistakes, and the word Rows is used in the access database. Is the word/term Rows a reserved term? Any help would be greatly appreciated.

Thank you

Dave
It is quite possilbe that "Rows" is a reserved term. Try enclosing it in square brackets: [Rows] - that usually helps hurdle any special character problems so it might help here.

Let me know if this helps.

Jared
Jan 7 '08 #2
Hi

I changed the term from Rows to NoRows and this has sorted the problem. You were right, it does seem to be a reserved word!

Thank you for your help!

Dave
Jan 7 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: rOadhOg | last post by:
Help please! I set up a simple access 2000 database and I'm running IIS5. The first time I try it, it works, then it seems like I have to wait for some kind of time out for it to work again,...
4
by: Jo Winchester | last post by:
We are getting the following error message when trying to access an .asp page in IIS 5 on a Windows 2000 server. I have found that (0x80004005) is a fairly common error, but usually it is...
5
by: khan | last post by:
Error Type: CreateRecordset (0x80004005) Unspecified error /finalsite/SearchResults.asp, line 47 this is my code can any one help plz why I am getting ths error <html> <head>
2
by: Shihao Png via DotNetMonster.com | last post by:
Well, the problem I'am having now applies to web applications only. Therefore, I believe it has something to do with security settings. Here's the code: ...
7
by: Jim McGivney | last post by:
ASPX page from VS.net-C# on host's computer using oleDataAdaptor to connect to Microsoft Access database. The page loads, but when connection to the database is attempted to fill a datagrid the...
0
by: Petemo94 | last post by:
Folks, I am getting a "sporadic" exception that contains the following stack trace. I say sporadic b/c my DB connection usually works fine, but occasionally it fails. *** I also noted that...
0
by: mamin | last post by:
Hi! While running my asp application under Windows 2000 the following error appears: Microsoft JET Database Engine (0x80004005) Unspecified error I've installed MS Jet 4.0 SP1 and MDAC 2.8 SP1...
0
by: Yelena Varshal | last post by:
Hello, I am using ODBC to access Microsoft Access database. I use just generic ADO code. I don't have problems opening multiple connections from the same page on the development server but the...
2
by: javediq143 | last post by:
Hi all, I set up a simple access database.Earlier my ASP page was working fine,but dont know whats gone wrong that it started to give me this Err: Error Type: Provider (0x80004005) Unspecified...
2
by: kanman | last post by:
hi all. im developing a web based application using asp.net i'm getting this error below: and idea on where the problem is and how to fix? thank you in advance Kanman
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.