Invalid use of null via ODBC? (1 Viewer)

[Kowalski]

We've got an Access application that connects to either a SQL database or to an Access database.
Now we found 1 or 2 pc's where, if connected to SQL (via ODBC) you get an "Invalid use of Null" error when changing any currency or date fields. It's not in the application as in only happens on 1 or 2 pc's. Changing the regional settings of the pc doesn't help.
(We are using the default ODBC settings, so the "Use regional settings..." setting is not selected - but selecting it does not solve the problem)

 

[peej228]

Sql Server Nulls passed to a Date Data Type

Nulls cannot be passed to a Date data type with sql server.
You can create a date in access without a value and pass that to the parameter

'For currency
dim dblValue as double
dblValue = val(nz(me.txtCurrency,0))
'Pass dblValue normally


dim DtValue as Date


dim cmd as adodb.command
cmd.ActiveConnection = cn 'Assign your connection here
cmd.CommandType = adCmdUnknown
cmd.CommandText = strSQL 'Assign SQL statement here

Set Param = cmd.CreateParameter(, adDate, adParamInput, 50, dtValue)
cmd.Parameters.Append Param
set Param = nothing
cmd.Execute
set cmd = nothing