Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: dheeraj kumar
  Where is dheeraj kumar?
 chandigarh
 India
 dheeraj kumar
 To: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 Tags
Subject: RE: vfp9 with sql server
Thread ID: 155358 Message ID: 155362 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Monday, December 31, 2007 8:25:21 AM         
   


> > hi experts
> >
> > i m trying vpf9 with sql server..
> >
> > presently i m using free tables..
> >
> > i have some quries..
> >
> > please help
> >
> > 1. what is the best method for connection
> > 2. how to add, alter & delete records so that it will be avaible to all the
> > clients instantly.
> > 3. using free tables my app. performance is quite good. is it will be same with sql server.. any suggestions...
> >
> > kumardheeraj
>
> Dheeraj
>
> 1. Check out the SQLCONNECT and SQLSTRINGCONNECT functions.
> 2. Check out the tutorial by Bernard Bout in the article section on cursor adaptors to 3. It depends since you will be moving from file server to data server. On a data server, the load on the network traffic will be reduced, but the load on the processing power of the server will increase. Normally, since the network is a major constraint and increasing the specs of the server is easier, the speed of SQL Server should be slightly more.
>
> Regards
> Tushar


Thanx for ur response..

i m using adodb

pconn=NewObject("adodb.connection")
pconn.ConnectionString = 'Provider=SQLOLEDB;DefaultDatabase=softgen;Trusted_connection=Yes'
pconn.Open

mrs=NewObject("adodb.recordset")

is this doesnt work...

kumardheeraj

ENTIRE THREAD

vfp9 with sql server Posted by dheeraj kumar @ 12/31/2007 7:11:53 AM
RE: vfp9 with sql server Posted by tushar @ 12/31/2007 7:29:14 AM
RE: vfp9 with sql server Posted by dheeraj kumar @ 12/31/2007 8:25:21 AM
RE: vfp9 with sql server Posted by suhas hegde @ 12/31/2007 11:00:18 AM
RE: vfp9 with sql server Posted by Andy Kramek @ 12/31/2007 11:33:13 AM
RE: vfp9 with sql server Posted by Cetin Basoz @ 12/31/2007 12:26:09 PM
RE: vfp9 with sql server Posted by Dinesh sharma @ 1/1/2008 10:22:40 AM
RE: vfp9 with sql server Posted by Ken Murphy @ 1/1/2008 4:11:32 PM