View Complete Thread | FoxWeb Forum Home
Search:
Date:    Msg ID:   
From:    Thread:   
Subject:   
I am running FoxWeb version 2.11.
 
I am not running FoxWeb as a service.
 
Regards
Colin
 
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).

FoxWeb Support Team
support@foxweb.com 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")
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.