Problem with OleDB Dateformats using Access-DB

S

Stefan Landgraf

Hi,

I have a Webapplication running fine on a German Webserver but giving an error
'Data type mismatch in criteria expression' when using German date formats in
Update/Insert commands on an Access Database.
'01.01.2004' fails, '2004-01-01' is accepted.
I tried setting the locale to german using 'Locale Identifier=1031' in my
connection string, without success.

Does anyone have an idea?

Regards

Stefan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,774
Messages
2,569,596
Members
45,143
Latest member
DewittMill
Top