Personalization, Customization and Productivity Tools

[wingh60]

Hello all:

I am currently developing a VB.Net app that works with a MAS90 server via ODBC connection.  I was able to execute queries  so far and the result set is returned as expected. 

Now, I would like to know if I can put together UPDATE statements to change entries in MAS90 via ODBC?  I have experience developing with other Relational DBs, but am new to developing with MAS90.  Sorry if this is such a newbie question.

Cheers.

[DFeller]

No MAS 90 cannot be updated via ODBC.

Dawn

[BigLouie]

The SOTAMAS90 ODBC DSN is Read Only.  While ProvideX has a read-write ODBC driver it is NOT designed to work with MAS and will result in data corruption 100% of the time. To write back to MAS you should use the Business Object Interface. This allows the use of VB scripting with MAS. Sage offers a course in it and if you are new to MAS I would strongly suggest taking the course as it will prevent a lot of trail and error.