Hello Peers - I have been facing an issue while configuring the SQL Server DB source in DAC. Please see all details below:
As soon as I encountered the issue, I have checked all places necessary to ensure they are in place:
Steps I have ensured to see all files are in place:
1. To handle DAC connection issues as mentioned below, the following entry need to be add in config.bat for the batch variable SQLSERVERLIB
.\lib\sqljdbc4.jar
Eg: set SQLSERVERLIB=.\lib\msbase.jar;.\lib\mssqlserver.jar;.\lib\msutil.jar;.\lib\sqljdbc.jar; .\lib\sqljdbc4.jar
2. General errors: This server version is not supported. The target server must be SQL Server 2000 or higher or MESSAGE:::MSSQL driver not available!
EXCEPTION CLASS::: java.lang.IllegalArgumentException
Download sqljdbc4.jar file from the below link and place it in the \orahome\10gR3_1\bifoundation\dac\lib folder
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
3. I replaced the DAWSystem.jar file too with the latest one from Oracle (Nov 14):
Could you please share your thoughts on where I am making a mistake? Appreciate your support.
Thanks.