Dear Members, We tried the following: 1. We Coded Servlets using IBM Connection Manager(com.ibm.servlet.connmgr.IBMConnMgr) and DB2 as Database using JdbcDb2 Connection Pool(which comes along WebSphere), it could fetch data from the remote Database which is in our OS/390 Mainframe Machine with UDB Connectivity from IBM . 2. Then we tried the same servlet using native Java Connection for SQL which came with JDK1.1.6, using JdbcOdbc Connection Bridge and used the same database(DB2) it worked fine. 3. Finally we changed the Database from Db2 to MS SQL Server Database with the same servlet, using both IBM Connection Manager with JdbcSQLServer Pool and native Java SQL Connectivity it didn't work. The Error Message we got was :" No Data source Name Found and No default Driver Specified " ( Note: The same code worked as a Java Application, this ensures that Our odbc Driver setup is working fine ) So we came to conclusion that Websphere doesn't work with JdbcSQLServer Connection Pool(which came with Websphere) and also with the native Java SQL classes. We are looking for the solution for servlets to workwith MS-SQL server . It will be appriciated if any of the forum members could help us in this problem/situation, Regards Raghu =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff JSP-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
