C连接sysbase数据库

#include <stdio.h>
#include <string.h>
#include <sybtesql.h>
EXEC SQL INCLUDE sqlca;
int main(void)
{
    EXEC SQL BEGIN DECLARE SECTION;
    char szUserName[64];
    char szPassWord[64];
    char szConnection[64];
    char szServerName[64];
    char szDbName[64];
    EXEC SQL END DECLARE SECTION;
   
    memset(szUserName,'/0',sizeof(szUserName));
    memset(szPassWord,'/0',sizeof(szPassWord));
    memset(szConnection,'/0',sizeof(szConnection));
    memset(szServerName,'/0',sizeof(szServerName));
    memset(szDbName,'/0',sizeof(szDbName));
   
    strncpy(szUserName, "uid",sizeof("uid"));
    strncpy(szPassWord, "pwd",sizeof("pwd"));
    strncpy(szConnection,"current",sizeof("current"));
    strncpy(szServerName, "server_name",sizeof("server_name"));
    strncpy(szDbName, "dbname",sizeof("dbname"));

    EXEC SQL CONNECT :szUserName IDENTIFIED BY :szPassWord AT :szConnection using :szServerName;
       if (sqlca.sqlcode != 0)
      {
                printf("connect to sybase server failed:%s/n", sqlca.sqlerrm.sqlerrmc);
        return -1;
       
      }
    else
    {
        printf("connect OK!/n");
    }

   

    EXEC SQL USE :szDbName;  /*数据库名*/
    EXEC SQL SET CHAINED OFF;
    if(sqlca.sqlcode!= 0)
    {
        printf("open database error! ");
        return -1;
    }
   
    EXEC SQL DISCONNECT CURRENT; /*断开当前连接*/


}