• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

(0x80004005) Unspecified Error

I'm using the following code with an Access97 database (which I have no control over). Line 36 keeps bringing up the error:

ERROR MESSAGE:
********************
Error Type:
(0x80004005)
Unspecified error
/directone/aa.asp, line 36
********************

LINE 36:
********************
set stockavail = conn.execute("select available, size, material " _
& "From T_Details where material = " & entry & ";")      
********************

It seems to work fine without trying to select 'size,' but this is something I need to be able to select. I've tried selecting
"size as somethingelse" but this still generates the same error.

Any ideas?

      

0
blurredvision
Asked:
blurredvision
  • 3
  • 3
2 Solutions
 
lluthienCommented:
did you try using [size]
instead of size?
0
 
RedKelvinCommented:
size is an sql keyword, either change the name of the column in the database, or wrap the column name is square brackets eg. [size]
0
 
RedKelvinCommented:
sorry lluthien, we must have been typing at the same time
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
blurredvisionAuthor Commented:
Yes that has done the trick. I'm not overly au fait with these SQL intricacies, and the square brackets have done the job. Given that you both supplied the right answer at the same time, the fairest thing to do seems to be to split the points. I'll increase the overall points to 150 so you both get 75 each...
0
 
lluthienCommented:
np
0
 
lluthienCommented:
glad to help
0
 
RedKelvinCommented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now