有谁知道纯dos 下如何连接sqlserver2000???（高分1000分求助！！）在线等待急急急急急

[zengpan]

谁有dos 下的16bit db-library for c库,sqlserver2000安装下没带
如下库：
car.lib
rldb.lib
sqlakd.lib

用sqlserver65的16bit db-library for c库无法连接！！

[pengdali]

osql和isql是SQL工具


楼主是要找什么库
car.lib
rldb.lib
sqlakd.lib

[recollectpainer]

晕死，咋一个个都被说成了是放P呢？？？？？？？？
有损各位大吓的形象呀
郁闷

[teaism]

SQL CD-ROM, in the \CLIENTS\MSDOS directory.
the file DBNMPIPE.EXE must be started as part of the AUTOEXEC.BAT file
具体看一下DBNMPIPE.EXE帮助或介绍。

说错了权且当放P，哈哈哈....
我没用过，只看过介绍。也忘了什么时候看的。只记得盘上有\MSDOS\什么的。然后搜索一下。

[teaism]

同时看一SKY_BLUE大侠的答案：

它在纯C语言下连SQL SERVER。
其实也是用MSDOS客户端工具DBNMPIPE.EXE连接SQLSERVER。

http://expert.csdn.net/expert/faq/faq_index.asp?id=11819

[teaism]

这下就全了，不是放P了!!

[happydreamer]

main()
{
exec sql include sqlca
exec sql begin declare section
char prname[20];
char productno[8];

exec sql end declare section

printf("Input producno:");
scanf("%s",&producno);

exec sql select prname
from product
where productno=:productno
into :prname;

printf("Productname: %s\n",prname);

exit();

}

[cdxuyi]

to happydreamer(黑DD)

你写的是ESQL/C,需要预编译，在windows下是nsqlprep.exe,在dos下是sqlprep.exe,下面是sqlserver2000的帮助：

MS-DOS
The 16-bit ESQL/C compiler and libraries are available for use with SQL Server 7.0 but are not supported. The compiler and libraries can be copied from the SQL Server compact disc. The system requirements for running ESQL/C under 16-bit Microsoft MS-DOS® are:

Microsoft MS-DOS version 6.22 or later
Microsoft Visual C++ development system (16-bit), version 1.52 or later

我正在寻找 esql/c的link库！！！！
用sqlserver65下的库无法打开sqlserver2000,错误为无法打开网络磁盘（原文为E文）
再次谢谢参与地朋友！！！请help

[leimin]

I have found a good article in MSDN:
Setting Up the nsqlprep Precompiler
Before you run the nsqlprep precompiler, do the following:

The nsqlprep precompiler uses your compiler to process header files

Set the INCLUDE environment variable to include the full path where the Sqlca.h and Sqlda.h ESQL/C header files are located and set the LIB environment variable to include the full path where the library files are located. There are several ways to accomplish this, including either:
Issuing a SET statement at the command prompt, such as
SET INCLUDE = C\Mssql17\DevTools\INCLUSE; %include%

SET LIB = C\Mssql17\DevTools\LIB; %LIB%

At the command prompt, first running Vcvar32.bat (in the \Program Files\Microsoft Visual Studio\VC98\Bin directory) and then running setenv.bat (in \Mssql17\DevTools\Samples\Esqlc directory).
The nsqlprep precompiler automatically includes these header files in the C programs it creates. Do not explicitly include them (by using #include) in an Embedded SQL program.

To enable communication with Microsoft® SQL Server™ 2000, ensure that an appropriate Net-Library is loaded or available on the path when precompiling with the /DB and /PASS options. For example, the Named Pipes Net-Library for the Microsoft Windows NT® operating system (Intel® platform) is Dbnmpntw.dll, and the Named Pipes Net-Library for the Microsoft MS-DOS® operating system is the Dbnmpipe.exe TSR.

[leimin]

大家要原谅无知人的无知和粗俗！

[pengdali]

[mjhnet]

有些人真该踢出去

[black_snail]

erp2(天涯劍) :

我查了以下你的贴子,发现你确实是一个无赖,几乎每篇贴子都在骂人.
强烈要求清除这类垃圾,封他帐号.(次人常去DELPHI放P)

[zxm954712]

对于象erp2(天涯劍)这种人,不懂装懂,而且还说脏话,强烈要求把他踢出去

[happydreamer]

大家来csdn是学习的，有不同的见解可以互相讨论，针对问题不要针对人，用这种方式就不太好了

[enhydraboy]

to erp2(天涯劍) ( ) :

你也真够粗俗的，搂主的问题的真正意思，你到底明不明白?
你不要这么弱智想问题,就一个isql就叫"有谁知道纯dos 下如何连接sqlserver2000",连接都连不上，还怎么用isql这种客户端。回去好好看看书去吧

[blueshrimp]

有些SQLSERVER的书上讲了C，VB，DELPHI，JAVA等联接

用DOS下的C语言当然也可以联，但需要引用某个库




和平万岁，就算说错了话，大家大肚一点嘛

[erp2]

网址http://msdn.microsoft.com/library/default.asp?url=/library/en-us/esqlforc/ec_6_eex_00_98dv.asp
上有详细说明.

[erp2]

另外根据我自己解读:
E:\System_tools\Sql Server2000Eng\Developer Edition\devtools\include\SQLDMO.h
有一点小的个人建议:
1.既然你用C语言,那么从端口或并口读取发送数据应该不困难.
2.可以在数据库服务端做一个服务器专门用于接收dos传送过来的数据,然后传送给sql server
3.同时在客户端接收你自己在数据库服务端做的服务器返回的结果.
这样做可能对速度有一定程度的影响,但程序书写相对容易.
另外一个建议:
为什么要使用纯dos?我想你可能不仅仅想在纯dos环境中连接sql server.可能在其它操作系统上吧?

[cdxuyi]

说了半天，要找的库还是没下文。。。。郁闷！！！

[caiyunxia]

ISQL