microsoft odbc for oracle problem

what is the solution for this problem...
Ranjan Singh SolankiAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Alex [***Alex140181***]Software DeveloperCommented:
microsoft odbc for oracle problem
what is the solution for this problem...
Seriously?!? What problem? Where's the information? We're no fortune tellers!!
slightwv (䄆 Netminder) Commented:
The solution to this problem is to NOT use the Microsoft drivers.  They have been depercated and desupported for a long time.

All the Microsoft drivers for Oracle sat on top of the Oracle drivers so you still needed an Oracle client.  If you had an Oracle client, why not just use it.

I would suggest using the native Oracle drivers.  Mainly the Instant Client.

You need two downloads.

Start here:
https://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

Then chose the correct Bit version.  This needs to match the app using it NOT the OS you are running it on.

Once there these are the two downloads:
Basic Package - All files required to run OCI, OCCI, and JDBC-OCI applications
ODBC Package - Additional libraries for enabling ODBC applications

Unzip both to the same folder and open a CMD prompt as Administrator and run the ODBC installer.

You will also need a valid tnsnames.ora file.  Manually create a network\admin folder under the folder you unzipped the Oracle drivers.  Copy a good version of the tnsnames.ora and sqlnet.ora files in there.

Then you need to choose the correct ODBC admin tool to create the DSN.  There is a 32Bit and 64Bit version:
https://support.microsoft.com/en-us/help/942976/odbc-administrator-tool-displays-both-the-32-bit-and-the-64-bit-user-d



If you need more, please provide specifics on what the problem is.  Error message help A LOT.

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
slightwv (䄆 Netminder) Commented:
As many times as I've had to pretty much type the exact same thing I posted here, I think the more copies that are out there, the more chances people find it and don't have to ask.

I would suggest accept my post and add it to the knowledge base.
Alex [***Alex140181***]Software DeveloperCommented:
Seriously?!?
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.