How do I connect to SQL Server 2008 using GoAnywhere?

[Support_Duane]

GoAnywhere currently (as of version 2.1.0) bundles JDBC drivers for SQL Server 2005/2000. We are in the process of bundling the JDBC Driver for SQL Server 2008 in the next release. Until then, if you need to connect to a SQL Server 2008 database –

• Download the JDBC Driver for SQL Server 2008 from the Microsoft’s web site, http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en. This URL may change down the road, in which case make sure to download the product, Microsoft SQL Server JDBC Driver 2.0.
• On the EULA (End User License Agreement) page, you will have options to download either the Windows version of the driver (exe) or the UNIX version (tar.gz) of the driver
• If you are downloading from a Windows PC, download the Windows version
• Install/uncomress the downloaded file
• Stop GoAnywhere service/subsystem
• Navigate to the directory where you have installed/uncompressed the new driver
• Navigate to the sub-directory, enu.
• Copy the file named sqljdbc.jar (DO NOT use the sqljdbc4.jar) to the system where GoAnywhere is installed. The location to copy is [INSTALL_DIR]/WebRoot/WEB-INF/lib. Where [INSTALL_DIR] is the directory where GoAnywhere is installed. There is already a file with the same name under this folder. If you want to be extra cautious, backup the existing file to a different location before overwriting it with the new file.
• Start the GoAnywhere service/subsystem
• Now create a resource using the pre-listed driver SQL Server com.microsoft.sqlserver.jdbc.SQLServerDriver, which will use the new driver we have copied in step 8.

NOTE: The new driver also works with SQL Server 2005 and SQL Server 2000.

[Support_Steve]

The JDBC driver for SQL Server 2008 has been bundled with GoAnywhere version 2.3.0.

For more information about upgrading GoAnywhere please refer to the following topic:
http://www.goanywheretoday.com/forum/viewtopic.php?f=19&t=81