Results 1 to 2 of 2

Thread: ODBC tutorial

  1. #1
    Join Date
    Aug 2005
    Posts
    10

    Unanswered: ODBC tutorial

    Hi All,

    Is there any tutorial / sample code is available to learn SQL and ODBC API of pervasive V8.x or V9 versions.

    Dynamically create Database , DSN
    create DDFs
    set connection to server or to workgroup computer.
    create tables, modify tables, drop tables
    create indexes, foreign keys.
    Drop index


    I develop packages using C++
    (Compiler dev-c++ or Borland commandline 5-5 free compiler.)
    I do not have expertise in MFC or c++Builder.
    I have working knowledge of btrieve 6.x API., and, I want to rewrite my existing packages for client-server architecture under Windows 2003 OS (GUI +SQL)
    Pl help...

    THANKS in advance
    -C.D.Tamhankar (India)

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    ODBC API is a Microsoft Standard. There are a number of tutorials on the web showing how to do ODBC API calls. The syntax of the SQL statements might be a little difference.
    For the rest of the operations:
    Dynamically create Database , DSN -- Look at DTI PvCreateDatabase, PvCreateDSN, and SqlConfigDatasource
    create DDFs --PvCreateDatabase can do this.
    set connection to server or to workgroup computer. --This is done in the ODBC DSN (from a SQL perspective) based on the type of DSN (Engine or Client) used.
    create tables, modify tables, drop tables -- Look at CREATE TABLE, ALTER TABLE, and DROP TABLE in the SQL Language Reference in the docs.
    create indexes, foreign keys. -- Look in the SQL Language Reference.
    Drop index -- Look in the SQL Language Reference.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

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