Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Leonard Trevor
  Where is Leonard Trevor?
 Edinburgh
 United Kingdom
 Leonard Trevor
 To: Jojo Sabino
  Where is Jojo Sabino?
 Makati City
 Philippines
 Jojo Sabino
 Tags
Subject: RE: simple program connecting vfp to sql using spt
Thread ID: 104206 Message ID: 104208 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Sunday, August 13, 2006 9:22:42 AM         
   


I 've done all that, and its working well.

All I need now is calling the sql server from the client workstation.
I'm doing an installation tomorrow, so I want to know how to do that.






The program runs alright in the development environment, because i'm using one computer.


> > 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