Search results for query: *

Windows 2K Adv Server (Clustered, Fully Patched) Sql Server 2000 Im trying to prepare to install SQL Server Reporting Services on both nodes of my cluster. According to the documentation, Microsoft .NET Framework is supposed to be resident on the machine. It doesnt seem to be there. I have...

Dreamweaver MX v6.1 w/ updater Windows XP SP2 Webserver = IIS 5.0 Document type: ASP VB Script I have a page built in dreamweaver that i need to connect to a SQL Server database table. I have the database connected using an ODBC connection and i can see the tables in the Database Panel. However...

Crystal Reports 9.1 SQL Server 2000 8.00.760 on W2K Adv Server We have recently begun selling product over the internet. Some people chooose to have their purchase mailed to them, others come and pick it up. In the live.audit.dbo table there is a transaction type "H" for held, "R" for...

Dreamweaver MX 6.1 SQL Server 2000 Hi all. I set up a web page to search our customer comments database. I wrote a simple SQL query to select the recordset. I have a conflict between the date in the database and the date variable in the webpage app. Here is the code: SELECT * FROM...

Windows 2000 Server SP4 I have set up a W2K server. It is a domain controller, is running DNS, DHCP, RRAS, IIS, and IAS. I wrestled with trying to get the server to share its internet connection with clients through RRAS using two NICs, one on the INSIDE Lan, and the other on the outside...

Im trying to do a fairly simple update where i have to join two tables, and I keep getting the error "The column prefix event2 does not match with a table name or alias used in the query" I know I just have a problem with the syntax of the query, and would appreciate any advice.. Here is the...

CR 9.2 / CE 9.2 / SQL Server 2K SP 4 / Win 2K Adv Server Hi guys. I have another one of those "how the heck do you track this" problems. I have a fairly complex report I designed called our Event Sales Report. It pulls from 4 different tables in our SQL Server Database. I need to add some...

Windows 2K Adv Server I have set up a test network at home, with a Windows 2K Adv Server, and 3 clients, all running XP Pro. Everything is working perfectly, except that the clients are getting the wrong subnet mask from DHCP. The subnet is 10.0.0.x. I have the subnet mask set to 255.255.255.0...

Hi All.. Im operating on a Windows 2000 Advanced Server, 2 node cluster. I need to set up SSL under our IIS platform, and I am a little leary of making changes to IIS. Our entire retail software is dependant on IIS. Previously when I have made minor changes to IIS on a node, the service would...

I have a SQL database field (SQL Server 2K SP4) that contains event codes, for example "TM0601". I need to run a query to update the field and change the "TM" part to "CM" for all records in the table.. I cannot for the life of me come up with the simple code for this, even though I have done it...

I had sort of posted about this before, but the problem just keeps getting thicker and I dont think I did a good job of explaining it before.. I need 2 new databases that are basically identical to ones that already exist. In the past I have done this through a backup device I created with...

SQL Server 2K Windows 2K Adv Server I have made a backup of a database and am trying to restore it over a training version of that same database. I am using the "force restore over" option, and restoring from a device that is physically located on a local USB drive. When I click start I get a...

cr 9.1 In the record selection formula editor, when I comment out a line using the // operator, and save and close, the commented line has been deleted when I reopen the editor. This makes it tough when testing different criteria in the selection formula. Can anyone tell me if there is a way...

CR 9.1 SQL Server 2K I have an audit table that stores a record including the date and time each time something changes in an order. I need to be able to pull only the record containing the very first entry for an order (the record that was created when the sale was made). This seems liek it...

CR 9.1 MS SQL Server 2K I am designing a report that I would like to have ask for 3 parameters: Begin Date, End Date, and Year of Comparison. The report will summarize the deposits received in the current year (using Begin Date-End Date). I would also like it to pull the exact same period in...

MS SQL Server 2000 CR 9.0 sp3 CE 9.0 sp2 Suddenly I have begun getting this error in CE: OPEN ROWSET CE doesnt give much more detail than that, When I open the report in CR I get the following: Error: OPEN ROWSET Query engine error: '21000:[microsoft][ODBC SQL Server Driver][SQL Server]...

I have an application that occasionally needs to install an updated activeX control. Each time this happens, I have to change users from standard to local administrator, let the controls install, and then change it back. How can I allow the machine to install these updates without giving full...

A lady brought me a HDD with two operating systems on it. SHe orginally had Windows 98 on it, and she tried installing XP as a dual boot config. After installing XP, she could not boot from it again. She gave me the hard disk, and wanted me just to pull all of her Word files off of it for her. I...

CR 9.0 MS SQL Server 2000 I am apparently short on knowledge of how to use the main report parameters in a subreport. I think I'm getting flogged by the table linking too, but I want to be sure I am using the parameters correctly. My main report asks for a begin date, an end date, and a "run"...

Hi all, (CR 9.0 , MS SQL Server 2k) I have a stored procedure that is the datasource of a subreport. THis datasource used to sum amounts for cash, checks, Mastercard and Visa. I have to change it to lump all the credit cards in as a single sum. I changed the SP to do this, but the field I...