Search results for query: *

i'm doing some development work on an application server (Win2k3) and a web server (Win2k3). My application that runs on the app server looks for a certain virtual directory in IIS on the web server. one day the app could no longer 'see' the VD on the web server and the company hosting my...

strange thing.... when i go to open Word XP, it now begins the install for FrontPage. it just started doing this. i've gone into File > Options and set the File Type (.doc) to open with Word but it still tries FP. Any suggestions?

Ok, I'm trying to figure out how to get ASP.NET installed on my XP Pro. When i go to Add Windows Components i don't see Application Server listed so that I can check off the ASPNET. Is the Application Server option something that would normally have been setup during the initial install of my...

Trying to install Sybase standalone 6.x on a Windows XP machine and when i run the setup.exe file I get the error: 16 bit subsystem. Something about the autoexec.nt file is not supported on this system, blah, blah. This is an NTFS volume. Sybase was installed before but i uninstalled it and...

One of our servers has SQL 2k but all the servers registered are registered as named instances from other servers and there is no default instance (local). How do I now create a 'local' default instance? Rob

I have 2 fields: Begin_Date and Thru_Date I need to pull records only where the current date (getdate?) is within the range of the Begin_Date and Thru_Date. (01/01/xx thru 12/31/xx) The Thru_Date is never prior to the Begin_Date. What is the best way to structure the SQL stmt to do this...

Can anyone tell me where i can download the ODBC drivers for ASA 6.x? I don't need the software just the drivers as I'm trying to connect to a ASA db. Rob

I've had a wireless home network for a few years now using laptops but recently when i tried putting a wireless card in my pc (Win XP), the card installs but won't connect to the router/internet. I can use a network card and physically plug it in with cat5 cables and it works just fine. Yes...

I'm hoping someone can shed some light on this. I'm trying to setup a remote ODBC connection on my server to a SQL Server 2000 server that uses MSDE 2000 and runs on a Windows Server 2003 (SBS). I have asked the client to open his firewall on the Server 2003 to allow my server range of IP's...

I'm trying to get the current system date without the time. I know I can use GetDate() but I don't want the time portion. Isn't there a separate function just for date or am I going to have to use the convert syntax to pull it out? What would the syntax be?

Is it possible to configure a remote SQL Server 2000 for replication via having it registered by its IP address in my Enterprise Manager OR do I need to physically remote in to that server and use it's Enterprise Manager to configure replication? I need to set it up as a Publisher/Distributor.

I'm trying to create a remote ODBC connection to a Win Server 2003 that has an MSDE db on it but the db isn't installed as an instance, otherwise i think I could create ODBC using IP\instancename. I have the IP to the server and can successfully remote in to the server but when setting up my...

What are the ramifications or consequences, if any, of backing up all of your db's (.mdf & .ldf) as part of the entire server backup (Veritas) instead of using Enterprise Mgr to backup your db's independently of the server backup? With server backup you can still restore your db but i would...

using sql 2000, what is syntax to grant ALL permissions to a custom db role? I want to grant permissions on all tables and objects without having to select them individually. Thx.

I'm trying to write a query (in sql view) to find any existing characters outside the 65-122 range. Here's what I have so far but i get no results: SELECT tblMember.MemberNum, tblMember.LastName, tblMember.FirstName FROM tblMember GROUP BY tblMember.MemberNum, tblMember.LastName...

I have a stylesheet.css from my site and I've been trying to go through it and find each of the class/styles (whatever they're called) on the site(html) or in the .cfm's but can't find them all. I'm looking for ones like .ERSNavBar, .ERSHeader TD A:link, .EToolBar, ButtonBar3, etc. Shouldn't I...

I have a field that was incorrectly set as a number field then data was put in that field, needless to say numbers like 219615 ended up like 219,615. Question is what is the syntax to go thru and update each number in those fields so the number looks like 219615? I plan to change the field...

Does anyone know what the error message "ORA-00920: invalid relational operator" means and what I can do to fix it?

I have 2 computers networked together at home. I have a Win2k desktop that my printer is physically hooked to and a WinXP Home laptop that is connect via wireless link. When i first setup my wireless link laptop i was able to browse and setup the printer from the Win2k pc and print to it. All...

Is there a way in excel to create a button or something that once pressed it would clear the contents of a specified range of cells? Say if I had data: A B C D E 1 5 4 12 1 3 2 3 0 0 0 0 3 3 6 1 0 0 4 1 2 5 0 2 5 2 1 7 9 3 Now instead of having...