Hi I have a linked server to MSAccess DB and, when I try to select record from a table that have a column with a bad date formatted (with year less than 1753) I receive the message: …. conversion error from DBTYPE_DBTIMESTAMP to datetime…. My scope is set to NULL this bad values from Sql Server … I first try with something like UPDATE LNK_SVR…TABLE SET FLD=NULL WHERE ISDATE(FLD)=0 But I receive the same error… perheaps the provider generate the error before an Sql Server evaluation … So I think to a passthrought query: exec sp_serveroption @server=‘LNK_SVR’,@optname=‘rpc out’,@optvalue=‘true’ exec LNK_SVR…sp_executesql ‘update table set FLD=NULL WHERE YEAR(FLD)<1753′ But I receive the folowing message …. Messaggio 7213, livello 16, stato 1, riga 1 Il provider non è riuscito a passare parametri di stored procedure remota al server remoto ‘LNK_SVR. Verificare che il numero, l’ordine e il valore dei parametri passati siano corretti. Any suggestion is appreciate. Thanks in advance Matteo Mds Bookmark:Digg
Del.icio.us
Reddit
