StrataFrame Forum

foxpro 2.6 Free Tables

http://forum.strataframe.net/Topic5231.aspx

By Paul Chase - 12/12/2006

I am working on writing an import routine for 2.6 free tables to SQL. Currently I am just using an oledb command to get the fox data but it would be nice to be able to use a business object for the strong typing(I have a terrible memory when it comes to field names) , however it looks like you only support a DBC in the BOMapper when it creates the connection string.

I guess I can just create a DBC and add the tables I need to it, but because this is going to be part of the install which means I will also need to create a VFP com object to create and add tables to the DBC aswell as ship the VFP runtimes. So might just be easier to flip back and forth to get field names and the translation. any recomendations?

By StrataFrame Team - 12/12/2006

No, you can use free tables, you just have to manually create the connection string... you can't use the wizard, as the wizard (through the "..." button) looks only for DBCs. 

Here's some more info for you Smile

http://forum.strataframe.net/FindPost1840.aspx

By Paul Chase - 12/13/2006

Ben that makes sense I just didnt think of manually setting the connection string. You spoiled me with too many wizards and gui options. I have almost forgot how to typeBigGrin
By Paul Chase - 12/13/2006

It works fine
By StrataFrame Team - 12/13/2006

Hehe, well, when we first put the connection string blanks in the BOMapper, there wasn't a "..." button to build the string for you in a wizard, and we got some major blowback on that...
By Paul Chase - 12/13/2006

Hehehe I bet!

Im sure that developing for developers has its own set of challenges!

By StrataFrame Team - 12/13/2006

Hehe, yes, the tools development business is completely different from creating commercial software Tongue