Recent content by supernova122

May be I should give an example. Say I have a product class and I use product table to store the attribute and another class supplier and I use supplier table. Now I want to store the relationship between product and supplier. Say the relationship is product is supplied by many suppliers and...

I am developing asp.net using c# and SQL 2000 as backend database. I would like to know what is the best practice for class relationship implementation. Do I store the class in a Business Object table and the class relationship in a separate Relation Object table? What is the pros and cons? Or...

I got 4 sql2k5 servers with service patch version as following: Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) Microsoft SQL Server 2005 - 9.00.2153.00...

I have installed SQL 2005 reporting services and I configured it using Reporting Services Configuration. Now I tried to access to report manager using http://servername/Reports with login I used to start reporting services. It doesn't work and keep prompting me for login and password. But no use...

I am installing sql 2005 server and report services and receive an error "The setup has encountered an expected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation." Then sql server get installed but not reporting services. Please...

I have made a report using Business Intelligence Development Studio in SQL2005. When I deploy that report the report server, I got the error: **************************************************************************************************************************** A connection cannot not be...

I got it. By using control panel add/remove program. Thanks.

How do you uninstall SQL 2k5 report service/server? Thanks.

I have installed MS 2005 report service. I checked the IIS configuration and the default web server started and checked Report Services Configuration Manager and report server status is running. However when I go to http://servername/reportserver , it said Services Unavailabe ? Can anyone...

I have worked around the problem. By adding the following code to load form event: Me.AllowAdditions = False and set it to right for unload form event. Thanks.

I figured out this problem only happens when I delete the last record. Any help? Thanks.

I added me.requery at the end of code. After I press the delete button, the empty record is shown in the form and when I try to go to previous record, it gives me a msg window as following: Update or CancalUpdate without AddNew or Edit. After I click the OK button, it stayed in the same form...

I got 3 records in a table and I have a form where the source is based on this table. Now I created a delete button from toolbox wizard and it should delete the current record. If I press that button, the current record on the form is empty out instead of deleted. After deletion and refresh...

I have turned on firewall in windows 2003 and allow exception. The exception include file and printer sharing, msdtc.exe , port 1433, port 2008, remote desktop, sqlserver.exe, sqlbrowser.exe and snmp.exe . Now when I try to open the mapped drive to folder in the win2003 server, it failed and I...

To be more specific,I want a pop-up window to ask user to input a parameter when I am a report and this parameter will filter out the data. Say, when I run a product sales report, a pop-up window can ask me for which state and I input California. So the report only shows California sales...