Post reply

Help with Linked Server via ODBC

  • September 28, 2006 at 3:17 pm

    #192594

     

    Hi All

    I have set up several linked SQL servers which work ok - but I'm having trouble setting up a linked server via ODBC (in either SQL 2000, or 2005). The ODBC points to an 'Alchemy' database and uses an Alchemy driver

    ironically i can set up linked tables in an Access DB, via ODBC - and I can pull the data into Excel via ODBC - so there is no problem connecting to Alchemy using other MS apps.

    When I add the linked server in SQL, it appears to be added but no tables are displayed (enterprise mgr) and OPENQUERY in SQL2005 management studio returns an error "Cannot initialize the data source object of OLE DB provider 'MSDASQL' "

    Its driving me crazy...Anyone have any ideas??

    Thanks in advance

  • October 2, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • November 5, 2007 at 7:23 pm

    #748475

    Can you solve that problem? If you have way to solve that problem please share me. Thanks.

  • November 5, 2007 at 8:07 pm

    #748478

    I was unable to find a solution to the problem and ended up doing a workaround by importing into access, then exporting to a text file and finally importing from the text file into SQL. Sorry i can't be of more help.

  • November 6, 2007 at 7:04 am

    #748636

    I found a reference that *may* help. It references making a connection to an Alchemy database with an ODBC Connect string.

    http://www.captaris.com/DeveloperProgram/forums/thread/12743.aspx

    Remember that you need to have the database title in the Alchemy.ini file on the machine where you run your application in order for the ODBC driver to work.

    Hope this helps.

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

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

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