Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefanus Eddy
  Where is Stefanus Eddy?
 Surabaya
 Indonesia
 Stefanus Eddy
 To: Erik Gomez
  Where is Erik Gomez?
 Victorias City, Negros Occidental
 Philippines
 Erik Gomez
 Tags
Subject: RE: bests practise connect to MSSQL
Thread ID: 268533 Message ID: 268565 # Views: 38 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, July 13, 2010 10:25:34 AM         
   


> > dear all expert,
> >
> > as i said in my message subject: bests practise connect to MSSQL, i plan to use MSSQL server as backend DB and create connection from VFP to MSSQL is succes, and my question is: leave this connection always open and i can used it in all my form or open and close this connection when i need it in form and close this connection when i release form. please guide me
> >
> >
> >
> >
> > regards,
> >
> > eddy
> Hi eddy,
>
> Check out the VFP help file's section for: Using SQL Pass-Through Technology
>
> here's an excerpt...
> "SQL pass-through technology allows you to send SQL statements directly to the server and, because the statements execute on the server, they are a powerful way to enhance the performance of your client/server application."
>
> i've developed several VFP apps employing MySQL Server or MSSQL Server back-ends and have used SQL Pass-Through Technology (SPT) on all of them, SPT allows me almost complete control on what i want to accomplish with my chosen back-end. in most of my apps using SPT, i use a DSN-less connection unless it it imperative to use a DSN (for security compliance for our client). the section in the VFP help file should be enough to get you started. you might want to search the archives of this incredible site for more info on MSSQL server back-end as well as SPT.
>
> hth,
> Erik Gomez
> www.foxite.com - The Home of The Visual FoxPro Experts
> Personal Weblog
> My Other Blog



thank you arik gomez and samir

ENTIRE THREAD

bests practise connect to MSSQL Posted by Stefanus Eddy @ 7/13/2010 4:58:06 AM
RE: bests practise connect to MSSQL Posted by Samir H. @ 7/13/2010 5:34:36 AM
RE: bests practise connect to MSSQL Posted by Erik Gomez @ 7/13/2010 8:25:59 AM
RE: bests practise connect to MSSQL Posted by Stefanus Eddy @ 7/13/2010 10:25:34 AM
RE: bests practise connect to MSSQL Posted by Adam Walan @ 7/13/2010 7:48:48 PM
RE: bests practise connect to MSSQL Posted by Stefanus Eddy @ 7/14/2010 2:10:30 PM