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


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

just for the idea
Not tested only pointers
 pconn=NewObject("adodb.connection")
 pconn.ConnectionString = "Provider=SQLOLEDB;DefaultDatabase=softgen;Trusted_connection=Yes"
 pconn.Open()
 
mrs = pconn.execute("Select * from my table")

do while !mrs.eof()
For each ofields in mrs.fields
?ofields.name,':',ofields.value
endfor
mrs.movenext
enddo



suhashegde

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