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

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