数据库连接

/*testDB.h*/

#include <stdio.h>
#include <string.h>
#include <sybfront.h>
#include <sybdb.h>
#include <stdlib.h>

main()
{
 DBPROCESS *dbproc;      
 LOGINREC  *login;       
 RETCODE   result_code;
 char *userid="";
 char *userpwd="";
 

 dbinit();
 login = dblogin();
 DBSETLUSER(login, "telstar");//用户名与密码
 DBSETLPWD(login, "tel2000");
 dbproc = dbopen(login,"TELSTAR");
 if (dbproc==(DBPROCESS*)NULL)
 {
  printf("Cannot connect to server!/n");
  exit(FAIL);
 }
 printf("Connect success!/n");
 dbuse(dbproc,"staticdb");//数据库
 dbcmd(dbproc, "select * from test");
 dbsqlexec(dbproc);
 while ((result_code = dbresults(dbproc)) != NO_MORE_RESULTS)
 {
  if(result_code == SUCCEED)
  {
   dbbind(dbproc,1,NTBSTRINGBIND,(DBINT)10,(BYTE *)userid);//第一列
   dbbind(dbproc,2,NTBSTRINGBIND,(DBINT)10,(BYTE *)userpwd);//第二列
   while (dbnextrow(dbproc)!= NO_MORE_ROWS)
   {
    printf("%s:%s/n",userid,userpwd);
   }
  }
 
 }
} 

/*echo $SYBASE 查看SYBASE目录*/

/*cc testDB.c -I/usr/users/sybase12/OCS-12_0/include -L/usr/users/sybase12/OCS-12_0/lib -lsybdb */