Could not load the DLL sqljdbc.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.)

you have a SQl Server 2005 database.You have created your RCU in the database but while creating domain you are getting following error

Component Schema=SOA Infrastructure
Driver=weblogic.jdbcx.sqlserver.SQLServerDataSource
URL=jdbc:weblogic:sqlserver://localhost:1433
User=DEV_SOAINFRA
Password=*******
SQL Test=select count(*) from dbo.schema_version_registry where owner=(select system_user) and mr_type='SOAINFRA' and version='11.1.1.4.0'

[FMWGEN][SQLServer JDBC Driver][SQLServer]Could not load the DLL sqljdbc.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).
CFGFWK-60850: Test Failed!

Surprisingly other schemas are working fine but the issue is coming only from soainfra schema.





The main reason for this issus is that you have not configured XA for SOA Server.

XA configuration is required to start the soa infrastructure on sql server 2005.

You can follow the document to resolve this issue.

21.2.4 XA Configuration Required to Start the SOA Infrastructure on Microsoft SQL Server 2008

http://download.oracle.com/docs/cd/E15523_01/relnotes.1111/e10132/soa.htm#CDEIFEAC

Sometimes however for 32 bit windows sqljdbc.dll doesn't work.

In that case copy the X64sqljdbc.dll and rename it to sqljdbc.dll and check this issue.This should probably resolve the issue.