Linked Server returns tables but cannot query

• juliekenny

  SSCommitted

  Points: 1558

  More actions

  November 19, 2003 at 4:09 am

  #76084

  I am trying to set up a linked server to Oracle using Oracle Provider for OLE DB. In EM this shows me the tables but I can't get any data from them in QA. Depending on the table I get

  Server: Msg 7320, Level 16, State 2, Line 1

  Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.

  or

  Server: Msg 7356, Level 16, State 1, Line 1

  OLE DB provider 'OraOLEDB.Oracle' supplied inconsistent metadata for a column. Metadata information was changed at execution time.

  Although I've had success with the MS Oracle driver I am having trouble with particular tables and want to be able to test with both drivers.

  Can anyone advise me why the Oracle driver might not work or have I just set it up incorrectly - and if so how does it see the tables in EM?

  Slowly going mad here...

• jordanac

  Hall of Fame

  Points: 3713

  More actions

  November 24, 2003 at 5:11 am

  #483310

  Hi,

  Have you had any luck yet? Sometimes changing the query to openquery helps.

  If it aint broke don't fix it!

  
  Andy.

• juliekenny

  SSCommitted

  Points: 1558

  More actions

  November 24, 2003 at 5:27 am

  #483313

  I did try openquery but the results were the same. Unless I have some major suggestions I think I have to give up.

• jordanac

  Hall of Fame

  Points: 3713

  More actions

  November 24, 2003 at 6:31 am

  #483328

  Hi,

  Can you describe the Oracle Table or send me the data types of the columns.

  If it aint broke don't fix it!

  
  Andy.

• John McKnight

  SSC Rookie

  Points: 28

  More actions

  January 24, 2004 at 9:17 am

  #491500

  Did you solve your problem?  Is so how?  I'm having almost the same.

  Thanks, John