Click here to Skip to main content
Click here to Skip to main content

C++ wrapper for Sybase's OPENCLIENT Interface

, 27 Sep 2002
Rate this:
Please Sign up or sign in to vote.
This article will provide a cross platform C++ wrapper for Sybase's OPENCLIENT interface.

Introduction

With this C++ wrapper, you can easily do the following:

  • Connect/disconnect to a Sybase server;
  • Execute SQL select/insert/update/delete commands;
  • Store the query result in a simple linked list;

This project is a cross platform implementation.

class  ObList ;
class  Record ;
class  RecordSet;
int Connect();
int Connect(char *user, char *pass, char *service);
void DisConnect();
int ExecCommand(char* cmdbuf);

Examples:

#include <stdio.h>
#include "dbclient.h"

int main(int argc, char* argv[])
{
    Connect("sybase11","sa","");
    RecordSet set;
    set.Open("select * from EMP");
    for(int k=0;k<set.GetRecordsCount();k++)
    {
        Record *pRec=set.GetRecord(k);
        for(int l=0;l<pRec->GetFieldsCount();l++)
        {
            printf("%s",pRec->GetFieldValue(l));
            if(l==(pRec->GetFieldsCount()-1))
                printf("\n");
            else
                printf("\t");
        }
    }

    DisConnect();
    return 0;
}

If you are interested in this article, and want to get details, contact me at lihaijian@sina.com or ema13@dongfang-china.com.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

lihaijian
Web Developer
United States United States
6 years Programer With VC++

Comments and Discussions

 
Questionerror message ????? Pinmemberseoktaegoon22-Jul-10 1:30 
Questioni have problem this part? Pinmemberseoktaegoon22-Jul-10 0:11 
when debugging..
 
...
Connect("dba","sql","");
 
-->
ex_init(CS_CONTEXT     **context)      :exutils.cpp
{
...
retcode = cs_ctx_alloc(CS_VERSION_110, context);   <-- do not allocation
if (retcode != CS_SUCCEED)
{
          ex_error("ex_init: cs_ctx_alloc() failed");
          return retcode;
}
 
}
command window error message:
Cannot access file c:\sql10\ini\objectid.dat
Generalwhen compile missing lots of .h file Pinmemberbill chuang2-Sep-04 22:04 
GeneralRe: when compile missing lots of .h file PinmemberRohit Joshi22-Sep-04 9:23 
GeneralRe: when compile missing lots of .h file Pinmemberanuradhatp12-Jun-07 7:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.141030.1 | Last Updated 28 Sep 2002
Article Copyright 2002 by lihaijian
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid