Could not find stored procedure 'master..xp_jdbc_open'

Hi All,

I am using WebSphere 5.1 and try to setup Datasoruce connection in WebSphere

I have selected "Microsoft JDBC driver for MSSQLServer 2000" from the picklist in WebSphere Admin Console.

The 3 jar files below are referenced correctly as well:

${MSSQLSERVER_JDBC_DRIVER_PATH}/msbase.jar
${MSSQLSERVER_JDBC_DRIVER_PATH}/mssqlserver.jar
${MSSQLSERVER_JDBC_DRIVER_PATH}/msutil.jar

However when I run a testconnection, it fails with this error:

Test Connection failed for datasource celio on server server1 at node workstation_50 with the following exception: java.lang.Exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'master..xp_jdbc_open'.. View JVM logs for further details. Null

My Datbase is MS SQL 2000 !

Is it a bug?

Any help is appreciated.

Thank you

Ramin

Hi there,

Perhaps this article could help with your problem:

http://www-1.ibm.com/support/docview.wss?uid=swg21168355

Hope that helps a bit, but sorry if it doesn't|||

Thank you

I have followed that reference, after applying the sqljdbc.dll and running th script, I have got this error when run the testconnection: I restarted WS and MSSQL Server both

Test Connection failed for datasource celio on server server1 at node RBONAKDA03 with the following exception: java.lang.Exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot load the DLL sqljdbc.dll, or one of the DLLs it references. Reason: 193(error not found).. View JVM logs for further details. null

|||Hi there,

Apologies for my late response.

Is the DLL registered on the database server? From things I have read, the DLL needs to be placed and registered on the server on which SQL Server runs.

Other than that, I can't think of anything. Sorry.
|||

There seems to be a slight confusion here.

It sounds like you are trying to configure Sql Server to use the Microsoft 2000 JDBC driver but then you are referencing the 2005 JDBC driver.

For a new application I would recommend that you use the 2005 Jdbc driver:

http://msdn.microsoft.com/data/ref/jdbc/

We have just shipped the June community tech preview of this driver if you want to play with the latest and greatest:

http://www.microsoft.com/downloads/details.aspx?familyid=f914793a-6fb4-475f-9537-b8fcb776befd&displaylang=en

To set up distributed transaction support follow the instructions on the xa_install.sql file found ont the Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\xa directory (or sqljdbc_1.0\ directory for the RTW driver). To set up Websphere to work with the 2005 driver you can:

1) Add a new provider from the Providers menu under JDBC Providers
2) For path specify the path to your sqljdbc.jar
example : C:\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.1\enu\sqljdbc.jar
3) For implementation class name use the following.
com.microsoft.sqlserver.jdbc.SQLServerXADataSource

4) One you saved the provider choose the datasources menu and create a new
data source
5) You can use the generic data store helper class provided by Websphere AS
(com.ibm.websphere.rsadapter.GenericDataStoreHelper)