Thread: SQLAPI++ library

  1. #1
    Registered User
    Join Date
    Apr 2008
    Posts
    610

    SQLAPI++ library

    I noticed these libraries are not free, can anyone point me to a free C++ Oracle Libraries?

  2. #2
    Kernel hacker
    Join Date
    Jul 2007
    Location
    Farncombe, Surrey, England
    Posts
    15,677
    It seems like SQLAPI++ should be able to do that.
    http://www.sqlapi.com/

    --
    Mats
    Compilers can produce warnings - make the compiler programmers happy: Use them!
    Please don't PM me for help - and no, I don't do help over instant messengers.

  3. #3
    Registered User hk_mp5kpdw's Avatar
    Join Date
    Jan 2002
    Location
    Northern Virginia/Washington DC Metropolitan Area
    Posts
    3,817
    Oracle's got there own OCCI libraries for MS Visual C++ 8/9 (2005/2008) or for g++ compiler's:

    http://www.oracle.com/technology/tec...cci/index.html

    Far as I know they are free to download and use to your heart's content.

    [edit]Those are for Oracle 10/11g databases.[/edit]
    Last edited by hk_mp5kpdw; 02-03-2009 at 08:31 AM.
    "Owners of dogs will have noticed that, if you provide them with food and water and shelter and affection, they will think you are god. Whereas owners of cats are compelled to realize that, if you provide them with food and water and shelter and affection, they draw the conclusion that they are gods."
    -Christopher Hitchens

  4. #4
    Registered User
    Join Date
    Apr 2008
    Posts
    610
    Quote Originally Posted by matsp View Post
    It seems like SQLAPI++ should be able to do that.
    http://www.sqlapi.com/

    --
    Mats
    lol mats, i just said i need a free API ... I know about the link you provided but not free to use ...

  5. #5
    Registered User
    Join Date
    Apr 2008
    Posts
    610
    Quote Originally Posted by hk_mp5kpdw View Post
    Oracle's got there own OCCI libraries for MS Visual C++ 8/9 (2005/2008) or for g++ compiler's:

    http://www.oracle.com/technology/tec...cci/index.html

    Far as I know they are free to download and use to your heart's content.

    [edit]Those are for Oracle 10/11g databases.[/edit]
    thanx ... I've got 10g installed

  6. #6
    Registered User
    Join Date
    Apr 2007
    Posts
    137
    Just use standard Win32 api methods (Odbc and others)

  7. #7
    Registered User
    Join Date
    Apr 2008
    Posts
    610
    Quote Originally Posted by Alex31 View Post
    Just use standard Win32 api methods (Odbc and others)
    references, links, examples?

  8. #8
    Crazy Fool Perspective's Avatar
    Join Date
    Jan 2003
    Location
    Canada
    Posts
    2,640
    ODBC is not part of the win32 api.

    You can find drivers and examples of using ODBC online, it's one of the more popular ways to connect to an RDBMS.

  9. #9
    Registered User
    Join Date
    Apr 2008
    Posts
    610
    Quote Originally Posted by hk_mp5kpdw View Post
    Oracle's got there own OCCI libraries for MS Visual C++ 8/9 (2005/2008) or for g++ compiler's:

    http://www.oracle.com/technology/tec...cci/index.html

    Far as I know they are free to download and use to your heart's content.

    [edit]Those are for Oracle 10/11g databases.[/edit]
    used the example on this forum which you find all over then NET.. So irritating that you can't find the required header file

  10. #10
    Registered User hk_mp5kpdw's Avatar
    Join Date
    Jan 2002
    Location
    Northern Virginia/Washington DC Metropolitan Area
    Posts
    3,817
    Never heard of a dbmanager.h header, but my relevant headers for the OCCI stuff were installed (I believe) when I installed the Oracle database itself. On my machine they were located in the C:\oracle\product\10.2.0\client_1\oci\include directory. If you want, I could email you a file with the headers. I would have thought that downloading the libraries would come with the necessary headers.

    [edit]Actually it was an Oracle client I installed on the machine in question and not the Oracle database.[/edit]
    Last edited by hk_mp5kpdw; 03-18-2009 at 04:33 PM.
    "Owners of dogs will have noticed that, if you provide them with food and water and shelter and affection, they will think you are god. Whereas owners of cats are compelled to realize that, if you provide them with food and water and shelter and affection, they draw the conclusion that they are gods."
    -Christopher Hitchens

  11. #11
    C++まいる!Cをこわせ!
    Join Date
    Oct 2007
    Location
    Inside my computer
    Posts
    24,654
    ODCB is all C, though. Not recommended if you are looking for a C++ solution to a problem.
    Actually, I would avoid it. But perhaps that's just me.
    Quote Originally Posted by Adak View Post
    io.h certainly IS included in some modern compilers. It is no longer part of the standard for C, but it is nevertheless, included in the very latest Pelles C versions.
    Quote Originally Posted by Salem View Post
    You mean it's included as a crutch to help ancient programmers limp along without them having to relearn too much.

    Outside of your DOS world, your header file is meaningless.

  12. #12
    Cat without Hat CornedBee's Avatar
    Join Date
    Apr 2003
    Posts
    8,895
    This library also has an Oracle backend:
    http://soci.sourceforge.net/
    All the buzzt!
    CornedBee

    "There is not now, nor has there ever been, nor will there ever be, any programming language in which it is the least bit difficult to write bad code."
    - Flon's Law

  13. #13
    Registered User
    Join Date
    Apr 2008
    Posts
    610
    Quote Originally Posted by Elysia View Post
    ODCB is all C, though. Not recommended if you are looking for a C++ solution to a problem.
    Actually, I would avoid it. But perhaps that's just me.
    Any recommendations? ... Why's it so difficult to find a straight forward solution with no missing header etc! C++ think am gonna go back to Java, kidding ... but really

  14. #14
    Registered User
    Join Date
    Apr 2008
    Posts
    610
    Quote Originally Posted by CornedBee View Post
    This library also has an Oracle backend:
    http://soci.sourceforge.net/
    Cornedbee, trying to understand (link)configuring soci_lib.sln on VS2005 ... But confused ...

    * FIREBIRD_INCLUDE_DIR - path to FireBird client library headers
    * FIREBIRD_LIB_DIR - path to FireBird client library

    * FIREBIRD_LIB - FireBird library, can be left unchanged
    * MYSQL_INCLUDE_DIR - NOT USED
    * MYSQL_LIB_DIR - NOT USED
    * MYSQL_LIB - NOT USED
    * ODBC_INCLUDE_DIR - ODBC include path, can be left unchanged
    * ODBC_LIB_DIR - ODBC libraries path, can be left unchanged
    * ODBC_LIB - ODBC library file, can be left unchanged
    * ORACLE_INCLUDE_DIR - path to OCI headers
    * ORACLE_LIB_DIR - path to OCI libraries
    * ORACLE_LIB - list of OCI libraries
    * POSTGRESQL_INCLUDE_DIR - path to libpq headers
    * POSTGRESQL_LIB_DIR - path to libpq library
    * POSTGRESQL_LIB - libpq library, can be left unchanged
    * SQLITE3_INCLUDE_DIR - path to SQLite 3 headers
    * SQLITE3_LIB_DIR - path to SQLite 3 library
    * SQLITE3_LIB - SQLite 3 library, can be left unchanged
    In my case, all these point to "C:\Program Files\Firebird\Firebird_2_0\include" which am not even sure when/how was firebird installed ... Should i change this to the soci....\lib folder?

  15. #15
    Cat without Hat CornedBee's Avatar
    Join Date
    Apr 2003
    Posts
    8,895
    Unless you plan to use the Firebird database, I think you can ignore them.
    All the buzzt!
    CornedBee

    "There is not now, nor has there ever been, nor will there ever be, any programming language in which it is the least bit difficult to write bad code."
    - Flon's Law

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. What's an import library?
    By chiefmonkey in forum C++ Programming
    Replies: 1
    Last Post: 06-19-2009, 05:00 PM
  2. Property Set Library (PSL) - Announcement
    By vultur_gryphus in forum Projects and Job Recruitment
    Replies: 0
    Last Post: 05-29-2008, 06:04 AM
  3. Makefile for a library
    By sirmoreno in forum Linux Programming
    Replies: 5
    Last Post: 06-04-2006, 04:52 AM
  4. very weird .h problem
    By royuco77 in forum C++ Programming
    Replies: 1
    Last Post: 09-11-2005, 07:55 AM
  5. better c string functions
    By samps005 in forum C Programming
    Replies: 8
    Last Post: 11-04-2003, 01:28 PM