Data type mismatch between ACCESS and SQL server

• thriveni

  Ten Centuries

  Points: 1104

  More actions

  October 27, 2004 at 9:07 am

  #76199

  I have a stored procedure in SQL server  with a date parameter input(varchar) that

  runs FINE on the server itself with query analyzer.

  But when I try calling the same stored proc from ACCESS 2000

  using the ADO execute command, I get the error:

  cannot convert varchar to smalldatetime.

  The date is actually used in a query in the WHERE statement in the stored

  procedure and the date input is a varchar. I know SQL server does an implicit

  conversion of varchar to smalldatetime so why is ACCESS so particular ? I

  even tried changing the stored proc's input to a date variable but that did

  not help.

  Any help would be appreciated.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  October 28, 2004 at 1:37 am

  #528254

  A code snippet would be of some help.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]