Linked Server to Advantage DB using ODBC

• paulunsy

  SSC Enthusiast

  Points: 100

  More actions

  April 5, 2013 at 9:17 am

  #394533

  Hi Guys

  I have a bit of a problem. My linked server test returns successful, but when I try and run:

  select *

  from openquery(bradford,'select top 1 id from ttfa0s')

  I get the following:

  Msg 7399, Level 16, State 1, Line 1

  The OLE DB provider "MSDASQL" for linked server "bradford" reported an error. The provider reported an unexpected catastrophic failure.

  Msg 7330, Level 16, State 2, Line 1

  Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "bradford".

  I can run the same query, or anything I want in MS Access using the same ODBC connection, so I can't see it being a hardware issue...

  Can anyone see what I'm doing wrong?

  Thanks in advance...