出现下面的错误
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
服务器: 消息 11,级别 16,状态 1,行 0
General network error. Check your network documentation.连接中断
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
服务器: 消息 11,级别 16,状态 1,行 0
General network error. Check your network documentation.连接中断
(select top 1 jc from gpgk where code=fx_gk.code),bbrq,
(select sjl/10000 from fx_sj where code=fx_gk.code and y=1 and bbrq=fx_gk.bbrq),
(select jg from fx_sj where code=fx_gk.code and y=1 and bbrq=fx_gk.bbrq),
ssr,
'111111111111111111111111111111111111111111111111111111111111
11111111111111111111111111111111111111111111111111111111',
(select top 1 sjmj/10000 from fx_sj where code=fx_gk.code and y=1
order by bbrq desc),(select top 1 zgb from gbjg where code=fx_gk.code order by bbrq desc)/10000,
(select top 1 gs from gzgb where xz='3110' and y='1' and code=fx_gk.code order by bbrq desc )/10000 as a股,
(select mc from zzjg where dm= fx_gk.zx)
from fx_gk where lb='2' and y='1
具体是这样:在本地服务器sql 语句再长都能运行,但是再远程服务器上同样语句就不能运行,出现下面的错误
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
服务器: 消息 11,级别 16,状态 1,行 0
General network error. Check your network documentation.连接中断
身份验证模式为:"sql server和windows"
Provider=SQLOLEDB.1;Persist Security Info=True;User ID=用户名;Password=密码;Initial Catalog=数据库名;Data Source=SQL服务器名身份验证模式为:"仅windows"
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名;Data Source=SQL服务器名