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 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 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...
I am designing a report which need to take parameter input by user when the report is open. Can anyone please tell me how to do this? Using MS SQL 2005 report. Thanks.
How do I start the IIS service in win 2003? I tried to do it in the service and it is running but when I tried to put a htm under the c:\inet\wwwroot\test.htm and type
http://server/test.htm . It gives "service unavailable". Can anyone please help? Thanks.
I am running SQL 2005 trigger and update the table in remote linked server. This is working perfectly when the firewall is off. However when I turn on the firewall, it won’t run any more. I need the firewall on for the security issue. How can I run this trigger with firewall on? Thanks.
I am running Chinese Access 2002 and found that whenever I tried to input
characters in form, query, table and etc..., the Chinese input is selected
instead of English. In the same machine, I got English input defaulted in
word and excel, no problem. The language in control panel is selected as...
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.