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 strongm 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: *

  1. hexOffender

    Sharing a virtual printer

    Does anyone know of software that will print to file for a virtual printer? I have a virtual printer set up on my PC, but I dont know how to allow another user to print to it and save the print image as a file.
  2. hexOffender

    Write to the second worksheet in Excel

    I have an Excel Workbook that gets printed with client name, dob, etc. I just added a second worksheet to the workbook, but how do I write to cells on the second worksheet. Dim xlApp As New Excel.Application Dim xlWB As Excel.Workbook = Nothing Dim Path As...
  3. hexOffender

    Is my ASA bandwidth throttling?

    I have an ASA 5510 which I have really no problems with, it is a great firewall. I also have an appliance for email security, a spam filter. The spam filter is supposed to be able to update a set of small databases every so often. The problem is that some of the thumbprint databases stop in the...
  4. hexOffender

    One Trigger to Rule them All

    Ok, not really, but I need a trigger to insert or update certain table whenever a few other tables are inserted or updated. For example, myTable should pull certain fields whenever table A,B,C,D are updated. Table A,B,C,D, all share a PK of VisitID. The problem, as I see it, is I don't know...
  5. hexOffender

    One VPN user cannot browse the Encrypted Network

    I have a Cisco ASA 5510 for VPN connectivity. At any given time there are 2-4 users connected, although there are over a hundred accounts set up. I have one new user who is external to the company who can connect to the VPN, but cannot ping anything or access anything. I have had his Admin check...
  6. hexOffender

    Agents wont update from Local repository

    A few days ago I noticed that the EPO service was not running, so I restarted the service. Since then all our clients can only update from McafeeFTP, which is our fallback repository. How can I fix this?
  7. hexOffender

    A better way to write this, Without the Cursor

    This needs to loop through a bunch of report rows and run the function dbo.Turnaround(VisitID)to calculate a time. In the code below, the function has a few more parameters, but I can rewrite the function to only take the VisitID, I was using it for other reports. The Cursor is really ugly and...
  8. hexOffender

    Meditetech Data Repository

    I'm just throwing this out there, but does anyone out there know Meditech DR. It is a MS SQL database. If so I have some questions that I need help with.
  9. hexOffender

    Whats the best way to do this?

    Here is the query I am working with: Select distinct ADV.VisitID,ADV.AccountNumber,(select distinct InsuranceName from AdmInsuranceOrder where InsuranceOrderID='1'and VisitID=ADV.VisitID) as PrimaryInsurance, (select InsuranceName as SecondaryInsurance from AdmInsuranceOrder where...
  10. hexOffender

    CONCAT function

    I am trying to combine th results of these two selects using '+'. It was working before, then it stopped. The individual statements run fine, but when I try to combine them I get an empty result, not a NULL, just an empty result SELECT distinct Response FROM NurQueryResults AS NQR WHERE...
  11. hexOffender

    Function returns NULL

    I wrote this function to calculate the turnaround time for a dictation. When I run just the query, the turnaround time gets calculated just fine. But when I try to call the function, with the same parameters, it returns NULL. Here is the Function: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON...
  12. hexOffender

    CONCAT two row values

    I have a table that has a TIME value in one row, and a Date value in another row. I have a select statement that can isolate the values of each, but I want them to be together in one field. Also They are string , but I need to run DATEDIFF later. What is the best way to CONCAT the results of the...
  13. hexOffender

    File link wont open in IE, just FireFox

    I'm running a single page on several machines that will just open video files. Im running them locally without web servers, and the video files are on a network share. In IE 7, this code ("file:///T:/video.avi") will not open. the status bar at the bottom of the browser runs to the end very...
  14. hexOffender

    Insert defaults to other field.

    This should be so simple, but for some reason, this insert statement wont insert in the field I want it to. insert into SchEncounterForm(ClinicForm)values('Y') However, when I run the command, it tries to insert into the First column of the table, instead of the ClinicForm column.
  15. hexOffender

    Cant debug any process on the server.

    I am using VS.net 2003 and the application is on Windows 2000 Advanced server. When I try to attach to a process I get the message "Unable to connect to machine 'servername': There appears to be no suitable logon session on the server. Please verify that you are logged on to the server through...
  16. hexOffender

    Can't connect to SQL2000 instance on server with SQL2005

    Hi, I just installed SQL 2000 on a server that was already running 2005. I created a new instance called SQL2K, and moved a database to the new instance. I cant seem to connect through my application to the instance. I am just using SQL authentication, with the user id and password coded in the...
  17. hexOffender

    LAN Restrictions for VPN users.

    On our Cisco ASA 5510, for our Employees who are connecting by VPN they get access by the Novell server. But external users, say vendors or others, don't get limited by groups, so how can I restrict their access, just to be sure. Only users that have a novel client, and account, would be able to...
  18. hexOffender

    Unable to debug application...

    Unable to start debugging on the Web server. Call was rejected by Callee. I can run the app by ctrl+F5, but cannot get the debug to work. All of the MSDN articles I looked at had to do with VBA or Office automation it seemed ( for the call rejected by Call ee error). I really am at a loss...
  19. hexOffender

    Incorrect Function when connecting to remote server.

    I have an issue with connecting to my Intranet server from my workstation. When I enter in the server name or IP to connect to, I get a msgBox that says Error : Incorrect Function. There is no error recorded in Event viewer on the server or locally. I can use a remote desktop session to get to...
  20. hexOffender

    IP address changed , now VPNS not working

    reconfigured the router to upgrade to a 2xT1. I have an ASA 5510 firewall that does Tunneling for Remote and L2L VPN. I gave the new IP address to the Remote Site administrator, but the tunel will not connect phase 1 (IKE). Nothing else has changed as far as the config, the crypto maps and PSK...

Part and Inventory Search

Back
Top