Visual Basic&database, Anybody using Oracle Objects for OLE?

Anybody using Oracle Objects for OLE?

Author	Message
Jame #1 / 4	Anybody using Oracle Objects for OLE? My next project will involve some Oracle7 front-end development. The front-end wil be written in VB3 or VB4-16Bit and deployed on 60MHz Pentiums , 16 Mb Ram ,Win 3.1. on Novell using TCP/IP. As this is my first encounter with Oracle and Client/Server development,I would appreciate any advice. What do you think of Oracle Objects for OLE? Anybody using it for serious DB development? Is it solid? How's the performance? Should i rather go for ODBC with eg. attached ables?. Should I stay with VB3 or go VB4-16bit (VB4-32 and RDO is out because of the WIN3.1 deployment.) Any advice will be greatly appreciated. Thanks in advance. James Mitchell
Sat, 16 May 1998 03:00:00 GMT

Sylvain Faus #2 / 4	Anybody using Oracle Objects for OLE? James, Just in case you did not know, there is Oracle OCI/OCX also available if you prefer using directly the Oracle Call Interface API for full control and maximum speed. Details by calling SFI at 819 778-5045 ext:152. Sylvain SFI Tel: 819 778-5045 (also with faxback, press "1") Fax: 819 778-7943
Sun, 17 May 1998 03:00:00 GMT

A little left of plu #3 / 4	Anybody using Oracle Objects for OLE? writes: Quote: >My next project will involve some Oracle7 front-end development. The >front-end wil be written in VB3 or VB4-16Bit and deployed on 60MHz >Pentiums, 16 Mb Ram, Win 3.1 on Novell using TCP/IP. As this is my first >encounter with Oracle and Client/Server development,I would appreciate >any advice. >What do you think of Oracle Objects for OLE? Anybody using it for serious >DB development? Is it solid? How's the performance? Should i rather go >for ODBC with eg. attached ables?. Should I stay with VB3 or go VB4-16bit >(VB4-32 and RDO is out because of the WIN3.1 deployment.) My experience with OO4O and VB3 has been pretty good. I have found that the OO4O approach to be both better performing and more solid than ODBC. Just in case, I coded the app both ways keeping all data access code in one .bas module... That way if things go bad with OO4O I can easily change to ODBC. So far though OO4O has been very solid. My impression is that performance is significantly greater when the DB is on the network, but only a little better for a local PO7 database. HTH, david
Sun, 17 May 1998 03:00:00 GMT

Henry Norris SL #4 / 4	Anybody using Oracle Objects for OLE? Quote: >My next project will involve some Oracle7 front-end >development. The front-end wil be written in VB3 or >VB4-16Bit and deployed on 60MHz Pentiums , 16 Mb Ram ,Win 3.1. >on Novell using TCP/IP. As this is my first encounter with >Oracle and Client/Server development,I would appreciate any >advice. >What do you think of Oracle Objects for OLE? >Anybody using it for serious DB development? >Is it solid? >How's the performance? I have found OofOle to be easy to code for, nice and fast, with minimal problems concerning memory leaking. Oracle claims they will have a fix soon. You will want to follow standard rules concerning clearing dynasets, and use Execute Sql statements to do updates and inserts. I have used it to write a Fleet Management App for a Teleco. They have 9k employees and 4k vehicles. Their fuel/maintenance records are about 250k records. I haven't noticed any problems with speed. Of course, the queries are indexed accordingly. The database is running on SCO Unix. I would not plan on using POra7 for serious production. Personal Oracle 7 is used for development and test databases. Its also very good. Quite powerful, and easy to use. I give it 4.5 out of 5. Henry Norris
Fri, 22 May 1998 03:00:00 GMT

Page 1 of 1

[ 4 post ]