Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: Leonard Trevor
  Where is Leonard Trevor?
 Edinburgh
 United Kingdom
 Leonard Trevor
 Tags
Subject: RE: simple program connecting vfp to sql using spt
Thread ID: 104206 Message ID: 104436 # Views: 2 # Ratings: 1
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, August 16, 2006 2:28:43 PM         
   


> The application relies on ODBC. its working alright.
>
> All I need now is the script that invokes the database on the server from the worksation using the shortcut.
>
> any help"
>


I think that you may be a little confused here. The SQL database resides on the server. The .EXE that connects (using your ODBC connection) resides where you want it to go. If you store this .EXE on the client, you will reduce network traffic assoicated with downloading the .EXE to the client machine. If you store the .EXE on the client's C drive, you can reduce the network traffic, but both approaches will work equally well. When the client machine runs the exe, it loads it from the C drive (or from a server share) into memory. At this point the client app is now resident in the client machine's memory.

All you need to do is as follows:

1 - make sure the runtime files are located in the same directory or share as the EXE.
2 - create a Windows shortcut to the .EXE from the client machine.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

simple program connecting vfp to sql using spt Posted by Leonard Trevor @ 8/13/2006 8:39:44 AM
RE: simple program connecting vfp to sql using spt Posted by Jojo Sabino @ 8/13/2006 9:07:03 AM
RE: simple program connecting vfp to sql using spt Posted by Leonard Trevor @ 8/13/2006 9:22:42 AM
RE: simple program connecting vfp to sql using spt Posted by Zaldy Santos @ 8/13/2006 9:28:41 AM
RE: simple program connecting vfp to sql using spt Posted by Leonard Trevor @ 8/13/2006 9:45:46 AM
RE: simple program connecting vfp to sql using spt Posted by Jojo Sabino @ 8/13/2006 9:45:18 AM
RE: simple program connecting vfp to sql using spt Posted by Leonard Trevor @ 8/13/2006 9:50:37 AM
RE: simple program connecting vfp to sql using spt Posted by Jojo Sabino @ 8/13/2006 10:00:27 AM
RE: simple program connecting vfp to sql using spt Posted by Bernard Bout @ 8/14/2006 6:18:07 AM
RE: simple program connecting vfp to sql using spt Posted by Ken Murphy @ 8/16/2006 2:28:43 PM
RE: simple program connecting vfp to sql using spt Posted by Andy Kramek @ 8/13/2006 2:01:44 PM