Question:
At a client of ours that uses SQL 2005, we created reports and placed these reports into their SharePoint site. So, when they click on the tab labeled “Reports”, they see our reports.
Yesterday, their SSL certificate expired. Now, when they click on any of the reports in the tab, they get a screen with an [...]
Question:
I am working on Crystal Report calling from VS 2005.
We have list of Drug images in a folder. -> Filepath of the drug is stored in SQL Table.
I need to display DrugImage and DrugName in a Crystal Report.
Issues
1) DrugName, File Path of Drug Image is stored in SQL Table.
2) Report is called from VS 2005 [...]
Question:
I have two report files developed from VS 2005 – Crystal Report.
In Report 1 ’s REPORT HEADER – I need to integrate the Report 2.
On proceeding Insert -> SubReport – > Attaching Report2
values are not populating in the Sub Report 2.
Solution:
How are you calling the report? Where is your code?
If the subreport requires logging on [...]
Question:
Hi experts,
here is scenario
Environment: Oracle 10g 10.2, Windows
we have two DB servers running at remote locations connected via link
we have to insert data to a table in site B upon insertion/updation on a table at site A. ideally we should have defined a triger upon table of site A which in turn do further insertion [...]
Question:
Trying to exclude the row where A.sku=B.ordersku when the rentaldate is a specific value
SELECT * FROM dresses as A LEFT OUTER JOIN orders as B ON A.sku=B.ordersku WHERE A.occasion like ‘%Girls Night%’ OR A.occasion like ‘Girls Night%’ OR A.occasion like ‘%Girls Night’ AND A.dresssize <> ‘ ‘ AND EXISTS
(select *
from orders
where B.rentaldate NOT LIKE ‘2010-03-09%’)
Solution:
If [...]
Question:
Is it possible to use sql (in Oracle10g ) to have a date range that goes back to the last 2 months whenever the statement is ran; i.e. if I ran the sql on march 10, I would get results for the full months of jan & feb and if I ran it in july [...]
Question:
Hi Experts,
I reinstalled Oracle 10g client (with admin privilege) in my machine. But after that I couldn’t connect to toad. When I try to connect to the db with toad I am getting the following error message.
ORA-12154: TNS could not resolve the connect identifier
Can anybody help me in this?
Thanks
Dileep.
Solution:
Set TNS_ADMIN variable in the Registry that [...]
Question:
Does anyone knowwhat might be occuring here. Could it be an internal bug or soemthing with ode below.
I am uploading an XML text file over the web using MOD_PLSQL with some diacritics like
ALT+0224
ALT+0232
ALT+0225
one tag has “new word àèáñ”
MOD_PLSQL uploads files using binay by default into DOCUMENT_TABLE.
The binary file seems to be oK with diacritics in [...]
Question:
msiban2 0770 nat3700 error -204 with sqlstate 42704 from call to db2
db2 v4, ibm 390
Solution:
ok
are you sure you are working against the same db2 subsystem both in online and batch?
are you sure you are using the same user to run this in online and in batch?
Question:
Hi Experts,
I got a new computer that has Windows 7 64 bit Home Premium operating system on it.
I went to the oracle download page located here
http://www.oracle.com/technology/software/products/database/index.html
On my old computer I had 10g Express edition but when I looked at the system requirements page it didn’t list windows 7 as a supported operating system, so now [...]