Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002

    Arrow Unanswered: Sybase and VB Application



    I have a such question regarding DBs(Data Bases).

    I write some VB application that suppose to do some transaction against DB.

    For example,
    <select ... from ... where ...>,
    <insert ... values ... into ...>,
    <update ... set ... where ...> etc.

    The problem is I'd like that my application could be independent from DB.
    So, I'd like to run it on MsAccess, Sybase, Oracle etc.

    Which technology You'd recommend me: ODBC or DAO?
    How it looks on a practice to implement such DB independence?
    If I need some "DB Profile" window like in Power Builder, for example?

    Where it possible to find some detailed info.
    I mean, such code examples that work
    both against Sybase and MS Access either.

    A lot of thanks in advance.

    John Smith

  2. #2
    Join Date
    Nov 2002
    If you want to hard-code your SQL Statment in the VB code, you must only use the less common ANSI norm, supported by all these databases (probably ANSI SQL89)

    The best way is to use a middle tiers : your VBA only will look after the GUI.

    By Sybase, check Sybase Application Server (old name : Jaguar CTS)

Posting Permissions

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