View original (French)

SQL Server linked server and Sage Cbase ODBC

andrey -  
Hello,
I have SQL Server 2005 and I want to be able to query a proprietary database from Sage (Cbase). I have installed the ODBC and configured it in the ODBC data source.
I don't know what to do next, I tried to add a new linked server but it didn't work.
Thank you in advance for your help

Configuration: Windows XP / Opera 9.80

1 answer

  • Votes
  • Date
  • Descending date
  1. lelion33
    Hello,

    if you are on a proprietary database, you don't need SQL; you just need to connect to your ODBC in Excel with SQL queries or use Access with linked tables.

    I hope you can keep working.
    1. andrey
      Behn, I want to create a trigger in a table in my SQL Server database. This trigger will be responsible for copying data from my database to the Sage database.
    2. lelion33
      it would be better for you to drop the proprietary database and work with sql server sage databases.
    3. andrey
      Thank you for your answers, however I can't use Sage with SQL Server because the company I work for only has the Sage license with a proprietary database.
    4. lelion33
      In that case, I recommend a specific development that will read your SQL database and update your proprietary database, which you will run with a scheduled task.
    5. andrey
      What I want to do is when adding suppliers in my application developed with Visual Studio 2008, I want the added data to be duplicated in the Sage database.
      If I understood you correctly, I will be querying the Sage database from the application.