SQL Server 2008 error

Posted by Yrajudba under Sql Server on 8/23/2011 | Points: 10 | Views : 2048 | Status : [Member] | Replies : 1
HI,

after restoring a database, i logged in to application and received the following error:

error:

Failed to create the XA control connection. "Could not find stored procedure 'master..xp_sqljdbc_xa_init_ex'."

can anybody help me onthis

Thanks in advance
Raju




Responses

Posted by: Vuyiswamb on: 8/23/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
check if the database restore was successfull and make sure that you default to the correct database.
http://www.senthilb.com/2010/01/how-to-make-xa-datasource-work-in-mssql.html

http://eduardosanchezros.blogspot.com/2011/04/using-jboss-xa-transactions-within-sql.html

Thank you for posting at Dotnetfunda
[Administrator]

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response