Accessing Database in VFP

[oneshadow]

Hi all,
I'm wondering, if I have SQL Server 7.0 as my database, and I want to access it with an VFP app :

1. Do I have to use ODBC?
2. Can it be done without ODBC?
3. Can I use ADO in VFP?

Thanks in advance.

 

[TomasDill]

1. Yes, ODBC used automatically by VFP to connect to SQL Server. See 3 also.
2. Yes, see 3.
3. Yes, you can use ADO in VFP. More, ADO allows to connect to SQL Server using OLE DB provider, as well as it provides the "usual" way using ODBC. ADO is quite good for n-tire applications because it contains built in tools to convert data into XML and back.

Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[jonscott8]

Appendum to Vlad's comments:

1. There is a FAQ here that includes an example of how to programmatically establish an ODBC connection in VFP.

2. One limitation of VFP is its inability to surface COM events. So if the need arises for you to use ADO events, there is a utility VFPCOM available for download at

http://msdn.microsoft.com/vfoxpro/downloads/updates.asp

There is an explanation of exactly what is does and how to use it there. Jon Hawkins
jonscott8@yahoo.com

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed