Connect DB2 32 bits client with a 64 application

Question

0.00/5 (No votes)

See more:

Dear Friend

I´m near to be crazy. I´m not able to connect the IBM DB2 32 bits client, I tried by OBDC, OLE and native dll, but without succes.

I´ll explain better:

- The client shall be 32 bits, so all driver are 32 bits, because the ERP system run only in a 32 bits

- I´m developing an application to Autodesk Inventor (CAD) that is 64 bits

- When I am trying to connect the database, some errors occurr:

1) OLE: the IBMDADB2 provider isn´t registerd (I think that the system reject this dll registration)

2) ODBC: the 64 bits driver isn´t correctly instaled

3) Native DB2 dll: the system reject this access

What can I do? I´m using the Visual Basic language

I´ll be very thankfull for any suggestion

Thanks

Posted 19-Jul-11 17:16pm

Member 8036557

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2011-07-20T07:20:00

You cannot use 32-bit database drivers in a 64-bit application. Why? Because you cannot mix 32 and 64-bit code in the same process.

You either have to install and use 64-bit drivers for your database (not likely by your description) or go into your project properties in Visual Studio and on the Compile tab, click the Advanced button and change the Target type from AnyCPU to x86.