Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jojo Sabino
  Where is Jojo Sabino?
 Makati City
 Philippines
 Jojo Sabino
 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: 104207 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Sunday, August 13, 2006 9:07:03 AM         
   


> I have converted my datafiles from visual foxpro to a client server using sql server.
>
> I will be grateful if someone will provide me with the program segment connection fron the workstation to the server.
>
>
>
> How do i reference the sql database from a client workstation in my program, (.i.e setting the path from the worksation to the server) I want to generate an executable, which when installed at the client end should be able to reference the database say nortwind.
>
> There seems to be no book which gives the necessary details on ditribution
> of applications developed using client server spt approach
>
> A program segment will help ?
>
> Thanks



Have you check the SQLEXEC, SQLCONNECT, SQLSTRINGCONNECT and more function to directly connect to your SQL Server?

For a simple start you can configure your ODBC to connect your client to your SQL Server, Then simply use the DSN file to connect your Remote Views or Cursor Adapters.



ynajoe

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