Search results for query: *

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...

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 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...

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.

Hi, I am a beginner. Can anyone please give me a tutorial guide of installation of php 5.2.3 to IIS 6.0 and the configuration in Win 2003? 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...

How do I delete records in the destination file in SSIS using BI Development Studio?

I have created a package which export a table in SQL2k5 to a dbase file. I created a SQL native client and a MS Jet 4.0 OLE Jet DB provide. I make Source point to SQL native client connection manager and OLE DB destination point to MS Jet 4.0 OLE Jet DB provide connection manager in Data Flow...

In SQL2000, when I do import/export, there is DBaseV in the destination. In SQL 2005, there is such selection. How can I make DBaseV export in SQL 2005? Thanks.

I use a trigger which I update a linked server and this is working very good in SQL 2000. But after I migrate the database to SQL 2005. The trigger is not working with linked server any more. I remember I need to start the distributed transaction coordinator in service manager. But I couldn't...

Hi, I got the following error whenever I open up a mail merge document witn Word 97 in Winxp: "Doc1 is a mail merge main document. Word cannot find its data source, access.mdb." With two option, "find data source" and...

Hi, I have updated my Win98 SE with MDAC 2.7 program and checked it with component checker (cc.exe) from Microsoft website. Found a warning that is as following: Item Name,Item Type,ErrorString,Status MSADCO.DLL,COM,Unknown Class ID =...