Link to home
Start Free TrialLog in
Avatar of oceansoo
oceansoo

asked on

Database Logon failed during Application Run time

My web application (developed using ASP) want to call out a crystal report. RAS return a Database Logon prompt page to ask for database username and password with a fixed server location. The prompt page failed while i tried for report with database location pointed to Oracle9i Database, i was asked to reenter. The same thing work perfectly for MS SQL SERVER 2000.

I made no changes to my ASP source codes, just reset the database location report file using crystal Report 9 Advance Edition. I can view the report during design time.

My Application Environment that cause the problem :-
Web Server
   OS: Windows 2000 Server
   Databasse: Oracle9i database Release 1
   Report: RAS-SDK
RAS Server
   OS: Windows 2000 Server
   Report: Crystal Report 9 Advance Edition, RAS

The prompt page information for MS SQL Server database:-
Server Location : <MS SQL Server name> (no a form field)
username : [username] (a form field)
password : [password] (a form field)

The prompt page information for Oracle database:-
Server Location : <oracle database name> (no a form field)
username : [username] (a form field)
password : [password] (a form field)

Please advice. Thanks.

ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of oceansoo
oceansoo

ASKER

Hi mlmcc,

Thanks for the url, but the sample utilising the RDC instead of RASSDK. I am using RASSDK, do you have any sample reference for that, which may call up report link to Oracle9i database?  

Thanks for advice.
Hi mlmcc,

Thanks for the url, but the sample utilising the RDC instead of RASSDK. I am using RASSDK, do you have any sample reference for that, which may call up report link to Oracle9i database?  

Thanks for advice.
How are you passing the logon information?  

A recent question was solved by inserting an ASCII 10 (VB chr$(10)) before the password.

If I can find it I'll provide the link.

mlmcc
This question has been classified as abandoned.  I will make a recommendation to the moderators on its resolution in approximately one week.  I would appreciate any comments by the experts that would help me in making a recommendation.

It is assumed that any participant not responding to this request is no longer interested in its final deposition.

If the asker does not know how to close the question, the options are here:
https://www.experts-exchange.com/help.jsp#hs5

mnye
EE Cleanup Volunteer
May have solved it.

mlmcc
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: mlmcc {http:#7729919}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

mnye
EE Cleanup Volunteer