Showing posts with label Oracle Reports. Show all posts
Showing posts with label Oracle Reports. Show all posts

Monday, April 5, 2010

Connecting SQL SERVER 2005 from SQL Developer 1.5.1

The Following Steps would explain the Setup

Step1: Download the "jtds-1.2.5-dist.zip" from http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zip/download

Step2: Open the Sql Developer
Tools -> Preferences -> DataBase ->Third Party JDBC Drivers
and add the "jtds-1.2.5.jar" which you have unzip from the step1. and OK.

Step3 : Right Click and select the "New Connection" at the "Connection" Node.
You could see sqlserver and sybase tabs have come. Click sqlserver tab. and fill the required
info. and click test. You may get the following error.
"I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property."
To overcome:
Copy the file 'jtds-1.2.2-dist\x86\SSO\ntlmauth.dll' from the unzipped JTDS and paste it at
sql_devloper_home\jdk\jre\bin.
Then restart SQL Developer.
Now you are done.
References :
http://www.oracle.com/technology/oramag/oracle/08-may/o38sql.html
http://www.dbforums.com/microsoft-sql-server/1612362-java-sql-sqlexception-i-o-error-sso-failed-native-sspi-library-not-loaded.html

Thursday, July 9, 2009

E-mailing the Oracle Report in PDF Format not in EPS

Once the oracle report is deployed at the customer site and the end user wants view the report and send the report as pdf format via e-mail.If we do not do the following setting then the end user will be sending the report as ".eps" format.
To send it as pdf format you just have to
Open the properties of the DESFORMAT under the System Parameters node and set the initial value as PDF. Now you would get the report e-mail format as "PDF".