当前位置: 代码迷 >> VFP >> 请老师帮忙看看这个语句中提示“语法异常”
  详细解决方案

请老师帮忙看看这个语句中提示“语法异常”

热度:6283   发布时间:2013-02-26 00:00:00.0
请老师帮忙看看这个语句中提示“语法错误”
SET LIBRARY TO myfll
DRIVER=Sql Server;SERVER=DomainToIP("peakpineliu.gicp.net");UID=sa;PWD="";DATABASE=mydatabase;Network=DBMSSOCN;Address=DomainToIP("peakpineliu.gicp.net");1433
SET LIBRARY TO 


请老师帮忙看看这个语句中提示“语法错误”,对SQL不是很熟悉,请老师指点!谢谢!

------解决方案--------------------------------------------------------
set library to myfll
cc = [DRIVER=Sql Server;SERVER=] + DomainToIP("peakpineliu.gicp.net") + [,1433;UID=sa;PWD=;DATABASE=mydatabase]
hh = SQLStringConnect(cc)
...

vfp9 也可以:
...
cc = Textmerge([DRIVER=Sql Server;SERVER=<<DomainToIP("peakpineliu.gicp.net")>>,1433;UID=sa;PWD=;DATABASE=mydatabase])
...
  相关解决方案