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?
talahiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.