Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> Foxpro Driver for LLBLGEN v2.0
 

Pages: 1 2
Designer
Foxpro Driver for LLBLGEN v2.0
Page:1/2 

  Print all messages in this thread  
Poster Message
Rushmore
User



Location:
Germany
Joined on:
27-Jan-2005 15:22:06
Posted:
125 posts
# Posted on: 14-Mar-2007 09:44:18.  
Where can I upload the new Driver, DQE and template files for LLBLGEN v2.0?

I see only the repository for v1.0.2005.1.

Regards,
Carlo
LLBLGen Pro v4.0 Final (April 6th, 2013)
SQL Server 2005/2008/2012
Visual Foxpro 9 DBC
SQL Server Compact Edition
Sybase 12.01.3867
 
Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14569 posts
# Posted on: 14-Mar-2007 13:26:31.  
Do you want to upload or download?

  Top
Rushmore
User



Location:
Germany
Joined on:
27-Jan-2005 15:22:06
Posted:
125 posts
# Posted on: 14-Mar-2007 13:51:54.  
UPLOAD.
LLBLGen Pro v4.0 Final (April 6th, 2013)
SQL Server 2005/2008/2012
Visual Foxpro 9 DBC
SQL Server Compact Edition
Sybase 12.01.3867
 
Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14569 posts
# Posted on: 14-Mar-2007 14:14:35.  
As far as I know, you may create a folder under
svnDissapointed/www.sd.nl/LLBLGenPro/CustomDrivers/

Say you call it "v.2.0" where you can upload your work.
If you don't have permission to Upload, or to create a folder, please send an e-mail to
support AT llblgen DOT com with your CustomerID.


  Top
Rushmore
User



Location:
Germany
Joined on:
27-Jan-2005 15:22:06
Posted:
125 posts
# Posted on: 14-Mar-2007 14:45:55.  
Ok, I have the permissions to create the necessary folders.

I will upload the files today to /CustomDrivers/FoxPro/v2.0.
I have also renamed the folder Carlo to v1.0.2005.1, now it is clear, for which version the files are Laugh

Regards,
Carlo
LLBLGen Pro v4.0 Final (April 6th, 2013)
SQL Server 2005/2008/2012
Visual Foxpro 9 DBC
SQL Server Compact Edition
Sybase 12.01.3867
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37812 posts
# Posted on: 15-Mar-2007 06:14:06.  
I'm currently in Seattle, US, so I can't access the server with the repository right now, I will be able to do that within a couple of days, so I'll then make sure everything is in the right folder Regular Smiley. You can just check in into the folder you want and I'll make sure the stuff is moved into the right folder if it has to. Regular Smiley

Thanks for making this driver, Carlo! Laugh


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Rushmore
User



Location:
Germany
Joined on:
27-Jan-2005 15:22:06
Posted:
125 posts
# Posted on: 15-Mar-2007 09:00:42.  
Quote:
I'm currently in Seattle, US


That is pretty cool. If you have some spare time, please buy an original seattle mariners baseballcap for me Cool One size fits all, I don´t know what size my head is - there is a lot of stuff in it - and that need space Laugh

Regards,
Carlo
LLBLGen Pro v4.0 Final (April 6th, 2013)
SQL Server 2005/2008/2012
Visual Foxpro 9 DBC
SQL Server Compact Edition
Sybase 12.01.3867
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37812 posts
# Posted on: 16-Mar-2007 10:17:03.  
Rushmore wrote:
Quote:
I'm currently in Seattle, US


That is pretty cool. If you have some spare time, please buy an original seattle mariners baseballcap for me Cool One size fits all, I don´t know what size my head is - there is a lot of stuff in it - and that need space Laugh

Regards,
Carlo

Too late, I'm already back again Regular Smiley Sorry, Carlo.


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Rushmore
User



Location:
Germany
Joined on:
27-Jan-2005 15:22:06
Posted:
125 posts
# Posted on: 16-Mar-2007 11:58:36.  
I can live with that (I hope) ...
LLBLGen Pro v4.0 Final (April 6th, 2013)
SQL Server 2005/2008/2012
Visual Foxpro 9 DBC
SQL Server Compact Edition
Sybase 12.01.3867
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37812 posts
# Posted on: 17-Mar-2007 16:47:54.  
Regular Smiley

I think the files you've checked in are at the right spot! Thanks a lot for this work! Laugh


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
TomV
User



Location:
Belgium
Joined on:
31-Jan-2008 14:22:10
Posted:
76 posts
# Posted on: 26-Mar-2008 10:30:40.  
Hi,

We work on SQL Server, but for a very urgent client project with legacy code I need to access some FoxPro tables. So it would be a life saver if I could download the FoxPro driver today. The deadline is the end of the week...

Waiting for some more information...

Kind regards
TomV
Life goes fast, it must be riding a Ducati!  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14569 posts
# Posted on: 26-Mar-2008 11:14:40.  
It's still in the repository at
Code:
svn://www.sd.nl/LLBLGenPro/CustomDrivers/FoxPro/v2.0



  Top
TomV
User



Location:
Belgium
Joined on:
31-Jan-2008 14:22:10
Posted:
76 posts
# Posted on: 26-Mar-2008 11:17:46.  
Walaa wrote:
It's still in the repository at
Code:
svn://www.sd.nl/LLBLGenPro/CustomDrivers/FoxPro/v2.0



Thanks.
Does this mean that I'm allowed to get the code, build everything and use it?

Kind regards,
TomV

Life goes fast, it must be riding a Ducati!  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14569 posts
# Posted on: 26-Mar-2008 11:23:23.  
Yes sure.

  Top
TomV
User



Location:
Belgium
Joined on:
31-Jan-2008 14:22:10
Posted:
76 posts
# Posted on: 26-Mar-2008 11:44:12.  
Thanks Walaa,

I downloaded the code, copied the files within the installation directory of LLBLGenPro and tryied it out. But I get some errors. Maybe it's not finished yet?

The first part for the Adapter way of working is good as far I can see, but the DBSpecific code doesn't get generated. I get some errors. Looks like I miss the SD.TemplateBindingsFile like there is for SQL Server: SD.TemplateBindings.SqlServerSpecific.NET20.templatebindings.

Any idea where I might find it? Or I'm looking over it Sad

Code:

Generator process results
Task execution log.
    Task group: SD.Presets.Adapter.General2005
        Task group: SD.Tasks.Adapter.DatabaseGeneric
            Task: SD.Tasks.Adapter.DbGenericProjectDirectoryCreator
            Task group: SD.Tasks.Generic.DirectoryCreators
                Task: SD.Tasks.Generic.EntityClassesDirectoryCreator
                Task: SD.Tasks.Generic.FactoryClassesDirectoryCreator
                Task: SD.Tasks.Generic.HelperClassesDirectoryCreator
                Task: SD.Tasks.Generic.RelationClassesDirectoryCreator
                Task: SD.Tasks.Generic.TypedListClassesDirectoryCreator
                Task: SD.Tasks.Generic.TypedViewClassesDirectoryCreator
                Task: SD.Tasks.Generic.ValidatorClassesDirectoryCreator
            Task: SD.Tasks.Adapter.EntityCollectionClassGenerator
            Task: SD.Tasks.Generic.ConstantsEnumsFileGenerator
            Task: SD.Tasks.Generic.AssemblyInfoFileGenerator
            Task: SD.Tasks.Generic.FieldInfoProviderClassGenerator
            Task: SD.Tasks.Generic.TypeDefaultValueClassGenerator
            Task: SD.Tasks.Generic.InheritanceInfoProviderClassGenerator
            Task: SD.Tasks.Generic.EntityRelationsClassGenerator
            Task: SD.Tasks.Adapter.CommonBaseClassGenerator
            Task: SD.Tasks.Generic.EntityClassesGenerator
            Task: SD.Tasks.Generic.EntityFactoryClassesGenerator
            Task: SD.Tasks.Generic.EntityFieldFactoryClassGenerator
            Task: SD.Tasks.Generic.EntityFieldsFactoryClassGenerator
            Task: SD.Tasks.Generic.ResultsetFieldsClassGenerator
            Task: SD.Tasks.Generic.FieldCreationClassesGenerator
            Task: SD.Tasks.Generic.TypedListClassGenerator
            Task: SD.Tasks.Generic.TypedViewClassGenerator
            Task: SD.Tasks.Adapter.VsNetDbGenericProjectFileCreator
        Task group: SD.Tasks.Adapter.DatabaseSpecific
            Task: SD.Tasks.Adapter.DbSpecificProjectDirectoryCreator
            Task: SD.Tasks.Generic.AssemblyInfoFileGenerator
            Task: SD.Tasks.Generic.AppConfigFileGenerator
            Task: SD.Tasks.Generic.PersistenceInfoProviderClassGenerator
                    Could not find template 'SD_PersistenceInfoProviderAdapterTemplate'. It is not defined in the templatebindings or is empty.
            Task: SD.Tasks.Adapter.DataAccessAdapterClassGenerator
                    Could not find template 'SD_DataAccessAdapterTemplate'. It is not defined in the templatebindings or is empty.
            Task: SD.Tasks.Adapter.VsNetDbSpecificProjectFileCreator
                    Could not find template 'SD_VsNet2005DBSpecificAdapterTemplate'. It is not defined in the templatebindings or is empty.
            Task: SD.Tasks.Generic.ActionProceduresClassGenerator
                    Could not find template 'SD_ActionProceduresAdapterTemplate'. It is not defined in the templatebindings or is empty.
            Task: SD.Tasks.Generic.RetrievalProceduresClassGenerator
                    Could not find template 'SD_RetrievalProceduresAdapterTemplate'. It is not defined in the templatebindings or is empty.
        Task group: SD.Tasks.Adapter.Webservices.SchemaImporter


Anyway, thumbs up for Rushmore!! Nice to write this interface and it's even more nice to share this with us!

Kind regards
Tomv
Life goes fast, it must be riding a Ducati!  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37812 posts
# Posted on: 26-Mar-2008 13:23:58.  
You've to create a templatebindings file, similar to the sqlserver one, place it in the templates folder and make sure the file paths point to the foxpro templates.

Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
TomV
User



Location:
Belgium
Joined on:
31-Jan-2008 14:22:10
Posted:
76 posts
# Posted on: 26-Mar-2008 13:42:42.  
Thanks Otis,

I created the templatebinding for C# and I get less errors Laugh

But I still get errors for the action and retrievel templates. These were missing from the code I downloaded from SVN. Probably I'm doing something wrong, again Confused

Are these missing templates (available in SQL Server, ...) just missing or not needed for FoxPro (maybe related to stored procedures, etc...). I hope the second one.

Although the generated code seems to work. So I presume...
Now I'm having some reference problems. I have bought 2.5 and Visual Studio 2008 is complaining I should use a dll with version 2.0

Code:

The type 'SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase' is defined in an assembly that is not referenced. You must add a reference to assembly 'SD.LLBLGen.Pro.ORMSupportClasses.NET20, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null'.


Kind regards,
TomV
Life goes fast, it must be riding a Ducati!  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37812 posts
# Posted on: 26-Mar-2008 13:54:38.  
The templates are for v2.0. So you've reference the 2.5 runtime lib in your vs.net project. THe proc templates aren't needed, as foxpro doesn't have procs. (to my knowledge).

Perhaps the templates need some adjustments here and there, not sure.


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
TomV
User



Location:
Belgium
Joined on:
31-Jan-2008 14:22:10
Posted:
76 posts
# Posted on: 27-Mar-2008 09:32:21.  
Hi Otis,

Still busy getting this working...
I get reference problems... Because you told me the templates are for v2.0, I downloaded this version and created a new project, regenerated the code, but I still get 1 error on the following method...

Code:

/// <summary>
/// Creates a new Dynamic Query engine object and passes in the defined catalog/schema overwrite hashtables.
/// </summary>
protected override DynamicQueryEngineBase CreateDynamicQueryEngine()
{
    DynamicQueryEngine toReturn = new DynamicQueryEngine();
    return (DynamicQueryEngineBase)toReturn;
}


The error messages are (I think the second one is linked to the first one):

Code:

The type 'SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase' is defined in an assembly that is not referenced. You must add a reference to assembly 'SD.LLBLGen.Pro.ORMSupportClasses.NET20, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null'.


And the following

Code:

Cannot convert type 'SD.LLBLGen.Pro.DQE.Foxpro.DynamicQueryEngine' to 'SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase'


The strange part is that I actually have referenced the SD.LLBLGen.Pro.ORMSupportClasses.NET20, Version=2.0.0.0?

Can you please help me one more time, deadline is getting close now...

Kind regards
TomV
Life goes fast, it must be riding a Ducati!  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37812 posts
# Posted on: 27-Mar-2008 09:53:38.  
I think I see what happened.

The v2.0 version of the DQE has no source but is in subversion with just the dll. It is compiled against the ormsupportclasses sourcecode without a signature (publickey = null).

we didn't know the DQE was there just with the dll, it should have been source only. I'll see if I can get the DQE of 1.0.2005.1 compiled against the v2.0 ORMSupportclassses and will upload that source in the v2.0 branch.



Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
TomV
User



Location:
Belgium
Joined on:
31-Jan-2008 14:22:10
Posted:
76 posts
# Posted on: 27-Mar-2008 09:55:58.  
Thanks for the fast reply Otis!

I hope you can find it...

Kind regards
TomV
Life goes fast, it must be riding a Ducati!  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37812 posts
# Posted on: 27-Mar-2008 10:02:18.  
I've ported the code to v2.0:
Code:
svn://www.sd.nl/LLBLGenPro/CustomDrivers/FoxPro/v2.0/DQE


I don't have access to a foxpro db so it's not tested, but it compiled.

I've removed the binary files from svn. the v2.0 versions were ports from the 1.0 ones anyway.


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
TomV
User



Location:
Belgium
Joined on:
31-Jan-2008 14:22:10
Posted:
76 posts
# Posted on: 27-Mar-2008 11:04:28.  
Super! It works!

Thanks a lot Otis to help me out on this one!

And also one more time, thanks to Rushmore to give this code to the "LLBLGen community" Laugh

Kind regards
TomV
Life goes fast, it must be riding a Ducati!  Top
Rushmore
User



Location:
Germany
Joined on:
27-Jan-2005 15:22:06
Posted:
125 posts
# Posted on: 27-Mar-2008 13:31:39.  
TomV wrote:
Super! It works!
And also one more time, thanks to Rushmore to give this code to the "LLBLGen community" Laugh


There are some other issues with the Databasedriver too. Take care about the settings of decimal columns. I haven´t uploaded the ported source to the repository, because there are some known issues to solve. They depends on the DBDriver and the DQE.

I will upload the sources and modified templates if I have a really stable, tested and smooth running version Laugh

Kindly regards,
Carlo


LLBLGen Pro v4.0 Final (April 6th, 2013)
SQL Server 2005/2008/2012
Visual Foxpro 9 DBC
SQL Server Compact Edition
Sybase 12.01.3867
 
Top
TomV
User



Location:
Belgium
Joined on:
31-Jan-2008 14:22:10
Posted:
76 posts
# Posted on: 27-Mar-2008 13:33:39.  
Thanks Rushmore,

Any idea when this will be? For now I only need simple queries and a single delete statement. So I hope it will work for now...

I'll keep following this thread...

Kind regards
TomV
Life goes fast, it must be riding a Ducati!  Top
Pages: 1 2  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.