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

Thanks for the replies guys! Ill try a these suggestions out today. Havent used DISTINCT COUNT cuz im not really after a count. I have tried using both a running total and a sum function, but get the same kind of whacky results either way.

Excellent suggestions, thanks to both of you!

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

oops sorry ... php

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

Nevermind, figured it out. Had an extra fwd lookup zone on the local dns server that contained wrong record info and deleting it fixed the problem.

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

Harkness, the code you gave would simply set every field in the CLIENTS table = to Tom Jones. Is that really what you want to do? You can find out column names by using sp_columns TABLENAME in the query analyzer.

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

Windows XP Pro definitely does not come with a POP3 server. Im not sure that Server 2003 does, either, I havent used it. I would be surprised if it did, since that would cut into sales of Exchange Server. There is a pretty cool free mail handler available called MailEnable...

Do you have any other servers on your network? It sounds like you don't have a domain controller defined. If there are no other servers on your network, did you run dcpromo and get AD all set up? If not, definitely check it out...

Thanks for the reply. Actually I figured it out. It was one of those "couldn't see the forest for the trees" deals. I just deleted the scope and recreated it, and changed the mask, instead of accepting the default.

OK, after more research I know whats causing the problem, I just cant fix it. the basic idea is this: sum(eventseat.price) where eventpaid.buyer = 'A' and (eventseat.orderid = eventpaid.orderid) table EVENTSEAT is a one-to-many relationship with table EVENTPAID. I believe this is causing it...

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

Sampko, Many ISPs will not allow you to relay mail on a smtp server other than theirs unless the mail is coming out of a static IP address. Is yours static? If it is, read through the logs to find the exact error codes for the dumped mail. Google the error messages. IIS gives pretty good...

Theres quite a bit here left for guessing. Right off the bat I would say for using your local applications, just log into your laptop on the <local> domain, which usually says <This Computer> after it. At your log in box where you press CTRL-ALT-DELETE to log in, you should see three boxes. THe...

Further Clarification... "ipconfig /all" on the server says it is operating in the 255.255.255.0 mask. I cannot find anywhere on the system where the dhcp snap-in could be pulling that other mask from. I have 4 ip addresses configured on the same NIC (for IIS websites) but they are all set up as...

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