"Unknown" and "Invalid use of Null" errors when performing SQL queries

Question

A customer of ours has encountered some strange behavior. Our software uses a database and we connect to it by the JET engine 4.0. We retrieve information by using SQL statements. So these commands are the same for every installation/user. We have a lot of customers but there is only one who encounters the following issue:

Some SQL statements cause strange errors:

SELECT * FROM Dimensions

=> Successful

SELECT * FROM Sections where true=false

=> Error : "Unknown"

SELECT Alpha, Ys, Zs FROM SectionProperties WHERE Id = 1

=> Error : "Invalid use of Null"

These statements run without a problem on any other machine.

I assume "JET engine" means Microsoft Access?

user330315
– user330315

2013-08-22 18:56:57 +00:00
Commented Aug 22, 2013 at 18:56 — user330315
– user330315, Commented Aug 22, 2013 at 18:56

Metaphor · Accepted Answer · 2013-08-22 15:30:52Z

1

Check the version of Jet at the client with problems. Probably needs an update.

answered Aug 22, 2013 at 15:30

Metaphor

6,42512 gold badges58 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sander Over a year ago

The version of msjet40.dll is 4.0.9765.0 Seems up to date to me.

Metaphor Over a year ago

Re-apply the update anyway, in case it got trashed by some package with a bad install.

Collectives™ on Stack Overflow

"Unknown" and "Invalid use of Null" errors when performing SQL queries

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related