Accessing Oracle db with 32/64 bit client?

[DSauve]

We have a group of users that have a 64-bit commercial application (not JDE!) that requires a 64-bit Oracle database client. These same users have a home-grown application which requires a 32-bit Oracle database client. It is not always easy to control which client will be used, as on a Windows box, by default the first Oracle client in the Path variable will be used for Oracle access - which works for one of the apps, but not the other.

Is there another way that you know of to access JDE data through another method (maybe a web service)? The user would like to be able to send a request with information like an item number, and then have several attributes of that item number returned (e.g. desc 1, desc 2, unit of measure, etc.).

I have not used business services before, but am wondering if this would be a suitable solution to our data access needs.

Thanks in advance for any suggestions.

 

[jdelisths]

Business Services would certainly work, but it may be overkill for just this scenario. If you were planning on using direct database access, why wouldn't the 64-bit Oracle client work with your Oracle database?