Post reply

Linked Server Problem

  • December 5, 2006 at 6:45 am

    #170637

    I have a linked server called Columbus.  If I run a select statement in QA, it works fine (if a little slow).  However, if I try to save the select statement as a View, something strange happens, and it will not save and just hangs.

    The select statement is simply:

    select Lastname,FirstName, Position,TelNo,Mobile,ID

    from COLUMBUS.MyDatabase.dbo.ContactNames

    the above is fine in QA, but changes when saving as a View.  It becomes:

    select Lastname,FirstName, Position,TelNo,Mobile,ID

    from COLUMBUS.MyDatabase.dbo.ContactNames ContactNames_1

    Why does it add ContactNames_1 to the end?  It does it with every linked server table I try.

    If anybody can help here, I'd be very grateful.

    Thanks

    Paul

     

  • December 5, 2006 at 7:08 am

    #675828

    I can't tell you why but I know it does it.  Never had any problems other than I don't like the _1 at the end of the name, so I always rename those.

  • December 5, 2006 at 7:17 am

    #675835

    Hi

    But mine just hangs in create View (but works in QA).  I can't rename or save...

    Any ideas?

    Many thanks

    Paul

  • December 5, 2006 at 7:36 am

    #675847

    Never had that problem... Have you tried to MS certified way of resolving this?

     

    Close and restart?

     

    Are you sure you have the same set options in both connections?

  • December 6, 2006 at 4:50 am

    #676172

    Hi

    MS certified (usually a trusted method) doesn't do it.

    Which set options do you mean?  Could you please point out which and where?

    Many thanks again.

    Paul.

  • December 6, 2006 at 5:59 am

    #676180

    Just an addition.

    I have set myself as dbo for the database on the linked server.  Both the main server and the linked server are set for both Windows and SQL security.

    I created a combo box with a select statement from the linked server as rowsource.  It returns the error message:

    'login failed for user '(null)'. Reason:  Not associated with a trusted SQL Server connection'

    What do I need to change to rectify this?

    Thanks

    Paul

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply