Here's what we've done so far:
1. Copied the jdbc driver files (msbase.jar, msutil.jar,
mssqlserver.jar) to the lib/ext folder in the EAServer directory.
2. Created a new data source in the Sybase Management Console. Entered
in the usual settings for server name, database name, etc.
3. In the Data Source Driver tab, we put in
"com.microsoft.jdbc.sqlserver.SQLServerDriver" for the JDBC Driver
Class. Left the other two settings (JDBC Data Source Class and JDBC/
XA Data Source Class) blank.
4. An attempt to ping the data source resulted in an error. Here's
the first line in the easerver logs:
ERROR btpool0-1 [DataSource:OCS] The data source '' is missing
configuration for a DataSource class or Driver class.
... and from the stack trace:
com.sybase.djc.DataStoreException: Connection Failed:
java.sql.SQLException: Unable to obtain connection from the data
source 'OCS' due to missing DataSource class or Driver class.
5. I think we need to put in a value for "JDBC Data Source Class" to
resolve this issue but we don't know what to put in. There's no
equivalent of this field in EAServer 5.3 so we're pretty clueless.
Hope someone can help. We've looked at tons of documentation so far
and yielded nothing.