Home » Developer & Programmer » Reports & Discoverer » Oracle reports and SQL SERVER 2000
Oracle reports and SQL SERVER 2000 [message #167603] Fri, 14 April 2006 08:12 Go to next message
kal_youssef
Messages: 25
Registered: September 2005
Location: canada
Junior Member
Dear Members

Im trying to connect to a sql server database using oracle reports 9i DS. The steps i do are as follows:

1. Go to ODBC and create a new system DSN for sql server
2. Ok then i run oracle report wizard and put in the connection to the database as JDBC Query and use the driver type as jdbc-odbc
3. I create the report and run it which is ok

The problem happens when i try to run the report on the web layout it gives me

REP-0069: Internal Error java.lang.NullPointerException:

I know this is a connection problem because when i go to file connect
There is no option to choose the odbc type.
Has anyone encountered this before? If so then please tell me how to overcome this issue.
Thank you in advance
regards
K.

Report message to a moderator

Re: Oracle reports and SQL SERVER 2000 [message #167970 is a reply to message #167603] Tue, 18 April 2006 03:28 Go to previous message
kal_youssef
Messages: 25
Registered: September 2005
Location: canada
Junior Member
Hello oracle buddies

Im glad to say that i solved the problem.
What you do is once you have created a report is save it in what ever format you desire i choose .jsp so i can publish it later.
Then yes if you try to run it again using the web layout youll get the error mentioned above.
So to resolve this issue all you do is just close report developer and just reopen it and choose:
1. Open existing reporting
2. run web layout

You will be prompted for the login information
Type everything in and voila it works.
regards

Kal

Report message to a moderator

Previous Topic: Placeholders and Summing Data
Next Topic: Avoid blank space of title on second page of report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 11:30:58 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.