StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Using Visual FoxPro free table in Combination with SQL Server Database

Using Visual FoxPro free table in Combination with SQL Server Database

Elio Reyes — Tue, 16 Sep 2008 16:18:13 GMT

I see the VFPStandAloneTable sample, I hope does everything this sample has, but my program does not work.

I have more table from different folder that I have to incorporate in the project but when my first.

Thanks SF

RE: Using Visual FoxPro free table in Combination with SQL Server Database

Ivan George Borges — Tue, 16 Sep 2008 16:18:13 GMT

[quote]You Are Right... Like ever[/quote]

Well, and you are completely wrong on this. :D

But glad you got it working! :cool:

RE: Using Visual FoxPro free table in Combination with SQL Server Database

Elio Reyes — Tue, 16 Sep 2008 16:05:43 GMT

Not... Thanks was my problem, I moved the sentence ConnectionManager.SetConnections() before create the DataLayer.

All is working fine ...

You Are Right... Like ever

Thanks very very Much SF

RE: Using Visual FoxPro free table in Combination with SQL Server Database

Ivan George Borges — Tue, 16 Sep 2008 15:27:20 GMT

Could you give us some more details?

A stack trace. Your DataLayer.DataSources.Add line also could help.

RE: Using Visual FoxPro free table in Combination with SQL Server Database

Elio Reyes — Tue, 16 Sep 2008 15:22:51 GMT

Well, now I have this error "An error occurred while creating a new DataLayer for the business object."

Thanks SF

RE: Using Visual FoxPro free table in Combination with SQL Server Database

Ivan George Borges — Tue, 16 Sep 2008 10:36:51 GMT

And in your BOs properties sheet, don't forget to set the DataSourceKey too:

RE: Using Visual FoxPro free table in Combination with SQL Server Database

Ivan George Borges — Tue, 16 Sep 2008 10:25:04 GMT

Hey Pedro.

Lets start checking your Data Source setting. In the AppMain.vb, you will find a "SetDataSources" sub. In there, you should manyally set your datasource for your free tables. Something like:

DataLayer.DataSources.Add(New VfpDataSourceItem("MyFreeTables", "Provider=vfpoledb.1;Data Source="C:\MyFolderWhereMyFreeTablesAre";Collating Sequence=general;"))

And if I understood what you said, you might have tables in different folders, so you could create differente datasource keys for each, and then map your BOs accordingly:

DataLayer.DataSources.Add(New VfpDataSourceItem("MyFreeTables2", "Provider=vfpoledb.1;Data Source="C:\MyOtherFolderWhereMyFreeTablesAre";Collating Sequence=general;"))