Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Zaldy Santos
  Where is Zaldy Santos?
 Tokyo
 Japan
 Zaldy Santos
 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: 104209 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Sunday, August 13, 2006 9:28:41 AM         
   


an SQL Server instance available to your development environment should also be available from your client workstations. just make sure you have set all the SQL Server permisions correct.



> 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