>how do i setup a computer connected to the internet through DSL as an SQL server for the software we developed using foxpro? what are the client computer requirements and what are the server computer requirements?
>
>Thanks in advance....your advice will really be of help to me....
This is the little .prg which I used to connect to a SQL server somewhere on the Net:
#Define C_ConnectString "Driver={SQL Server};Server=xx.xx.xx.xx;Description=ServerName;UID=dbUserName;PWD=password;Database=dbName;APP=MyAppName;WSID="
nHandle=Sqlstringconnect(C_ConnectString+GetWordNum(Sys(0),1," #"))
Return nHandle
I have replaced the real IP with xx.xx.xx.xx and the real names with descriptive names, of course.
Don't know whether you need any special setting on the server machine, it seems to need only to have SQL server running and it should be accessible by default.