Hi Girish, > -----Original Message----- > From: Girish Mohata [mailto:[EMAIL PROTECTED]] > Sent: Dienstag, 4. Februar 2003 04:44 > To: Sapdb > Subject: Advice on Visual Basic with SAP DB Project [snip]
> 1) This software will be a commercial product > being used by 8-10 accountants simultaneously over > a LAN. Are there any licencing issues that i need > to worry about in terms of paying fees for > installing the Database at my Clients computers > together with my VB application ? The application > will Not be open-source. Please see http://www.sapdb.org/7.4/sap_db_gnu.htm SAP DB's interface is LGPL, so you can combine it with closed source. > 2) My preffered choice of developement platform is > to use SAP DB as the backend and Visual Basic as > the front end. Connection through ODBC. However i > am open to other ideas like using Java with JDBC, > etc. Please advise me which option is best and > what are the trade-offs. There are many people using this combination VB/ODBC. The JDBC-driver is also applied in many projects. Advantage here is, that it is a pure Java implementation, that allows you to switch to other OS. In VB you stick on Windows. > > 3) In developing a data-driven software, my > attitude would be to run the business logic on the > server using triggers and procedures rather than > coding it in Visual Basic. In other words if i > wish to insert a record, i would do it by calling > a stored procedure and passing data values to it > from VB, rather than writing an SQL statement > through VB. Please advise on this. Any > comments/suggestions/experiences would be much > helpful. This is exactly what a German government department (Bundeskartellamt) did some time ago. They developed in VB/ODBC or ADO, respectivly, and SQL server. Due to having the business logic in the DB they could quite smoothly switch to SAP DB, where the client software wasn't changed at all, besides changing the connect string. Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin SAP DB is open source. Get it! www.sapdb.org _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
