on 01-31-2006 5:36 AM
Hello,
I'm trying to create a SQL server datasource in Visual Administrator, when I get this error while testing an sql statement.....
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_open (0) returns -3
My DTC service is started and I'm not sure what else could be the problem. Could anyone help me resolve this issue?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sudhakar,
from the error message, I speculate, you are trying to create a JDBC 2.0 DS?
Until now, I just used JDBC 1.x DSes, because I don't need 2PC and XA transactions.
Could this be a solution for you too?
Regards
Gregor
Thanks for the tip, but I intend to use JDBC2.0 with XA.
If anyone has any clue about the problem I described, please help me.
Hello Sudhakar,
This is database specific error and it has nothing to do with the NetWeaver Server. Try to look for help in the MSSQL forums. I attach an article about this problem that I found:
http://knowledgebase.datadirect.com/kbase.nsf/ce24d9443437511f85256e57006bfe2a/f9b6b90e5d3a802285256...
I hope it can help a bit.
Best Regards
Vyara
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.