Hello,

Some users have been requesting for Oracle 9i version of IBuySpy. I have in fact created one and is available as an sample application (C#) <a href="http://www.maxvirtual.com/opensrc.aspx"> my site </a>.

The current version has the following additional features :

a) You can mix Oracle 9i & Sql Server modules ie. use Oracle 9i for only some of the modules and for others continue to use SqlServer. (Although Oracle 9i Stored Procedures available for all the standard IBuySpy modules).

b) Add modules that use MS-Access, MySql, Sybase, etc. The database used by each module is defined in the ModuleDefintion section of the Xml file. So you can mix multiple databases.

c) The code base is same for all the databases. You can switch between Oracle 9i, SqlServer, etc. by changing the DataSource entry in an XML file. You don't change a single line of code.

d) It transparently handles Oracle ref cursors, etc. ie. You call the Oracle 9i stored procedures the same way you call the Sql Server Stored Procedures. (Currently tested with OracleClient provider and OraOleDb provider).

---

H. G. Sajnani.

MCSD.net, MCDBA, MCSE.

Max Virtual, LLC

Computer Science Applications.