Seth Galitzer
sgsax at ksu.edu
Wed Mar 12 13:02:00 CST 2003
Mike, I wrote a VB app that connects to an Oracle BE. It operates completely disconnected, no bound controls or anything. I used ADO instead of DAO because everything I've seen says it's better suited for this kind of thing. This app is supposed to run constantly with very little user interaction. Here's what I've learned: 1) The Oracle ODBC drivers are a major pain to install. The installer is all java, and if you don't have a compatible JRE, you need to download install one first. They are also BIG. Takes a long time to install them, and they are fat and heavy. Performance seems OK though. 2) I frequently get errors (usually after about 72 hours of constant running) that basically say the app was unable to connect to the Oracle server. I have no idea if the problem is with the server or my app. When this happens, the app will not connect again until I stop the app and restart it. I don't know if this is a problem with the ODBC drivers, or ADO, or what. I create a new Connection object each time I want to dump data (every 15 minutes), and then throw it away when I'm done. So it may be a memory leak, but I have no real way of telling. If it is, I'm not sure who to blame, the ODBC driver or VB. I have no idea how this translates to Access, but I should think that it would behave similarly using unbound forms. Bound may be a whole different story. I've been tempted to move the whole BE to MySQL and see what the difference is in performance and stability. Hope you find any of this useful. Seth On Wed, 2003-03-12 at 11:49, Gowey Mike W wrote: > > I am about to embark on a project to right a front end that will connect > to a back End Oracle database. Has anyone had any experience in this > area or know of where I can find good information on techniques? Any > help anyone can provide would be great. > > Thanks > > Mike Gowey, MCP > Technical Support Analyst > SRCI ISSD Team Leader > > -- Seth Galitzer sgsax at ksu.edu Computing Specialist http://puma.agron.ksu.edu/~sgsax Dept. of Plant Pathology Kansas State University