linux怎么进去sql,用linux怎么进入SqlServer2005

#include

#include

#include

int main(void)

{

char szUsername[32] = "自己填写";

char szPassword[32] = "自己填写";

char szDBName[32] = "自己填写";

char szServer[32] = "自己填写";形式如10.10.11.12:1111

//初始化db-library

dbinit();

//连接数据库

LOGINREC *loginrec = dblogin();

DBSETLUSER(loginrec, szUsername);

DBSETLPWD(loginrec, szPassword);

DBPROCESS *dbprocess = dbopen(loginrec, szServer);

if(dbprocess == FAIL)

{

printf("ASB>> Conect MS SQL SERVER fail \n");

return 0;

}

printf("ASB>> ConnectEMS conect MS SQL SERVER success\n");

if(dbuse(dbprocess, szDBName) == FAIL)

{

printf("ASB>> Open database name fail\n");

}

else

{

printf("ASB>> Open database name success\n");

}

//查询数据库

/*dbcmd(dbprocess, "select ID,BeginTime,Description from Alarms");

if(dbsqlexec(dbprocess) == FAIL)

{

printf("ASB>> Query Alarms table error\n");

}

DBINT result_code;

char szID[1024];

char szBeginTime[1024];

char szDescription[1024];

int rows = 0;

while ((result_code = dbresults(dbprocess)) != NO_MORE_RESULTS){

if (result_code == SUCCEED){

dbbind(dbprocess, 1, CHARBIND, (DBINT)0, (BYTE*)szID);

dbbind(dbprocess, 2, CHARBIND, (DBCHAR)0, (BYTE*)szBeginTime);

dbbind(dbprocess, 3, CHARBIND, (DBCHAR)0, (BYTE*)szDescription);

while (dbnextrow(dbprocess) != NO_MORE_ROWS){

printf("ASB>> ID=%s\n", szID);

printf("ASB>> szAid=%s\n", szBeginTime);

printf("ASB>> szBeginTime=%s\n", szDescription);

}

}

}*/

//关闭数据库连接

dbclose(dbprocess);

return 0;

}

gcc -o testsybase testsybase.c -L/usr/local/freetds/lib -lsybdb

本例中采用的是动态库注意环境变量的添加。