How to Connect to SQL 2005 using SQLOLEDB Provider

• MostInterestingMan

  SSCertifiable

  Points: 6291

  More actions

  January 20, 2011 at 1:40 pm

  #245716

  Hi,

  Is it possible to use the SQL 2000 provider(SQL OLEDB) to connect to SQL 2005? I recently migrated an Access application that uses the SQL 2000 OLE DB provider to connect to my old SQL 2000 instance but is now failing to connect to SQL 2005. Any help/suggestions or workaround is appreciated.

  Thanks

  MCTS: BI 2008, MCITP: BI 2008
  Stay Thirsty My Friends

• Terry-239890

  Ten Centuries

  Points: 1387

  More actions

  January 20, 2011 at 9:56 pm

  #1276369

  I happened to find somebody who had similar issue as yours but I am not entirely sure if the solution he had would work for you.

  This is web address: http://www.tek-tips.com/viewthread.cfm?qid=1455363&page=5

  Good luck.