Post reply

Linked Server

  • June 3, 2004 at 1:45 pm

    #102048

    Hi,

    I set up a Linked Server on SQL Server to an Oracle server.  I created a System DSN, tested the connection and it was successful.  I could see the objects through SQL Server Enterprise Manager.  However, when I open Query Analyzer to do a SELECT statement, I got the following error message:

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

    OLE DB provider 'MSDASQL' returned an invalid column definition.

    OLE DB error trace [Non-interface error:  OLE/DB provider returned an invalid column definition.].

    Does anybody know what this means?

    Thanks.

    Albert


    Albert P. Wun
    Consultant - Data Management - DBC
    CGI Services to BCE
    Markham, Ontario, Canada

  • June 3, 2004 at 1:54 pm

    #508890

    Try using MSDAORA instead of MSDASQL.

    Also, what's the query you are trying to run?


    Shamless self promotion - read my blog http://sirsql.net

  • June 3, 2004 at 1:57 pm

    #508891

    This is the query I was trying to execute.  It works in my Test environment, but it gave me the error in the production environment.

    select top 1 *

    from OMCORACLE..SWAT.T_OMC_CALENDAR_CONVERSION


    Albert P. Wun
    Consultant - Data Management - DBC
    CGI Services to BCE
    Markham, Ontario, Canada

  • June 3, 2004 at 2:45 pm

    #508897

    Here's another problem, I'm only presented with a System DSN that I can use to link the SQL Server to the Oracle server.  So using MSDAORA is out of the question.  I have to use MSDASQL.

    Does anybody knows what the error message means ?  Thanks !


    Albert P. Wun
    Consultant - Data Management - DBC
    CGI Services to BCE
    Markham, Ontario, Canada

  • June 3, 2004 at 2:56 pm

    #508899

    I noticed your query string contained a .. in the

    attributions. Try filling in the catalog name bwteen the ..

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

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