View original (French)

SQL Server linked server and Sage Cbase ODBC

andrey -  
 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

  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.
    0
    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.
      0
    2. lelion33
       
      it would be better for you to drop the proprietary database and work with sql server sage databases.
      0
    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.
      0
    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.
      0
    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.
      0