Date:  10/04/2005 02:11:56 AM Msg ID:  002710
From:  Colin Thread:  002710
Subject:  foxweb and MS SQL 2000
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.