ado.net error oledbexception

[jjhobs]

I have a visual basic program which links to an access database. On the line of code which filles the dataset from the data adapter I get the following error:

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll.

Curiously, another program which worked perfectly on a different machine also threw up the same error when run on the same computer as the above. Can anybody tell me what could be causing the error and the best way to resolve it.

Thanks

 

[jebenson]

To get a more detailed error message:

Try

'dataset fill code here

Catch ex as Exception

msgbox(ex.Message)

End Try



Try this and post back with the more detailed error message.



I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira

 

[jjhobs]

The detailed error message obtained is as follows:

No value given for one or more required parameters.

I would appreciate any help.

 

[jebenson]

Sorry for the delay in replying.

The error message indicates that the error is likely in your SQL code. Try running the selecy query in Access. Check that you have the correct spellings for any fields in the select list, as well as in any Where clause. Also, make sure that your field names are not reserved keywords:

List of reserved words in Microsoft Access 97, 2000, 2002 and Access 2003

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira