If this is the case, then there is absolutely no difference between FoxWeb scripts and regular VFP programs -- at least as it relates to accessing data on MS SQL server. If code runs in VFP on the same server, while you are logged in as the same Windows user, then it will also run in a FoxWeb script.
Your original message mentions that your code works fine in VFP. Was this on the same server? Were you logged in as the same user? Can you please try this again?
Sent by Colin on 10/04/2005 11:45:36 PM:
I am running FoxWeb version 2.11.
I am not running FoxWeb as a service.
Sent by FoxWeb Support on 10/04/2005 11:04:08 AM:
Are you running FoxWeb as a service? If yes, then you need to make sure that the service logon user has rights to your SQL database (or you can use SQL authentication instead).
Sent by Colin on 10/04/2005 02:11:56 AM:
I have currently programs running on foxweb by accessing foxpro tables(dbf).
Is it possible to amend the programs to access MS SQL 2000 database?
If possible how should I do it?
I have tried using the following command but it does not work?
1) CONN1= Sqlstringconnect("DSN=SALES;DATABASE=CCS_NOV")
2) STORE Sqlconnect("SALES;CCS_NOV") TO CONN1
Both statements gave me a value less than 0, which means not successful.
In visual foxpro, these 2 statements did not give me any problem.