(1) purchase a good VB6 book. Make sure it has sections on how to connect to a database, usually MSAccess, using ADO and, hopefully, ODBC. Forget DAO. It must have sections on how to read from and write to databases, using SQL.
(2) Purchase a good book on SQL.
(3) Ask your DBA to loan you a book on PL/SQL. Learn oracle stored procedures. Learn how to use Oracle's tools.
(4) Learn to create VB forms, use VB6 tools and Help.
(5) Learn to query a MSAccess database.
(6) Develop your application forms using VB6 and MSAccess. Most of the work you will need to accomplich can be done with VB6/MSAccess. Once you are comforable connecting, querying and displaying data in your VB forms, ask the DBA to give you access to an oracle workspace outside the live data, andpopulate it with the data you'll need.
(7) Once you have network access, modify the program's connection string, and SQL statements etc to match oracle structures.
If at all possible, use VB.Net or C# (c# might be better if you already know Java, C, or C++). .Net 2003 has a whole namespace devoted to oracle. You will have to migrate anyway as Microsoft stops supporting VB6, and .NEt is a whole new mindset.
Otherwise, get a good book (www.bookpool.com can save you money) and take a quick class if you can find one. VB6 isn't too hard to use, and there's a lot of help included with it.
After selecting the CursorType, CursorLocation, LockType and Disconnected status of your Recordset (there are defaults). I bind my controls and that is it All the complexities of ADO are hidden from the user which is you.
Then I can Navigate, Add New, Delete, Refresh, Search and Save Changes to my recordsets without any other code. That is really it, no other code is needed.
This works in any environment VB, Access, VC++ etc...
Let me know what you think.
Originally posted by sourendro
I would like to develop a software using VB 6.0 as the front end and oracel as the backend.I know very little of VB.What should i do to develop this software.Its very urgent...
If you are "new to VB" and "it is very urgent" and so forth, then:
Actum Ne Agas:Do Not Do A Thing Already Done.
No matter what it is you are trying to do, you are not the first person to have done it, and if you look out on the Internet a little while you're sure to find a tool that you can buy (rather than 'build') to do the job. It can be anything. For example, the Microsoft Access product is often used to quickly build forms and front-ends to use databases. Powerbuilder is another commercial example. And the Web is full of other people's efforts at places like http://sourceforge.net or http://www.hotscripts.com.
(Oops, looks like somebody's been hacked... ... if you click on the "sourceforge" link from in here, you might go to a porn site instead. (The link gets subtly changed to "sourgeforge.net" between here and there. Type the equivalent URL ("sourceforge.net") directly into your browser.)
The world's full of redundant effort; it doesn't need one more. Even if you, personally, don't have the authority to spend money in your organization, you can certainly make a compelling case to your boss that it should do so.