View Complete Thread | FoxWeb Forum Home
Date:    Msg ID:   
From:    Thread:   
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).

FoxWeb Support Team email

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")
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.