Post reply

CANNOT SAVE VIEW

  • December 28, 2006 at 1:37 pm

    #62150

    Running sql server 2000 SP4

    SELECT     *

    FROM         OPENQUERY(LPUSA01, 'select * from bzrcrp')    it works on the view

    when I will save it I got this error:

    ODBC error: Microsoft ODBC SQL Server driver OLE DB provider MSDASQL reported an error

     

  • December 28, 2006 at 2:40 pm

    #680380

    I don't knowif this is related, but I've seen this happen if the session that creates the view doesn't have the correct setting for the ansi_nulls and ansi_warnings set before the view creation is executed.  So you might try:

    set ansi_nulls on

    go

    set ansi_warnings on

    go

    creeate view blah blah blah....

    go

     

    And then again, I might be wrong ...
    David Webb

Viewing 2 posts - 1 through 1 (of 1 total)

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