Search results for query: *

I can't login to my Windows 2008 R2 dedicated server through RDP, all services are down (websites, etc.) and I just want to restart the box, strangely, FTP is working, any ideas how to restart the server? Don't have a "lights out" facility and the data-center guys are probably only going to...

Hi guys, any way to count different distincts in one query? Sub-queries not supported in my MySQL v4.0.?? I have this: '// Count unique months and years to dimension arrays accordingly SQL = "SELECT COUNT(DISTINCT Month(Issue)) AS mm FROM tbl_Newsletters WHERE Active = 1;" Set rsNL =...

I only use MyISAM for all my web applications, and that should suffice for years to come, so I'm wondering how to disable all other data types from the server, so it starts as only capable of dealing with MyISAM tables. What other benefits there are in doing so, apart from perhaps a greater...

Hi, I upgraded to 4.1 and now can't connect to the server with my usual connection string. I'm using MySQL on Windows Server 2003 STD, and usual use ASP and ASP.NET scripting with it. Also upgraded to connector to the latest version, can connect but nothing else works, what's going on? I had...

Here's my problem, on my Win 2003 Server STD, I run an ADSL connection with a modem, all is fine most of the time, however the connection goes down every 2/3 months for some reason, and when this happens I would like the connection to come back up again automatically. How can this be done...

I'm new in the DBA position recently aquired, and I'm having a few issues with MSSQL configuration and administration. 1. I have created a two maintenance plans, one for system databases and another one for user databases, this plans include things such as, Integrity Checks, Optimizations and...

I'm looking for a snapin or manager to control my remote Windows Server 2003 DNS server. I have a networked workstation (XP) from which I would like to connect to my main WS2003 DNS server and do all work from this workstation, like adding new Internet domains and such. How ca I do this? Is...

Hi all, this one is killing me slowly, and I have read 2 full pages of hold threads on the Auto-Increment issue and nothing. My problem is this: I have a database with a primary key which is also the auto_increment field, this works fine, but I need to know the auto_increment value that MySQL...

Hi folks, I'm beginning to develop a polling system for a web site, the coding is no problem, but my question is in relation to the database design. What would work best: 1. One DB, one table, each row is a poll. 2. One DB, each table is a poll. 3. Each DB is a poll. To help you to help me...

Does anyone knows how to control the startup sequence of services in NT? I'm using Windows Server 2003, and my problem is the following, I want my Internet connection to fire first than anything else, because if it doesn't, my DNS server will fail, and then the SMTP also fails amongst many...

Hi all, I have a little problem that I hope some of you might be able to solve. I want to add a predefined piece of text to a textarea but where the blinking cursor is, and not by the end of it. I have the following: <IMG SRC=&quot;grfx/smilie_01.gif&quot; ALIGN=&quot;absmiddle&quot...

Hi all. I'm developing a small news system, and it's all done apart from the options to go back and forward with records, just like on top of this forums (Prev 1 2 3 4 5 Next) sort of thing. I'm using ASP, developing it with Access for now, but will use MySQL when done. Here's the bit I have...

I would like to dynamically populate a drop down box with all field names from a database, also the value of each new drop down box entry should also be the name of the field, somehow, just can't find a way to do it. Also all searches produced no results. I'm using ASP. Thanks. If you...

Hi, I would like to know what's the equivalent of the HTML <BR> tag to force a new line in a confirm box. I.e. I have this: confirm(&quot;Are you sure? If so go ahead&quot;); But I would like the (If so go ahead) to be in a new line under the (Are you sure?), there's got to be a break...

My web site is a fixed width style container, and I have problems displaying information that exceeds the maximum allowed width for my web site, all graphics go bananas, I understand why, so I'm looking for a wrapping solution to get those long sentences to wrap automatically. I can hear some...

Hi, This one has been giving me some problems, I need a dummy tag, that will do nothing but to act as a container for the class attribute. If I don't ming a break, I use the <DIV CLASS=&quot;style&quot;>whatever</DIV>, this will cause a break, something that I don't want most of the times, so...

I manage to configure MySQL, and I can connect and do all needed operations from ASP.NET, but there are two problems that I just can't get solved. I'm doing all administrative operations using MySQL Control Center. 1. How can I configure MySQL so that databases created from certain users obey...

I used to use IIS 5 Resource Kit Components quite allot, in our old Windows 2000 Server with IIS 5, now upgraded to Windows Server 2003 with IIS 6 and just can't find it anywhere on Microsoft's web site. All my pages that make use of the components error out with the usual can't create object...

I have been experiencing many FTP connection problems since moving to Windows Server 2003. I'm not using the build in Windows FTP service, but another commercial solution, in fact tried 4 different FTP servers including the Windows one, all fail with the same error. First LISTS can't be served...