Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No value given for one or more required parameters

Status
Not open for further replies.

SwanSong4

MIS
Jul 19, 2001
9
US
Thought I was getting somewhere, it seems everytime I get past one thing its another. I've had many problems, from drivers coming up missing to PC problems.
I am working on connectivity with ADO and I have set my Data sources and fields. After this when I try and run the program it says "No value given for one or more required parameters"

Any idea?
 
What exactly are you doing?
Are u using adodc control?
If so did u set the ConnectionString parameters correctly?
 
I am just trying to connect to a database, the error message comes right when I run it. I am using Adodc.
The connection string is set and the test connection works.

connection string is
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\JH_VB_DB\PAICdb.mdb;Mode=Read|Write;Persist Security Info=False

I'm not really sure, I am not really a programmer but my boss seems to think I can write a insurance rater for a first program on a POS laptop.


 
I am just trying to connect to a database, the error message comes right when I run it. I am using Adodc.
The connection string is set and the test connection works.

connection string is
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\JH_VB_DB\PAICdb.mdb;Mode=Read|Write;Persist Security Info=False

Do you need to know any thing else?

I'm not really sure, I am not really a programmer but my boss seems to think I can write a insurance rater for a first program on a POS laptop.


 
You say you have set the fields I would suggest this is the problem. This error is common if a field is spelt incorrectly or does not exist. Check this out.
Assuming the db exists the connection string looks OK

sdh
::)
 
You might check the Access database design and make sure you are not using / \ - _ or other special characters. Visual Basic does not like that when you try to bind to the database.

marvalex@usa.net
 
When you say you are just trying to connect to the database, are you explictly stating something in your code, or does the error occur immediately when you try to run the app? Can you post the line of code(if available) that generates the error?
 
Swansong4 -

You may want to read my reply in: thread709-123433
It has some code samples that might help you.

Chip H.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top