I have a woefully old application that I cannot convert to a newer version of .NET or LLBLGenPro, but I do need it to run on a server with an 11g full up database installation (not just client). I have the 9i ODP.NET, but I assume I cannot install it on the server with the 11g database. Maybe this is a bad assumption, but in my experience Oracle components do not uninstall very well, so I would be more comfortable knowing what I need to do before I start. I was planning on just installing the 11g ODP.NET but I wasn't sure if the older version of LLBLGenPro would work with the newer ODP. Can you recommend the ODP version I should use to accomplish my goal?

There is a private thread that discussed this time ago. I will paste some relevant comments:

customer wrote:

We're using an old LLBLGen version and now we need to update our project to use Oracle 11g client (using ODP.NET 2.111.6.20) and .NET 2.0. Do you have an LLBLGen version compatible with Oracle 11g client and .NET 2.0?

customer wrote:

In fact, we are using the version v1.0.2005.1. The point is which version of llblgen that support Oracle 11g client (using ODP.NET 2.111.6.20) and .NET 2.0?

daelmo wrote:

Yes, v2.x (2.0, 2.5, 2.6). For v2.0 and v2.5 you may need assembly redirects for the policies. Check this for requirements.

Otis wrote:

1.0.2005.1 could use 11g, as 11g comes with a .NET 1.x build if I'm not mistaken (the 1.11... versioned dll).

Did you already tried the connection? What is your target .net framemok? (1.1, 2.0...)

Target framework is 1.1. I have not tried it because as I said I have had bad experiences installing Oracle components and then trying to remove them if they don't work. This is not my server so I can't risk messing it up. I was hoping someone on this forum had run into a similar dilemma.

Can you tell if you have a .NET 1.1 version of the 11g ODP.Net installer...?

Here are some similar discussions (I guess you may well have seen them already but they may help...!)

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/a8c5fc74-f889-4e0a-8c96-b6142f8542b8/

http://cshay.blogspot.com/

http://stackoverflow.com/questions/2208286/oracle-data-provider-for-net

Matt

Sorry for reopening this thread, but I am stuck. I was mistaken in my description of the configuration.

1. Windows forms application is written in VB.NET 2003 using LLBLGenPro v1.0.2005.1
2. Oracle Database is 11g on server 1
3. Oracle client on server 2 is 10g

The application must run on server 2. After doing some research I installed ODP.NET 10g for .Net 1.x in a separate home from the 10g client on server 2. I originally had a problem with TNSPING being able to resolve the service name, so I ended up adding the ORACLE_HOME system environment variable to point to the 10g client home. Now TNSPING works, but when I run the application I am getting this error: ORA-12154: TNS:could not resolve the connect identifier specified. My connection info in the app.config file is: <add key="Main.ConnectionString" value="data source={0};User Id={1};Password={2};persist security info=false;" />

Does anyone have any experience with this type of installation? Can you offer any clue as to what I need to do to get this working?

IN server 2, inside the Oracle Client Home, the Tnsnames.ora youshould have an identifier for the Oracle instance in server 1.

Then the connection string of the application should use this identifier.

Do you have these?