Right now, we recevied some new computers so I had to install ADP Payroll software on their computers first. Within that, it installs ORACLE 8i. After that, I instaleld Crystal Reports 8.0 and had trouble connecting to the ODBC connected to it because it was running XP.. so installed this patch.. and the new p2sodbc.dll file.. a discussion of it can be found here...

Try to create your report with integrated security. Then user's windows login info will be passed to the report. While creating the report ther eis a checkbox secure login or close to that. Check that box. That will force your reprot o use integrated security other than sql authentication. If you have to use sql authentication and dont want to receive that dialog box, you have to write a small application and set the username and password in runtime.

When are you being prompted for the password - is this while using Crystal developer or when users are viewing reports from an application or when viewing compiled report, etc.? Please let me know as that will narrow the range of possibilities. Also, which Oracle driver are you using?

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

the dialog box comes up right. Over ther eit asks you to neter username and password. There must be check box saying that secure logon, or integrated security,
Something in those lines. Check that box. Then you will see that user name and password text boxes are disabled because crystal will use your windows logon username and password for the report. If th user have access then they will get acess to the report.

So with Crystal open, is it prompting only when they refresh the report or when they make changes to a report (such as adding fields, etc.)?

Oracle 8i is the database - there are several database drivers that you can use to connect to it. Most likely either Oracle's native driver or the Microsoft ODBC? When you remade your system DSN you would have selected the driver to use as the first step to creating the DSN. If it's Microsoft or Oracle then it doesn't matter but I've seen other people have problems with other drivers & crystal. Add to that the fact that CR8 has some know bugs when used with Win XP and it could just be a minor incompatibility problem.

Emre - There is no integrated security with Oracle 8i. There's no way around sending authentication parameters - you either have user's enter it manually or you pass it with code.

That is exactly my problem. Whenever I refresh or change values and try to access the oracle database, it prompts me with entering the password... every single time. It's annoying to say the least ... any help would be appreciated...

Under Oracle 8i->Net8 COnfiguration Assistant, when I went in and try to delete an old service name, MARTIN12121, it seems like it cannot be deleted. Pressing "next" repeatedly does nothing .... if I repeat the same procedure under MARTIN, it prompts for confirmation...

The same goes for the testing option... it seems like it left some kind of trace, and after I ran the webfix, it can't seem to erase it's old service name or something...??

When I went into regedit... I searched for MARTIN and MARTIN1 ..

*some background on why it was named: (the two service names I named because it couldn't find MARTIN initially, so I did the webfix from my first post above. So the name was "taken" or something so I had to rename the Data Source name Martin1. And so that is how I keep getting that constant prompt for logon thing is..*

So, I found MARTIN and MARTIN1,... it was under MYCOMPUTER\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI , but when I clicked on MARTIN, I got a popup window that said.. "Error Opening Key".. (X) Cannot open MARTIN: Error while opening key... I can right-click it and try to delete it, but it gives me another prompt that says I cannot delete it either........ AHH! This must be the problem....

Have you tried booting into safe mode and then deleting it? Sounds like either something is corrupted or you have a service or application that is grabbing a connection. Hopefully deleting in safe mode will a) let you delete it and b) identify the process causing the problem because it'll probably throw up an error when you reboot normally and the odbc connection no longer exists.

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples).
Crystal Reports uses a two-pass reporting process to provide greater …

Hello everyone,
Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8.
We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…

This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…