Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unhappy Unanswered: NEW TO VB(urgent)

    HELLO,

    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...


    plz help me.

  2. #2
    Join Date
    Jul 2001
    Location
    NC
    Posts
    102
    (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.

  3. #3
    Join Date
    Feb 2004
    Location
    Philadelphia,PA
    Posts
    4

    Use VB.Net or c#

    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.

    Good luck,

  4. #4
    Join Date
    Jan 2004
    Posts
    184

    Re: NEW TO VB(urgent)

    Try this control featured on download.com that I have been using that has made my life easier:

    http://download.com.com/3000-2404-10...ml?tag=lst-0-1

    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
    HELLO,

    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...


    plz help me.

  5. #5
    Join Date
    Oct 2003
    Posts
    706

    Unhappy

    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.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  6. #6
    Join Date
    Feb 2004
    Posts
    7

    New and Urgent

    1) Hire it done or buy a commercial product.

    2) See #1.

    VB and Oracle are not the best combination for someone new to both.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •