Post reply

Weird error when selecting from view.

  • April 14, 2011 at 10:46 am

    #1311731

    HowardW (4/14/2011)

    Ah, sorry, I misunderstood. So EOracle is a SQL Server DB and clm_edit_wq_clm is a view on it that uses a linked server to Oracle?

    Yeah, that driver is a little old - I seem to remeber that one had a load of bugs converting numeric data to SQL Server types. Having said that, each Oracle driver has it's own unique set of bugs to treasure, so while it works for what you're doing it's probably not worth the effort in upgrading 🙂

    Yes, EOracle is a SQL Server DB and clm_edit_wq_clm is a view linked to the remote EOracle Oracle server.. (Don't ask.)

    We have occasionally hit the problem with converting numeric data, but at the time we couldn't find a newer driver or any notes on the Oracle site about it. The Oracle DBAs are pushing people to upgrade to the 11g client, so we will have to at some point...

  • May 8, 2014 at 4:19 am

    #1711792

    I am running a select query on a 2008 sql server that works fine.

    We are currently upgrading to sql server 2012 and when i run the same query from the 2012 MS SQL Server Management Studio i get the

    " reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 16 at run time." error. Even though the connected sql server on the 2012 server is the 2008 sql server. All servers have compatibility level 100, even the DB2 server i select from through openquery

    What can i do about that?

  • May 8, 2014 at 4:49 am

    #1711799

    I suggest that you start a new thread. Very few people monitor old threads.

    -- Gianluca Sartori

  • May 8, 2014 at 5:08 am

    #1711801

    ok thx 🙂

Viewing 4 posts - 16 through 18 (of 18 total)

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