SQL2000 distr query issue: can''t pass DateTime parameter to Jet4.0 OLEDB provider!

• Stanislav Ostachevski

  Newbie

  Points: 1

  More actions

  April 12, 2005 at 12:40 pm

  #92805

  Can anyone help me?

  I have *large* legacy app written in Access. Now I do step-by-step upsize work in order to rewrite it completely. This requires me to upsize some of its modules immediately to SQL server.

  I've linked Access MDBs to SQL Server. Now I run distributed queries like that:

  Select * From MyMDB...Orders Where OrderDate Between '1/1/5' And GETDATE()

  Unfortunately, I can't pass DATETIME parameters to Jet 4.0 providers (collation issue??). So the select statement listed above does a complete scan of the whole Access table.

  I can rewrite some SQLs using OPENQUERY, but I can't effectively deal with dynamic SQL creation, and the legacy application uses dynamic SQL a lot (

  I tried to configure ODBC data provider, but I run into "bad catalog information" error :-(((

  Is there any way to MAKE that provider accept DateTime parameters??

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  April 12, 2005 at 2:33 pm

  #552241

  I hate to ask this but, is there an index on OrderDate?

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net