Linked Server

• Susan S

  SSCommitted

  Points: 1771

  More actions

  May 4, 2006 at 7:32 pm

  #168030

  I am using linked server to  make a query. ( eg. SELECT * FROM OPENQUERY(dump, 'SELECT Name,Surname,City FROM Person')

  It goes fine however when I select the file which has 2 word

  (eg. SELECT * FROM OPENQUERY(dump, 'SELECT Name,Surname,[Post Code} FROM Person')

   

   

  The error message below appears

   “Server: Msg 7399, Level 16, State 1, Line 12

  OLE DB provider 'MSDASQL' reported an error. 

  [OLE/DB provider returned message: [Dump][ODBC Driver]Column not found: [Post]

  OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare:repare returned 0x80004005:

   

  It seems the query can’t accept 2 words.

  What should I do? Do you think it is an error during my linked server setup?

   

  Please help me  

   

  Susan

   

• Marshall Smith

  SSCrazy

  Points: 2041

  More actions

  May 5, 2006 at 7:22 am

  #636212

  Er, just out of curiosity, does your original SQL have the curly bracket } at the end? Because, it should have square brackets on both sides.

• Susan S

  SSCommitted

  Points: 1771

  More actions

  May 7, 2006 at 4:25 pm

  #636437

  No,

   just wrong typo in this question but in the actual I used [].

  some advises me to use DBCC TRACEON(8765) and DBCC TRACEOFF(8765)  then instead of [] I need to use " "

  It works OK.

  But I don't know why I should use this?

  Ta,

  Susan