Solved

VB app move from Oracle 11.2 to 12c db?

Posted on 2014-10-27
6
672 Views
Last Modified: 2014-10-27
I'm working with a Visual Basic developer who only knows to compile with the new 12c Oracle.Data.Access.dll moving from Oracle database 11.2 to 12c.  So far he can only get one dll to compile but nothing to connection and he gets "dependency error".  We are also moving from a Windows  32bit 2003 app server to a 64bit Windows 2012R2 server.

I loaded 12C ODAC and tested it per Oracle support instructions so I'm confident that connection works.  This is all we did in the past moving from Oracle 10 to 11.  Since at this point "I don't know what I don't know" is there anything else our VB developer needs to do to get his code to work with a 12C database?
0
Comment
Question by:talahi
  • 3
  • 3
6 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40407310
Straight VB or VB.Net?

Is the app 32Bit or 64Bit?  Make sure you install the correct Bit version of the ODAC for the app not the server.
0
 

Author Comment

by:talahi
ID: 40407417
VB.net web app. The app in 32bit.  ODAC version is 64bit.  Do I need to stick to 32bit ODAC for a 32bit app or can he convert it to a 64bit app, and if so how difficult?  Originally everything deveoped in 32bit environment (XP and 2003 server) but we've recently been upgraded to 64bit (Win7 and 2012r2 server).
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40407502
32Bit apps talk to 32Bit drivers.  64Bit apps talk to 64Bit drivers.  You cannot mix them.

>>can he convert it to a 64bit app, and if so how difficult?

I only know enough .Net to be a little more than dangerous.

Don't know.  I believe the default is 'AnyCPU'.  You should be able to compile for 64Bit.  Just not sure if the app will work or not since I don't know what it does.

That said:
I would look strongly at the new 12c Managed Driver.  It doesn't require an Oracle client install.  I've been using it in development since it came out and am very happy with it.

We are getting ready to go into production with it soon.

Tell the developer it should only be a namespace change.  That is unless you are doing something that isn't supported yet but that list is small.

Download the ODP.NET, Managed Driver Xcopy version only

32Bit:
http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html

64Bit:
http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

Author Closing Comment

by:talahi
ID: 40407528
Thanks again.  Will try this managed driver.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40407532
Are you sure you don't want to leave this open until it is up and running?

If it doesn't work, then you'll need to ask a question that will likely be a duplicate.

Just let me know an I can unaccept this for you.
0
 

Author Comment

by:talahi
ID: 40407547
I'll probably have other non duplicate questions but this will keep us busy tomorrow.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question