Hi everybody,
I have a little problem wich I think might become a big problem. Here it is:
We are building a multi-user application, where the databases resides at a central location like a Novell server. Some users are connected to the network with a network interface card or NIC (10 mb/s) while some others are connected using an ISDN link (and I think some are connected using modems too). The applications are executed on each workstation and the applications are using FoxPro 2.6 SQL-select commands the retreive the information from the databases located on the server. The problem I think we're gone have is that the users on ISDN will wait a very long time before the query is done since a lot of data will be retreived by the workstation in order to execute the SQL-select command. And we don't want this to happens. I've heard of ODBC and SQL server, I think SQL server would be the solution since most of the selection will be done on the server running sql server. Am I right? Is there is another way to look at this problem? Of course we can't demand the users to change their network. Can foxpro windows 2.6 can use a SQL server and how?
Thanks in advance
François Dagenais
Member of the Montreal FoxPro user group!
François Dagenais
LAGIBERT Informatique