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: Zaldy Santos
  Where is Zaldy Santos?
 Tokyo
 Japan
 Zaldy Santos
 Tags
Subject: RE: simple program connecting vfp to sql using spt
Thread ID: 104206 Message ID: 104212 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Sunday, August 13, 2006 9:45:46 AM         
   


The program will run perfectly on the server.
Whai is of my immediate concern is the workstation portion.

I will definitely create a short cut to reference the database on the server.

Assuming the database is northwind.

How do I create the worlstation script to reference the server without any diffivulty in referencing the server option.

any script?






> 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