Running BOE XI R2 embedded in a Java (Struts) website for external reporting. Single sign-on. Sometimes a person will log into InfoView (again, with single sign-on, so they are not actually typing a username and password) and a different person's reports will come up. Obviously this is a...
How do I create a SQL Server 2005 database role that has encryption/unencryption permissions? I don't want to make a database User a database owner. Is there a "GRANT" parameter to allow a role to encrypt/unencript
I want to do something like this:
CREATE ROLE db_encryption
GRANT...
We were getting OutofMemory errors in our websphere logs whenever this report was rendered. Changing the settings for the Java heap and restarting the web server seems to have taken care of the problem.
So, not a BOE problem at all, it seems.
Getting an HTTP 500 error when trying to access a parameterized report through InfoView. Looking at the event log there are transport error warnings on the Cache Server and sometimes the WCA. When I restart the Cache Server it seems to fix itself for awhile, then breaks again. I've increased...
We currently have a BOE XI R2 reporting system for our independent clients. They access their reports through a website that has a Web Component Adapter pointing to our BOE Server. This reporting interface is embedded in a Java web application. We're thinking of replacing this with SSRS.
The...
We have an external webserver that connects to our BOE server with the WCA. One our reports has a date parameter. Clicking on the calendar icon works fine internally when accessing BOE directly, but it does not work for our external clients connecting through the web server. This problem...
I have a table that contains encrypted social security numbers and other data. I'm trying to extract these SSNs onto a webpage. I pass an unencrypted SSN to a stored procedure, and the sproc encrypts the parameter, and searches the table for any matches. I come up empty in my search. Upon...
I have code that I cannot figure out why it is not working. Basically it is an ActiveX Script that checks for the existence of a file, and if the file is newly found, set the flag, and send an email. if the file was there previously and still exists, do nothing. If the file was there, but is...
We have BOE XI R2 running internally with a Web component on an external web server. Users connect through trusted authentication.
If I log on to the internal version of Infoview, I can customize my Infoview just fine and save the changes. However, when I log on through the web server using...
Thanks - still haven't figured it out but I'm getting closer - you've pointed me in the right direction. I wasn't aware of the Scripting task that can be in between the source and the destination.
Very new to SSIS, still sorting out how it works. Transfering data from an AS400 to SQL 2005. 2 questions, please:
1) In the Data Flow section, what would be the easiest way to convert an 8 digit number from the AS400 (yyyymmdd) to a date format in the SQL table?
2) I have an extra field in...
Is there a way to pass a userID and password to BOE XI in order to log into InfoView without seeing the Infoview login page? We have a website that external customers log into, and we'd prefer not to have them log in again to view their reports. It'd be nice if we can just have them click a...
Generally, yes. New development - we can access the data in the linked table via VBA, but we still can't simply open the table to view the data - we get the ODBC Call Failed error. This seems to be the only thing we can't do.
We recently installed a new AS400. We have an Access 2000 database that has linked tables from the AS400. We can import these tables through the system DSN, we can write pass-through queries, and we can query the tables using the DSN in Microsoft Excel. The only thing we cannot do anymore is...
Haven't checked any of that - I'm pretty ignorant to the mechinations of Apache. It's an install disk from a Sam's book on Apache2, MySQL, and PHP.
I'll do some digging and get back to you. Thanks.
I had Apache installed on my PC, to run PHP pages with mySQL. Everything was fine. I recently had to re-install the operating system (Windows XP Professional, SP2), and when I reinstalled Apache and started it Apache now takes 100% of my CPU resources. It never did that before. I haven't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.