Announcement

Collapse
No announcement yet.

MS Access 97

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • David L Morris
    replied
    James and Charles,

    You might look at JACOMPB20 :-
    They have several ADO examples:
    '
    ' SQL programming using the ADO-OLE/DB object model.
    ' Methods with VARIANT parameters.
    '
    ' JAZZAge Software SARL (c) 1999-2000
    ' www.jazzagesoft.com
    '
    David

    ------------------

    Leave a comment:


  • Eric Pearson
    replied
    > can I make a DSN-less connection?

    Absolutely! ODBC (and SQL Tools) allow you to establish a connection to a database using a DSN file, a connection string, a series of "navigation" dialogs, or a combination of those techniques. Once a connection has been established the first time, you can retrieve the connection string and save it in any form you choose.

    > if my user upsizes to SQL server we jsut move the
    > tables and change the connection string.

    It's that easy with ODBC too! In fact, using ODBC makes it possible to move from database platform to platform with no recoding at all. That's the whole idea!

    -- Eric

    ------------------
    Perfect Sync Development Tools
    Perfect Sync Web Site
    Contact Us: mailto:[email protected][email protected]</A>

    [This message has been edited by Eric Pearson (edited May 21, 2001).]

    Leave a comment:


  • Charles K. Kincaid
    Guest replied
    Yes, but can I make a DSN-less connection? I am an avid ADO writer.
    I set up my program in VB 6 using ADO and allow the use of complete
    user specified connection strings. Of course I have written a connection
    string builder. Once the "Test Connection" button succeeds, the
    string is copied to the clipboard.

    In this way if my user upsizes to SQL server we jsut move the
    tables and change the connection string.
    Voila! Instant SQL server applications.



    ------------------
    ATB

    Charles Kincaid

    Leave a comment:


  • james klutho
    replied
    Thank you all for your responses. It looks like ODBC is the way
    to go.

    ------------------

    Leave a comment:


  • Lance Edmonds
    replied
    Have you looked at SQLTools? This allows you to work with any ODBC database, and it was written with PowerBASIC in mind.

    For more information, take a look at http://www.powerbasic.com/products/sqltools/

    I hope this helps!

    ------------------
    Lance
    PowerBASIC Support
    mailto:[email protected][email protected]</A>

    Leave a comment:


  • Edwin Knoppert
    replied
    Jet is, i believe, calling the same ODBC dll's indirectly.
    (I ever checked this out what i needed)
    At the end you must install the same overhead as using ODBC.
    I don't think you can get a grip on the JET DLL's, no exported functions for proper use.



    ------------------

    Leave a comment:


  • Michael Mattias
    replied
    The answer is, yes, you can query and update existing MS-Access (r) databased with PowerBASIC.

    Now, as to what DLLs the Jet engine uses, I don't have a clue; among others, I am using ODBC to do it. The include files for ODBC are in the file section here.

    I believe the SQL Tools product was designed to make ODBC access easier than using the 'native' ODBC API; but I better let someone who knows those tools better explain it.

    MCM

    Leave a comment:


  • james klutho
    started a topic MS Access 97

    MS Access 97

    Is it possible to use the DLLs used in the Jet Engine 3.5 to
    modify existing MS Access databases through Power Basic? If so,
    does anyone have the API files and source code examples to show
    me how. I can do this in Visual Basic but I would rather write
    all my code in Power Basic.

    ------------------
Working...
X