Connection to DB2 from Visual FoxPro

[Mike Rose]

Hi. A gift has just fallen into my lap in the form of an SP/2 box with a
copy of DB2 installed. We are currently a Visual FoxPro shop, but would
like to explore the possibility of using DB2. We are running Windows/NT
on the client end.

If anyone out there has some experience in doing this, I'd appreciate
hearing from you how it went.

Thanks.

Michael Rose

[The Bikeman]

Mike Rose wrote in message <367EED06...@ctfinance.com>...

We're building it now. Visual Fox 5.0 with a DB/2 5.2 database on a NT
machine.
DB/2 has a maximum of 18 characters for fieldnames. That sucks because we
had longer fieldnames in our foxpro tables.
But apart from that....it's running on a WAN and the performance is much
higher than the foxpro database !
Still it's not as fast as a foxpro database on a LAN but on a WAN a real
database server like DB2 beats Fox anytime....

So: not too much problems (apart from learning how to install DB2 on an NT
machine and all that stuff, it's not as easy as creating a foxpro database,
especially if you have to learn it yourself without books or training ;-)
Just use parameterized remote views in Foxpro to the db2 tables and that's
it !

Have phun

[Howard F. Arner, Jr.]

Mike,

Probably you should investigate using ADO from VFP. Or, I have a free
active X dll on my web site that makes ODBC real easy. Code examples on
site are in VB, but you'll get the idea of how to use it. The main
difference between ADO and my DLL is I can call extended bind which allows
multiple inserts, (you can get 2,500 inserts per second this way), and ADO
can not do this. All other ODBC functionality is available.

BTW, I have a tool on my web that will let you import those foxpro tables
into your DB/2 really fast, look at products page for info and free trial.
(Sorry for sales pitch...)

Howard F. Arner, Jr.
www.sqlthing.com
hfa...@nospam.sqlthing.com