请老师帮忙看看这个语句中提示“语法错误”
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])
...