编译环境: VC6.0++
S1：从 sql server 目录中将ntwdblib.lib、ntwdblib.dll、msvcr71.dll、sqlfront.h和sqldb.h五个文件复制出来到代码目录里。
S2：最简单的读取结构如下：
#define DBNTWIN32
#include <stdio.h>
#include <windows.h>
#include <sqlfront.h>
#include <sqldb.h>
#pragma comment (lib,"ntwdblib.lib")
int main(void)
{
PLOGINREC pLogin;
PDBPROCESS pSQL;
DBCHAR myName [100];
dbinit ();
pLogin = dblogin ();
DBSETLUSER (pLogin, "sa");
DBSETLPWD (pLogin, "123");
pSQL = dbopen (pLogin, "192.168.2.1");
dbuse(pSQL, "测试");
dbcmd(pSQL, "SELECT c_name FROM table_name;");
dbsqlexec (pSQL);
if (dbresults (pSQL) == SUCCEED){
dbbind (pSQL, 1, NTBSTRINGBIND, 0, myName);
while (dbnextrow (pSQL) != NO_MORE_ROWS){
printf ( "%s\n ", myName);
}
}
dbexit();
printf("程序运行结束!\n");
return 0;
}
最新评论