473,597 Members | 2,749 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Microsoft JET Database Engine (0x80040E10)

Fary4u
273 Contributor
i've recived error
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.


Expand|Select|Wrap|Line Numbers
  1. get handle on data
  2. 'Const adOpenKeyset = 3
  3. 'Const adLockReadOnly = 3
  4.  
  5. Dim rsProduct, sSQLa, rsSizes, rsColours
  6.  
  7. sSQLa = "select * from products where productID= '" & intProdID & "'"
  8. set rsProduct = Server.CreateObject("ADODB.RecordSet")
  9. rsProduct.open sSQLa, ConString,adOpenKeyset,adLockReadOnly
  10.  
  11. ' get sizes
  12. sSQLa = "select * from size1,product_sizes where size1.id = size_id and productID='" & intProdID & "'"
  13. set rsSizes = Server.CreateObject("ADODB.RecordSet")
  14. rsSizes.open sSQLa, ConString,adOpenKeyset,adLockReadOnly
it's MS ACCESS database with the ProductID is text i've changed into autonumber to Text

any solution ?
Oct 9 '07 #1
1 2777
jhardman
3,406 Recognized Expert Specialist
Expand|Select|Wrap|Line Numbers
  1. response.write sSQLa
  2. rsSizes.open ...
This is kind of a standard troubleshooting technique, it gives you a chance to see how the query turned out.

Jared
Oct 11 '07 #2

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

Similar topics

6
20998
by: Miranda | last post by:
Hello, could somebody please help me figure this error out. I'm at my wits end here. This is my connection & SQL statement: <%@Language="Javascript" %> <!--#include file="../../admin/adojavas.inc"--> <% var conn; var rs; var sSQL;
3
1670
by: lucilue2003 | last post by:
How do i get all the posted data. Suppose i have a form page (myform.html) and i am SENDING data to form.asp, how do i retrieve all data that was sent by post and by get ? THanks
5
12512
by: Kamyk | last post by:
Hello all! I have a tough thing to fix. I have a database which has been corrupted. I got the following error messages while trying to open it: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time The database is protected by password, so when I want to open I got the above error message. I cannot import data from this corrupted database into
2
2076
by: Abubakar | last post by:
Hello , I just finished developing a program using Microsoft Desktop Engine with C# as the front end. Everything is okay on my system. But, on trying to deploy it on a different system it gives an error message that it can open the database This is my first time in using the Microsoft Desktop engine. All this while I have been using Access as my database engine and normally what I do after developing a program is to transfer the Database file...
2
2175
by: Phil McKrackin | last post by:
Hello all, I've been blazing through John Sharp and Jon Jagger's "Microsoft Visual C# .NET Step by Step" book, but I've hit a bit of a roadblock once I made it to the database section. Specifically, chapter 24, "Using a Database." Can some kind soul help me get my machine in a state that I can continue the exercises in this book?
5
4449
by: Dave | last post by:
This is my first .NET project (although I am experienced with VS6 and InterDev). I am simply trying to set up a basic ASPX project and connect to an Access database (following the instructions in the .NET Black Book by Templeman and Vitter). I have managed to set up an oleDbConnection, an oleDbAdapter and a dataset, and have added one line of code: oleDbDataAdapter1.Fill(dataSet1); However when this line of code executes I get whole page...
3
6881
by: Neal | last post by:
Hi All I am trying to connect from ASP.Net app to an Access Db. If i don't specify a userid an pwd.. I get this error The Microsoft Jet database engine cannot open the file 'C:\Documents and Settings\rogersn\My Documents\EEECourses.mdb'. It is already opened exclusively by another user, or you need permission to view its data." If i specify a userid (aspnet) no password I get
0
2716
by: Genken | last post by:
Please assist in this error i have provided the source code. Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) Too few parameters. Expected 1. <% Set objconn = Server.CreateObject("ADODB.Connection") objconn.ConnectionString = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath('mypath") objconn.Open
2
1731
by: =?Utf-8?B?b3JjYXVzZXI=?= | last post by:
The Microsoft Jet Engine is deprecated. It's probably not a good idea to use the Microsoft Jet Engine in a new product development with .NET. What is the replacement for the Jet Engine? Yes, there is the SQL Server / SQL Server Express combination. But I'm looking for a database which is easy to deploy and low administration expense. In a VB6 application you can use the Microsoft Jet Engine. But what should you use in a .NET application?
0
7969
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
7886
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8381
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8258
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6688
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5431
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3886
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3927
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1238
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.