Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> Change database driver in existing llblgen project
 

Pages: 1
Designer
Change database driver in existing llblgen project
Page:1/1 

  Print all messages in this thread  
Poster Message
hoopyfrood
User



Location:

Joined on:
30-Sep-2008 15:39:56
Posted:
3 posts
# Posted on: 16-Jun-2009 08:21:50.  
Is it possible to do this? I am currently using

        Oracle DBDriver using MS Oracle (2.5.12132007)

And I want to switch to

        Oracle Data Provider for .NET 2.0 10.2.0.2.20



I've looked but not found a way to do this other than creating a new project, which would be time-consuming considering the size of the project I'm working on.



I'm using LLBLGen Pro 2.5.
  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14639 posts
# Posted on: 16-Jun-2009 09:54:40.  
Use the project converter to do this. (available in sourcecode in the customer area, extras section).

  Top
hoopyfrood
User



Location:

Joined on:
30-Sep-2008 15:39:56
Posted:
3 posts
# Posted on: 18-Jun-2009 15:08:57.  
Thanks!
  Top
kwo
User



Location:
Chelmsford, MA, USA
Joined on:
29-Jul-2008 18:43:50
Posted:
26 posts
# Posted on: 08-Oct-2009 16:22:13.  
We have a LLBLGen 2.6 project that needs to be converted from Sybase ASE to SqlServer. I've tried running the converter but haven't had much success yet. I see the following in the readme file. Does this mean Sybase ASE is not supported in the source project, destination project or both?

Quote:
Sybase Ase/Asa aren't supported at the moment. They'll be added in due time


Thanks,

Ken


  Top
kwo
User



Location:
Chelmsford, MA, USA
Joined on:
29-Jul-2008 18:43:50
Posted:
26 posts
# Posted on: 08-Oct-2009 19:40:37.  
After looking at the sources I've found the answer is that Sybase is currently not supported for either source or destination.

Thanks
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
38090 posts
# Posted on: 09-Oct-2009 10:16:52.  
kwo wrote:
After looking at the sources I've found the answer is that Sybase is currently not supported for either source or destination.

Thanks

It shouldnt be that hard to add the sybase support, if you really need it. It's just a set of rules. ASE has a lot in common with Sqlserver for example.


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



Location:

Joined on:
23-Aug-2009 18:52:40
Posted:
17 posts
# Posted on: 13-Oct-2009 16:32:57.  
Where can I find the project converter?

Thanks
Kebin
  Top
kwo
User



Location:
Chelmsford, MA, USA
Joined on:
29-Jul-2008 18:43:50
Posted:
26 posts
# Posted on: 13-Oct-2009 16:36:30.  
Kebin, as Walaa mentioned its available in sourcecode in the customer area, extras section.

FYI, Frans is right. I was able to add Sybase support (at least for the datatypes we are using) pretty easily...

Ken


  Top
kew98
User



Location:

Joined on:
23-Aug-2009 18:52:40
Posted:
17 posts
# Posted on: 13-Oct-2009 17:26:23.  
I login in, in the Extra item in the left pane, I saw External Resources link, click this link i got the following information, which is the project converter ?

Thanks
Kebin


External resources

This page contains links to external sites with LLBLGen Pro information, downloads and tutorials.

DISCLAIMER: Solutions Design isn't responsible for the content of these sites linked below. Use them at your own risk. If you find a link not working, or the link doesn't contain LLBLGen Pro related information, please inform us a.s.a.p. at support@llblgen.com


--------------------------------------------------------------------------------


LLBLGen'ing: Advanced articles and tutorials about LLBLGen Pro
LLBLGen'ing is a site maintained by David Elizondo of our support team and he writes new articles regularly about in-depth usage of LLBLGen Pro: Click here to open the LLBLGen'ing website in a new window


--------------------------------------------------------------------------------


Entity Browser tool
Fully featured Entity browser tool to browse live entities in a database.

URL: Direct link to download site


--------------------------------------------------------------------------------


Righthand consulting various articles/tools/plugins
Final Builder 4.0 action for LLBLGen Pro which invokes the command line code generator to generate code.
URL: Direct link to article with code

Plugin to set entity fields in bulk to readonly.
URL: Direct link to article with code

Article on extending ResultsetFields to make it work like a normal List with Add() methods.
URL: Direct link to article with code

Article on how to make the SQL statements written to the Trace output be stored in the native RDBMS syntaxis so the queries can be copied to a query tool directly.
URL: Direct link to article with code


  Top
kwo
User



Location:
Chelmsford, MA, USA
Joined on:
29-Jul-2008 18:43:50
Posted:
26 posts
# Posted on: 13-Oct-2009 17:33:45.  
Kebin, once logged into the Customer's area go to the "Downloads for v2.6" and you'll see the Extras section.

Ken


  Top
kew98
User



Location:

Joined on:
23-Aug-2009 18:52:40
Posted:
17 posts
# Posted on: 13-Oct-2009 17:58:27.  
Ken, I got the projectConverter, thnank you.

I try to resolve the my problem at "http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=16705", if you have time, please try to help on this issue.

Thanks
Kebin
  Top
kew98
User



Location:

Joined on:
23-Aug-2009 18:52:40
Posted:
17 posts
# Posted on: 13-Oct-2009 18:09:04.  
I tried to run projectconverter,
"projectconverter DataEntity.lgp DataEntity-New.lgp Oracle"

I got exceptions.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\kwen2>cd "C:\downloads\ProjectConverter_07082009\ProjectConverter\bin\Debug"

C:\downloads\ProjectConverter_07082009\ProjectConverter\bin\Debug>dir
Volume in drive C is CSC ESOE
Volume Serial Number is 0C3F-F708

Directory of C:\downloads\ProjectConverter_07082009\ProjectConverter\bin\Debug

10/13/2009 11:54 AM    <DIR>         .
10/13/2009 11:54 AM    <DIR>         ..
10/12/2009 02:53 PM         358,767 DataEntity.lgp
10/13/2009 11:44 AM            20,480 ProjectConverter.exe
10/13/2009 11:39 AM             6,468 ProjectConverter.exe.config
10/13/2009 11:44 AM            15,872 ProjectConverter.pdb
10/13/2009 11:51 AM            14,328 ProjectConverter.vshost.exe
10/13/2009 11:39 AM             6,468 ProjectConverter.vshost.exe.config
07/20/2007 08:33 PM             490 ProjectConverter.vshost.exe.manifest
09/10/2009 12:17 PM         376,832 SD.LLBLGen.Pro.ApplicationCore.dll
09/10/2009 12:17 PM            69,632 SD.LLBLGen.Pro.DBDriverCore.dll
11/19/2008 05:19 AM            16,384 SD.LLBLGen.Pro.LicensingLibrary.dll
10/13/2009 11:44 AM            73,728 SD.LLBLGen.Pro.Tools.ProjectConverter.Core.dll
10/13/2009 11:44 AM         181,760 SD.LLBLGen.Pro.Tools.ProjectConverter.Core.pdb
             12 File(s)     1,141,209 bytes
             2 Dir(s) 21,871,263,744 bytes free

C:\downloads\ProjectConverter_07082009\ProjectConverter\bin\Debug>projectconverter DataEntity.lgp DataEntity-New.lgp Ora
cle
ProjectConverter for LLBLGen Pro v2.6. Version 1.0.06052009.
(c)2002-2009 Solutions Design. All rights reserved.
Exception caught.
=====================
Exception type: SD.LLBLGen.Pro.Tools.ProjectConverter.Core.DriverLoadFailureException
Message: Failed to load driver for ID "FBAE9964-8A54-4955-921B-827EDD41FFB4".
Source: SD.LLBLGen.Pro.Tools.ProjectConverter.Core
Stack trace:    at SD.LLBLGen.Pro.Tools.ProjectConverter.Core.Engine.GetDriverByID(String driverID) in C:\downloads\Proj
ectConverter_07082009\ProjectConverter.Core\Engine.cs:line 248
at SD.LLBLGen.Pro.Tools.ProjectConverter.Core.Engine.GetDriverByEnum(DatabaseType dbType) in C:\downloads\ProjectConv
erter_07082009\ProjectConverter.Core\Engine.cs:line 292
at SD.LLBLGen.Pro.Tools.ProjectConverter.UI.CLI.Startup.Main() in C:\downloads\ProjectConverter_07082009\ProjectConve
rter\Startup.cs:line 53
Inner exception:-----------------------
Exception caught.
=====================
Exception type: System.IO.DirectoryNotFoundException
Message: Could not find a part of the path 'C:\downloads\ProjectConverter_07082009\ProjectConverter\bin\Debug\Drivers'.
Source: mscorlib
Stack trace:    at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalGetFileDirectoryNames(String path, String userPathOriginal, String searchPattern, Bool
ean includeFiles, Boolean includeDirs, SearchOption searchOption)
at System.IO.Directory.GetDirectories(String path, String searchPattern, SearchOption searchOption)
at System.IO.Directory.GetDirectories(String path)
at SD.LLBLGen.Pro.ApplicationCore.ApplicationConfiguration.LoadDatabaseDriverDefinitions()
at SD.LLBLGen.Pro.ApplicationCore.ApplicationConfiguration..ctor()
at SD.LLBLGen.Pro.Tools.ProjectConverter.Core.Engine.GetDriverByID(String driverID) in C:\downloads\ProjectConverter_
07082009\ProjectConverter.Core\Engine.cs:line 241
Inner exception: <null>
---------------------------------------

C:\downloads\ProjectConverter_07082009\ProjectConverter\bin\Debug>


  Top
kwo
User



Location:
Chelmsford, MA, USA
Joined on:
29-Jul-2008 18:43:50
Posted:
26 posts
# Posted on: 13-Oct-2009 18:12:42.  
This error indicates there is no support for your database driver in the project converter. I ran into the same error when using Sybase.

Quote:
Message: Failed to load driver for ID "FBAE9964-8A54-4955-921B-827EDD41FFB4".


Ken
  Top
kew98
User



Location:

Joined on:
23-Aug-2009 18:52:40
Posted:
17 posts
# Posted on: 13-Oct-2009 18:43:24.  
What is the solution?

  Top
kwo
User



Location:
Chelmsford, MA, USA
Joined on:
29-Jul-2008 18:43:50
Posted:
26 posts
# Posted on: 13-Oct-2009 18:46:11.  
I added code to the project converter to support the sybase driver. This mostly just involves adding the appropriate datatype mapping from database specific types to/from canonical types.

You'll need to do something similar for your database driver.

Ken
  Top
kew98
User



Location:

Joined on:
23-Aug-2009 18:52:40
Posted:
17 posts
# Posted on: 13-Oct-2009 19:04:39.  
Look at the Usage of peojectconverter:

Usage
ProjectConverter SourceProject DestinationProject DestinationDBType

where DestinationDBType can be: Access, DB2, Firebird, MySql, Oracle, Oracle10g, OracleMS, PostgreSql or SqlServer
where SourceProject and DestinationProject are .lgp filenames with full path.

The converter always creates a new file, it never does in-place conversion, so your original .lgp file is safe and won't be touched / overwritten.

Oracle, Oracle10g, OracleMS are supported, I thought I don't need to do any customization. Is this correct?

If I need to add code, where to add the customization code?


  Top
daelmo
Support Team



Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
8150 posts
# Posted on: 14-Oct-2009 04:25:55.  
Quote:
Exception type: System.IO.DirectoryNotFoundException
Message: Could not find a part of the path 'C:\downloads\ProjectConverter_07082009\ProjectConverter\bin\Debug\Drivers'.

ProjectConverter can't find the Drivers folder. You have two options:

A. Modify the ProjectConverter's app.config file and place absolute paths for the folder definitions. For instance, instead of:
Code:
<add key="databaseDriversRootFolder" value="Drivers"/>

use
Code:
<add key="databaseDriversRootFolder" value="C:\Program Files\Solutions Design\LLBLGen Pro v2.6\Drivers"/>

Do this for all folder definitions on the app.config

B. Once you build the ProjectConverter move the following files from \bin\Debug to [LLBLGen Pro installation folder]:
     - ProjectConverter.exe
     - ProjectConverter.exe.config
     - SD.LLBLGen.Pro.Tools.ProjectConverter.Core.dll
Then run the project converter from [LLBLGen Pro installation folder]
David Elizondo
LLBLGen'ing (articles and code snippets) | linkedin | twitter
 
Top
azag123
User



Location:

Joined on:
12-Mar-2013 10:23:32
Posted:
4 posts
# Posted on: 07-Mar-2020 04:57:22.  
Resurrecting a 10 year old thread Regular Smiley

I have an old legacy system that is written using v2.6 (SQLServer DBDriver) - when connecting to newer versions of SQL Server I get a bunch of errors. My thought is that the connection type is no longer valid for the newer versions of SQL Server.

From the above, looks like there used to be a Project Converter for the old files - does this still exist? (I cant see it in the Customer portal).

Thanks!~


  Top
azag123
User



Location:

Joined on:
12-Mar-2013 10:23:32
Posted:
4 posts
# Posted on: 07-Mar-2020 05:26:54.  
azag123 wrote:
Resurrecting a 10 year old thread Regular Smiley

I have an old legacy system that is written using v2.6 (SQLServer DBDriver) - when connecting to newer versions of SQL Server I get a bunch of errors. My thought is that the connection type is no longer valid for the newer versions of SQL Server.

From the above, looks like there used to be a Project Converter for the old files - does this still exist? (I cant see it in the Customer portal).

Thanks!~


Please ignore - looking around I see we'll need to upgrade (we have SQL 2016). Couldnt figure out how to delete my post Regular Smiley
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
38090 posts
# Posted on: 07-Mar-2020 08:31:11.  
No worries, I'll just close the thread Regular Smiley

Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1  


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

Version: 2.1.12172008 Final.