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.