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.

Use the project converter to do this. (available in sourcecode in the customer area, extras section).

Thanks!

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?

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

Thanks,

Ken

After looking at the sources I've found the answer is that Sybase is currently not supported for either source or destination.

Thanks

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.

Where can I find the project converter?

Thanks Kebin

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

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

Kebin, once logged into the Customer's area go to the "Downloads for v2.6" and you'll see the Extras section.

Ken

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

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>

This error indicates there is no support for your database driver in the project converter. I ran into the same error when using Sybase.

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

Ken

What is the solution?

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

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?

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:

<add key="databaseDriversRootFolder" value="Drivers"/>

use

<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]

Resurrecting a 10 year old thread

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!~

azag123 wrote:

Resurrecting a 10 year old thread

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

No worries, I'll just close the thread