ODBC in server 64 bits

[Former Member]

Dear all.

In my test server (W2003 Server 32bits) I have installed an ODBC to external DB , and with transaction DBCO I have made the connection.

Finally in Z program with Native SQL , I can establish the connection to DB, and do querys to external DB..., and ALL it's OK.

I have transported the program to my production server (W2003 Server 64 BITS) , I have installed the same ODBC, I have made the same in DBCO..., and I have tested the ODBC run correctly...

What it's the problem???... In my ABAP program, the connection it's not established... why if all configurations are the same as in test server???...

I think the problem it's the ODBC driver it's for 32 bits..., and I need to indicate SAP that use drivers of 32 bits too...

Do you know how can I do it??

One key point --> If I go to configure ODBC throught Control Panel (odbcad32.exe in folder Windows\system32)..., not appear the driver that I need... Then, I execute the program odbcad32.exe in folder Windows\SysWOW64 appear all drivers to 32 bits system, and it's in this place where I create my ODBC connection because the driver that I need appear.

[Former Member]

-

[Former Member]

... ok, I understand.

Other question... If in my test server (W2003 32bits), I have the program run ok, I can connect with my ODBC driver to my external DB without problem..., Would I indicate in my productive server (W2003 64bits) to do the querys to external database throught the connection of my Test Server??...

[markus_doehr2]

> Would I indicate in my productive server (W2003 64bits) to do the querys to external database throught the connection of my Test Server??...

technically certainly possible - but this will imply that your test server is always running and that those connections won't work when you shut it down or if there's a hardware problem.

Markus

[Former Member]

Sure???... That it's a good notice...,

Normally my test server it's allways running like productive server...

Can you indicate how can I do this...??? Please ...,

I would be grateful for it to you very much

[markus_doehr2]

I'd do like

- create a user on the 32bit system

- create an RFC connection on the 64bit system that points to the 32bit system

- create/modify your ABAP program to do the RFC call, I'd do the processing on the 32bit platform and just return the results.

Markus

[Former Member]

OK, I'm going to try this.

Thks very much.

[former_member204746]

in most cases, you will not need an ODBC connection.

what DB do you use for your SAP server?

what is the DB of your external DB?

[Former Member]

Hello Eric.

In my case it's necessary... the external D.B. it's Multibase..., (Transtools Company).

Could I modified anything in the register, in odbc.ini, or in any place in my server..., to get server admit this driver like 64 bits...???...

[markus_doehr2]

> Could I modified anything in the register, in odbc.ini, or in any place in my server..., to get server admit this driver like 64 bits...???..

no.

the driver must be LOADED in the context of the SAP system - which is 64bit, and as said already it's not possible to load a 32bit DLL into a context of a 64bit application.

You may, however, install a second application server on 32bit and use that one to do the connection.

Markus

[Former Member]

Dear Markus.

There is not ODBC driver to my external DB in 64bits..., I check it.

But the ODBC connection run OK in 64 bits... because I have done querys through this ODBC from my server with special program to check if ODBC it's OK or no.

Then I don't understand why if the ODBC it's OK and run in 64 bits, why SAP cannot read this ODBC ....,

It's very easy tell me that I install the 64 bits driver..., but if I cannot get it... what can I do??

[markus_doehr2]

> There is not ODBC driver to my external DB in 64bits..., I check it.

Then you are pretty lost...

> But the ODBC connection run OK in 64 bits... because I have done querys through this ODBC from my server with special program to check if ODBC it's OK or no.

Yes - because your run a 32bit application which can load the 32bit ODBC driver.

> Then I don't understand why if the ODBC it's OK and run in 64 bits, why SAP cannot read this ODBC ....,

A 64bit program (mainly disp+work.exe) can not load a 32bit ODBC driver (a 32bit DLL). If you do a connection test, the program you do that with (the ODBC panel) is 32bit and hence it's working. That's also the reason why you can't do the connection test using the 64bit ODBC panel (when not using the one in sysWOW64).

> It's very easy tell me that I install the 64 bits driver..., but if I cannot get it... what can I do??

contact the database developers - they should be able to recompile their software for 64bit.

Markus

[markus_doehr2]

If you run a 64bit SAP application you need to provide a 64bit driver to make it accessible from the SAP system. The reason is that the ODBC driver, which is 32bit only, can't be loaded by the 64bit application.

Markus