• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 932
  • Last Modified:

VB app move from Oracle 11.2 to 12c db?

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
talahi
Asked:
talahi
  • 3
  • 3
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
talahiAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
talahiAuthor Commented:
Thanks again.  Will try this managed driver.
0
 
slightwv (䄆 Netminder) Commented:
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
 
talahiAuthor Commented:
I'll probably have other non duplicate questions but this will keep us busy tomorrow.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now