Running Java against an ODBC source on a SBS 2008 server

[Neil Barton]

I am working with a client using the Sage accounting package and I have
written a java program which runs against that database using the ODBC driver
supplied by Sage. It works in a 32 bit environment. It works in a 64 bit
Windows 7 environment. However, when I run it on the Small Business Server
2008 I get the error message: "Cannot connect to jdbc:odbc:BITSSageSrc error:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified".

If I go into control panel and ODBC sources I cannot see the odbc driver
from Sage as it is not 64 bit. Going into C:\windows\syswow64 and running
odbcad32 enables me to add the 32 bit driver as a data source and I can see
it listed in System DSN. This works at the client site where a java client
running on a 32 bit XP system can connect to the ODBC driver, however, when I
try to run the program on the server itself it cannot connect.

Because it works in a 64 bit Windows 7 environment I don't think it's simply
a 64 bit issue. I think it might be a security policy issue but I don't know
where to start to look for such a problem.

[Pak-Ming Cheung - MSFT]

This is duplicated as one of the earlier threads dated on Nov 22.

I understand that you may not get the help from the previous thread in time.
I am sorry about that. Actually, you can try our forum, which can usually
provide a faster response, next time.

The forum is at:
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/threads/

Thanks,
Ming.
WDAC Team, Microsoft.
P.S. We recommend customers to use the forum to ask questions in the future,
where you can obtain a faster response (Forum is at:
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/threads/)