Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

CREATE ODBC IN SERVER 64 BITS

Former Member
0 Likes
414

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.

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.

1 REPLY 1
Read only

Former Member
0 Likes
386

-