/*************************************************************************

	PROGRAM:?SQLTESTR?-?SQL	Data?Server?sample?program?for?MS?DOS
		Copyright?（c）	1988-1995?by?Microsoft?Corp.

*************************************************************************/
#define	DBMSDOS		/*?must	identify?operating?system?envorinment?*/
#include?
#include?	/*?DB-LIB?header?file?（should?always?be	included）?*/

#define	????NULL????0

main?（）
{
	PDBPROCESS	??dbproc;??/*?allocate	a?DB-LIB?process?structure	????*/
	PLOGINREC	??login;???/*?allocate	a?DB-LIB?login?structure	????*/
	int		???errno;???/*?variable	to?store?DB-LIB	error?number?in	????*/
	char	??*msg;	????/*?used?to?receive?DB-LIB?error?message?pointer?*/

	/*?Variables?used?to?store?the?returning?data?*/
	char???????au_lname[41];
	char???????au_fname[20];
	char???????id[12];
	char???????phone[13];
	char???????address[41];
	char???????city[21];
	char???????state[3];
	char???????zip[6];
	char???????getname[41];
	char???????Servername[25];
	RETCODE????result_code;

	/*?Forward?declarations?of?the?error?handler?and?message?handler.?*/
????int?err_handler（PDBPROCESS?int?int?int?char*?char*）;
????int?msg_handler（PDBPROCESS?DBINT?int?int?char*）;

	if（dbinit（）?==?（char?*）NULL）
	{
		printf（“Communications?layer?not?loaded\n“）;
		exit（1）;
	}

	//?Install?the?user-supplied?error-handling	and?message-handling
	//?routines.?They?are?defined?at?the?bottom	of?this	source?file.
	dberrhandle（（DBERRHANDLE_PROC）err_handler）;
	dbmsghandle（（DBMSGHANDLE_PROC）msg_handler）;

	//?Get?server‘s?computer?name
	Servername[0]?=?NULL;
	printf?（“\nEnter?Name?of?SQL?Server:?“）;
	gets?（Servername）;

	login?=?dblogin（）;		????/*?get?login?record	from?DB-LIB?*/
	DBSETLUSER?（login?“sa“）;	????/*?set?the?username		????*/
	DBSETLAPP?（login?“example1“）;??/*?set?the?application?name	????*/
	DBSETLPWD?（login?““）;	????/*?set?the?SQL?Server?password??*/
	DBSETLVERSION（loginDBVER60）;
	/*?Now?attempt?to?create?and?initialize?a?DBPROCESS	structure?*/
	if?（（dbproc	=?dbopen?（login?Servername））?==?NULL）
	{
		printf?（“dbopen?failed\n“）;
		return?（1）;?/*?exit?program?*/
	}

	dbuse?（dbproc?“pubs“）;??/*	use?the	“pubs“?database	*/

	while?（TRUE）
	{
		printf?（“\nEnter?author‘s?last?name?to?retrieve?（return?to?exit）:?“）;
		gets?（getname）;

		/*?if?only?a?return?was	entered	*/
		if?（getname[0]?==?NULL）
			break;

		/*?construct?command?buffer?to?be?sent?to?the?SQL?server?*/
		dbcmd?（dbproc?“select?au_id?au_lname?au_fname?phone“）;
		dbcmd?（dbproc?“?address?city?state?zip“）;
		dbcmd?（dbproc?“?from?authors“）;
		dbfcmd?（dbproc	“?where?au_lname?=?‘%s‘“getname）;

		dbsqlexec?（dbproc）;??/*	send?command?buffer?to?SQL?server?*/

		/*?now?check?the?results?from?the?SQL?server?*/
		while?（（result_code?=?dbresults（dbproc））?!=?NO_MORE_RESULTS）
		{
			if?（result_code?==?SUCCEED）
			{
				dbbind?（dbproc	1?NTBSTRINGBIND?（DBINT）?0?id）;
				

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件??????14744??1996-04-03?01:00??SQLDBLIB\adme.lib

?????文件?????277504??1996-04-03?01:00??SQLDBLIB\bldblib.lib

?????文件?????235008??1996-04-03?01:00??SQLDBLIB\bmdblib.lib

?????文件??????19440??1996-04-03?01:00??SQLDBLIB\dacdll.lib

?????文件???????1898??1996-04-03?01:00??SQLDBLIB\dtccfg.lib

?????文件???????2770??1996-04-03?01:00??SQLDBLIB\dtccm.lib

?????文件???????9998??1996-04-03?01:00??SQLDBLIB\dtchelp.lib

?????文件???????2778??1996-04-03?01:00??SQLDBLIB\dtctrace.lib

?????文件???????2674??1996-04-03?01:00??SQLDBLIB\dtcuic.lib

?????文件???????4238??1996-04-03?01:00??SQLDBLIB\dtcuis.lib

?????文件???????2718??1996-04-03?01:00??SQLDBLIB\dtcutil.lib

?????文件???????3566??1996-04-03?01:00??SQLDBLIB\logmgr.lib

?????文件??????13312??1996-04-03?01:00??SQLDBLIB\msdblib3.lib

?????文件???????8912??1996-04-03?01:00??SQLDBLIB\msdtcprx.lib

?????文件???????3546??1996-04-03?01:00??SQLDBLIB\msdtctm.lib

?????文件??????86370??1996-04-03?01:00??SQLDBLIB\ntwdblib.lib

?????文件??????10642??1996-04-03?01:00??SQLDBLIB\odbcss.h

?????文件???????1068??1996-04-03?01:00??SQLDBLIB\odbcver.h

?????文件??????39500??1996-04-03?01:00??SQLDBLIB\opends60.lib

?????文件?????276425??1996-04-03?01:00??SQLDBLIB\rldblib.lib

?????文件?????242633??1996-04-03?01:00??SQLDBLIB\rmdblib.lib

?????文件???????5140??1996-04-03?01:00??SQLDBLIB\samprm.lib

?????文件??????13112??1996-04-03?01:00??SQLDBLIB\sqldb.h

?????文件??????24287??1996-04-03?01:00??SQLDBLIB\sqlfront.h

?????文件?????278757??1996-04-03?01:00??SQLDBLIB\sqlole.h

?????文件??????23492??1996-04-03?01:00??SQLDBLIB\sqloleid.h

?????文件???????1137??1996-04-03?01:00??SQLDBLIB\srv.h

?????文件???????7323??1996-04-03?01:00??SQLDBLIB\srvapi.h

?????文件???????6152??1996-04-03?01:00??SQLDBLIB\srvconst.h

?????文件???????2321??1996-04-03?01:00??SQLDBLIB\srvdbtyp.h

............此處省略25個(gè)文件信息