Recent content by mmemon

Hello, I just joined this organization that had SQLBase bundled with the ADP software. I would like to connect to the database and view the tables and data. How can I do this? I used TOAD in the past for my Oracle db's. I downloaded the GUPTA SQLBase driver pack. Thanks Michele

Hi, Oracle 9i. We are now thinking of Coldfusion calling the rptserver.asp page to process our report. I don't expereince with this but I have been searching the web all morning. Michele

Hello We have a Coldfusion app that we found out can't integrate with Crystal Reports based on the versions we have. So, we thought we would make a call to an oracle stored procedure which in turn would make a call to a crystal report. Can this be done? What would the code look like? And can we...

Hello, Thank you for your reply. I am not sure how I would export the file to pdf. In VB.net, the object model has methods for coding the export to pdf but I haven't been able to find any code for Coldfusion. I found the code for retrieving the file but I am unfamiliar how I would handle after...

Hello, Can you use Crystal reports with Coldfusion. I have 8.5 and we have a coldfusion application that needs to call a .rpt file and export it to pdf. Can this be done?

Hello, We have an application(VB)that when a button is clicked by the user, we want a crystal report to be created and exported to a pdf file and stored in a folder for users to pick up and save to their machine. I am not sure of how much I have to code and how much can be done in the...

Hello, I have Crystal Reports 8.5 developer edition along with the enterprise server. I have many reports that I publish for the staff to access view eportfolio. This is the only way I have done this for our users. We have a new application being built in VB.net. In this application. Here is...

Hi, Thanks K. You know writing a view didn't even cross my mind. I think it is time for a vacation. Michele

Hi Everyone, I have a query that I use in Sql*Plus: SELECT A.PERS_ID,A.LAST_NAME,B.LAST_NAME FROM CNTRCTR A,CNTRCTR_EXT B WHERE TO_NUMBER(A.CNTRCTR _NO,'9999')= B.CLONE_OF AND B.CLONE_OF IS NOT NULL; I need to incorporate the tonumber function and format into the crystal report query that is...

Hi, Yes, I meant to type spfile. Sorry. Well, as an alternative I am using the spool command to write out my error messages. But I woulld like to get the utl_file to work. Thank you Michele

Hi, I didn't edit the wrong file. If anything I edited it as the root user. But I am reading that Oracle 9i uses a pfile instead of initSID.ora file first. Michele

Hi, Yes, I have bounced the server since the entry. But there is no vale for the parameter. I am using oracle 9i, Is this parameter still supported? I am using a tool called webmin to edit the init.ora file and I am signed as root.

Hi Everyone, I have a stored procedure which inserts data from 1 table to another on a weekly basis. If an exception is raised then I am calling the utl_file package to write out an error text file. My problem is:I keep receiving an invalid path error. My database is on Sun Solaris. my...

Hello Everyone, I have created a cron job on my Solaris box that calls a script that is coded to run the exp and import utility. I am exporting 2 tables and importing them on a weekly basis. How do I check if the export was successful or has data? Is there a number that is returned that tells me...

Hello, I need to write a cron job on my solaris machine that exports data from an oracle 8i database on another machine on our network and then imports the data into an Oracle 9i database that is sitting on the machine that is launching the cron job. Can this be done? Where does the export get...