Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dalec
  • Content: Threads
  • Order by date
  1. dalec

    Count in SP different from hand written (same criteria)

    Strange issue. I have a sql statement that returns a set of rows for a datagrid (which works correctly). I have the same criteria to get a count of rows in a stored procedure. My problem is when I get the count from the stored procedure it always returns the number of records, but, the sql...
  2. dalec

    Search query one way to return data another

    Thank in advance! I have a query where I'm searching an inventory database. This database has items grouped by categories (headers). What I'm trying to do is search only the descriptions from the categories (no problem), but, what I need returned is the items also under the categories searched...
  3. dalec

    Simple Search for a Simple Guy

    I've searched the last 3 nights (lucky me huh!) and I've tested and tested, but, can't get the results I need. Please HELP!!! What I want to do is search a text field nvarchar(50) from left to right. So, if a user is searching for let's say Targets but only enteres tar this is the result I...
  4. dalec

    Gridview with mouse over.

    I'm working with a grid view that I would like to add a mouseover effect not for a tooltip but to show a picture on another place on the page. I started using a popupcontrolextender and got that to work, but, it only pops the panel near the mouse cursor, when I want to load a picture elsewhere...
  5. dalec

    Trying to create a popup only after form validation

    Hi, I have a asp.net form that I have a login form on. I have validator's on the 2 textboxes, I have added a div tag in the code with the "please wait box and image" that I want to display after the user clicks the button for logging in (I use the onclick event, that runs java, to display the...
  6. dalec

    Multiple domain and email hosting

    I think my thinking is correct on this matter, but, let me run it by you experts. I host multiple domains on my exchange 2000 server. My thinking is that I cannot have two of the same names on two differnt domains like: jack@xyz.com and jack@abc.com, unless the actual login (username for owa or...
  7. dalec

    media server for home use

    I have found little info on this, so here's what I want to do; I want to setup a media server with all the audio/video connections on it. Then from another workstation I want to start and stop media (the media will be playing on the server not the workstation). I've read about remotly...
  8. dalec

    Running total per page, can't get it to work

    I'm using CR 7. and am trying to get totals per page, since there isnt a running total selection for reseting per page, I'm trying to use vars. Except that I'm not getting them to work right, so I need some help. I created 4 formula fields, the first one I put on the report header with the...
  9. dalec

    Strange, Query and data look good but not all returned

    I have a pretty straight forward query: select * from MyTable where cancelled = 0 Not all the the data that matches the query is returned, it was fine and no changes have been made, it just stopped returning all the possible matches, any ideas? If I use the query anylizer on the specific...
  10. dalec

    VPN to ISA to SQL HHHEEELLLLPPP!!

    Ok, I have an ISA server that I've configured VPN access for (no problems) really like it. (now here's the ..but.. part) when I vpn in it's great, but I try to connect to the sql server, I can see from the log that the vpn connection is trying to connect to the ip address of the sql server, I...
  11. dalec

    This is giving me a headache

    I'm trying to search an address within a field. For example when I search '4500' I get results, but, if I search '4500 L' or '4500 Lamont' it comes back with no results. Here's my code: SQL = "select * from customer where charindex('" & Trim(UCase(Sch)) & "', rtrim(upper(adr)) ) > 0 order by...
  12. dalec

    force ssl problem

    I've been trying to write a script that requires a page to use ssl, but, when I place the code at the top of each page (like the example microsoft has) when I try to navigate to the page it seems like it's stuck in a loop trying to redirect, then finally it will end up with a plain white screen...
  13. dalec

    Cant change domain

    Hi, I have an xp pro machine, and I am using the administrative local account, when I go to system, identification and try to join the computer to a domain, the domain option is grayed out. Any ideas on what is causing this, it once was on the domain and I put it to a workgroup (because the SIDs...
  14. dalec

    Accessing a Access 2003 Database Problem

    I'm using a aspx page to access an access 2003 database, it worked fine with a 97/2000 database, but, now I get an error "Cant find installable ISAM", I've searched around and cant find any help except short of trying to install access 2003 on the web server (which I really didnt want to do) the...
  15. dalec

    Which service is missing?

    I have an NT 4 server as my PDC and it runs exchange 5.5 and DNS, I recently got hacked, the attacker got access to the registry and deleted keys that were obviously required, I found the system at the login prompt the next morning. The system would startup and you could log in but DNS...
  16. dalec

    Server Grouping question

    What is a good general rule to follow for servers, for example is it good practice to have the SQL Server and the Web Server on the same machine, or say, Domain Controller and Exchange Server, or is it Better to keep them all on seperate systems? Domain Controller Web Server Exchange SQl ISA...
  17. dalec

    Do I have this right?

    I'm trying to figure the best way to setup the ISA server, is my understanding correct, that is, that the ISA server sits with 2 nic's one connected to the router and the other connected to the switch that the lan and the other systems are on? Also, I have 5 static IP address's that I've been...
  18. dalec

    Server wont starts, says service name invalid

    What a great way to start a Monday... I have an NT 4.0 server running exchange 5.5, and this morning it was at the login prompt. after login I got an error that a service could not be loaded. After some exploration I noticed that "Server" in control panel won't start, everytime I try to start...
  19. dalec

    Tried VPN now how to uninstall

    Hi, I was trying to install VPN on my windows 2000 server, I couldnt get it to work right and decided to remove it. Now the server won't connect to any other local servers on the network, It still can get out to the internet, but all local connectivity is lost. This all started when I was...
  20. dalec

    How to configure this

    I have a T1 connection that connects to a router, the router has both a DMZ and virtual server configuration, at present the router is using the only static IP address, there is about 15 workstations all getting local DHCP address'. Our ISP has given us 5 static IP address which I would like to...

Part and Inventory Search

Back
Top