Skip to Content
Former Member
May 06, 2009 at 07:30 AM

ODBC in server 64 bits


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.