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 derfloh 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: deepsheep
  • Content: Threads
  • Order by date
  1. deepsheep

    Logon failure: unknown user name or bad password.

    So, I've got a head scratcher and if anyone has any ideas, I'd muchly appreciate it. We have an internal web app that (amongst other things) serves some pdf reports. These are stored on the network on a different machine. I managed to have them working for months, and in the past week...
  2. deepsheep

    SSIS and FTP

    I'm having a problem getting SSIS to connect to an FTP site via the FTP Connection Manager and the FTP Task. I get a rather unhelpful error of "Connection can not be established. Server name, port number, or credentials may be invalid." I've confirmed my server name, port number and...
  3. deepsheep

    Open a file folder in Windows 7

    I have an Access 2007 application that does a search and returns a file location. I want to be able to click a link or push a button and open the location, which contains a series of PDFs. This command works great on my computer - Windows XP Shell "C:\WINDOWS\explorer.exe """ & FileFolderLoc...
  4. deepsheep

    Linked server to firebird

    I'm trying to integrate some data into a new system. The existing system is a Firebird database and I can't move away from it. So, I'm trying to create a linked server to this Firebird database. I created one on my local machine (XP pro, mssql 2008 express) and it works great! Moved to my...
  5. deepsheep

    IN clause and variables

    I'm trying to pass a formatted array to a Stored Procedure and am having problems with the SQL. I know I can use dynamic SQL, but was hoping to avoid using it. Sample of what I'm trying, it works as dynamic, but not this way: declare @Param nvarchar(200), @cmd nvarchar(2000) set...
  6. deepsheep

    Slow session_start()

    I have a newly built webserver using Ubuntu Linux and php 5.2.10. Everything seems to work well, but the session_start is painfully slow. It works, but seems to take 2 minutes. I tested on IE and FF and on a couple computers with the same results. I've search the internet and come up with...
  7. deepsheep

    Exclusive mode problem

    I've recently inherited an Access Database. It has become more popular than originally expected and they are running into several errors. So I'm looking to migrate the data into MSSQL server and keep the Access front end, but make a few minor adjustments as requested. However, I can't get it...
  8. deepsheep

    Stored Procedure Insert not inserting...

    I have a table with column entry for every hour (TableA) and I'm converting it to a table with a row for every hour (TableB). I'm creating a stored procedure to help, beacuse every day there will be a new entry in TableA to convert to the TableB. I've chosen to do it with 24 insert statements...
  9. deepsheep

    Display dates in a range

    I know this has been asked a bunch of times, but I can't seem to find an answer that will work for me. I'm trying to get all the dates in a specific range (I'm using week number, but it could be month or whatever) out of the database to use as report headers. I can use the data in the database...
  10. deepsheep

    Trace Problem

    Another interesting one, I think it is linked to my other problem too. My one sql machine (same one I have problems with the counter in perfmon) apparantly has a trace running ont it. But I can't find what started it anywhere. I found this thread with a soloution...
  11. deepsheep

    performance monitor counter issue

    Ok, I think I have a good one. I ran a log for a couple of my servers in performance monitor. One worked fine, I got the info I wanted. The other did somthing strange. On the misbehaving server, I got all the counters to record, except the SQLServer ones. They recorded as 0, when it wasn't...
  12. deepsheep

    ADO dataset issues

    I need to find a way to create ADO datasets without requiring them to be on the form. I've got 2 on the form that I can use for most of my data access and they work well. But I'm writing a recursive function that accesses the database, pulls a couple of records and then calls itself on each...
  13. deepsheep

    MsgBox format

    I have a msgbox in a VB6 application that is doing what I want. It displays a message and stays on top of everything (by vbSystemModal option) until the 'OK' is pressed. However, I want the text to be bigger in the msgBox. I want it to be big enough that if someone wanders past the screen...
  14. deepsheep

    Trim a Memo Field

    I have what I hope is a simple problem. I'm using CR 8.5 and MSSQL 2005 and I have a large varchar field that CR interprets as a Memo. My problem is that CR is interpreting some stuff (after the actual data) at the end of the field as Line breaks. Quite a few line breaks. I'd like to trim...
  15. deepsheep

    Printing problems

    I'm trying to print some data to a PDF in VB.NET 2005. I've tried cutePDF and Adobe Acrobat 6.0 print drivers and get the same problem. When I try to open the pdf created by my program, I get an error that says the file is corrupt or not readable. If I print using notepad and not my program...
  16. deepsheep

    Newbie Questions

    Sorry if these have been answered, I'm having problems searching for them. I have a fair bit of experience with Crystal Reports 8.5 and am just starting on Reporting Services with MSSQL 2005. I felt a good place to start would be to convert some existing reports over. Here are some of the...
  17. deepsheep

    strtoul - string to int

    I'm trying to use strtoul to convert a string to an int. However, I need to use the 'end' pointer and am having issues doing it properly. I have a series of 2 character numbers stored like: 11223344. Each is actually a separate number : 11 22 33 44. The code I have is...
  18. deepsheep

    Not logging in to Network Server

    Sorry if this is answered somewhere, the search tool doesn't seem to work today. I have 4 networked SQL 2005 SP2 servers. I can't seem to connect to one of them (Server A) from another one (server B). I get the "connection string is not valid" then "Login timeout expired" and then "Server...
  19. deepsheep

    Need help with percentage query

    I need help with a percetage query. thread183-1330035 seemed to be close, but didn't quite work the way I need it to. It used the total count, not the count for a specific unit. I need to pick the units that report a certain value in a certain field more than 20 percent in a given timeframe...
  20. deepsheep

    network path was not found

    I have a network of about 10 computers and I have 2 that don't seem to want to talk to each other. I get "network path was not found". Every other computer on the network can talk to each other and can talk to my 2 delinquints. I am trying 2 things (neither work): 1) to add a network place...

Part and Inventory Search

Back
Top