Post reply

SQL server 2k5 --> linking <-- Advantage Database using OLEdb

  • April 9, 2009 at 10:13 am

    #130552

    The name of the linked server (alias) is XYZ and in the path of the VFP flat files contains the brgemp table (.dbf).

    The connection status : GO

    /*------------------------

    select * from xyz...brgemp

    ------------------------*/

    Msg 7351, Level 16, State 2, Line 1

    The OLE DB provider "Advantage OLE DB Provider" for linked server "xyz" could not map ordinals for one or more columns of object "DBSCHEMA_TABLES".

    Does anyone have any ideas???

    Cheers,
    John Esraelo

  • April 9, 2009 at 12:27 pm

    #975341

    Maybe it's a problem with your custom OLEDB provider "Advantage OLE DB Provider".

    Did you try the Microsoft provider:

    EXECUTE sp_addlinkedserver 'dbf', '', 'MSDASQL', 'dBase Files', Null, Null, 'C:\dbf Folder'

    Source: http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/b67db83d-4074-4ca9-839b-a1724382b215/

    Hope this helps.

    Flo

  • April 9, 2009 at 2:45 pm

    #975437

    Very good point Flo. You see VFP (visual foxpro) is very susceptible to index and other table related damage when other sources link and tap into the database tables in that folder other the main application that was written for that set or the collection of VFP tables.... Ufff long sentence 🙂

    Anyhoo, we were told that this Advantage OLEDB is optimized and it is smart and will not damage the VFP tables if some application uses a pass-through sql to get the vfp data, make sense?

    But, at this point I have nothing to loose and I will try your suggestion too Flo..

    you are awesome and will definitely let you know of the results.

    thx

    Cheers,
    John Esraelo

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

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