ODBC Driver and SAGE 100
SamC7
Posted messages
110
Status
Membre
-
hassan_maroc -
hassan_maroc -
Hello,
I am doing an internship and we have installed SAGE 100 Enterprise, with an SQL Server 2008 database.
We decided to install the ODBC kit provided by SAGE in order to read and write to our database: SELECT, DELETE, INSERT,...
The problem is that we are unable to write to our database at all... Reading is possible but writing is not.
I have read on various forums, AND in the SAGE documentation that only SELECT statements are recognized by the ODBC kit...
Is this true? Can't we write to our own database using ODBC?
Thank you in advance for your responses ^^
--
An RPG on Xena? World of Xena is here for you...
I am doing an internship and we have installed SAGE 100 Enterprise, with an SQL Server 2008 database.
We decided to install the ODBC kit provided by SAGE in order to read and write to our database: SELECT, DELETE, INSERT,...
The problem is that we are unable to write to our database at all... Reading is possible but writing is not.
I have read on various forums, AND in the SAGE documentation that only SELECT statements are recognized by the ODBC kit...
Is this true? Can't we write to our own database using ODBC?
Thank you in advance for your responses ^^
--
An RPG on Xena? World of Xena is here for you...
Configuration: Windows 7 - Firefox latest version