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!

Register Log in
  • Congratulations Rhinorhino 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. redsand23

    Attaching db

    I copied the db local(non networked machine) zipped it up, put it on a stick, copied it to the network production box, unzipped it and then tried to attach. I appreciate your help!!
  2. redsand23

    Attaching db

    It gives me the redx saying that the ldf does not exist and I get the following error. Could not open new database axdb_30. create database is aborted. Device activation error. The physical file name d:\xxx\axdb_30_log.ldf may be incorrect.
  3. redsand23

    Attaching db

    It would not let me copy the db while sql service was up and running. So I stopped services then copied.
  4. redsand23

    Attaching db

    I deleted any instance of the log file off of the server. When I right click on database/attach, and point it to my mdf it pulls the log file from the same location. If I clear the path the okay button goes grey. I don't see a way to remove it ldf file from attach function?
  5. redsand23

    Attaching db

    When I do the attach it pulls the ldf in by default if I uncheck it(puts a redx in) I get the following error. Defice activation error, the physical name(log file name) may be incorrect. Is there another way to attach outside of the right click attach db method?
  6. redsand23

    Attaching db

    I am new to this so please excuse the ignorance. I have an sql db on a standalone server that is not on our network. I copied the mdf & ldf and copied them onto a stick and put them on the network production sql box. I tried to do an attach database and received the following error error...
  7. redsand23

    Creating a schedule with a twist

    What would my table look like. Would it look like this? Would you have an small example as to how I would populate the grid. Time Segment 08:00 1 08:15 2 Again, I appreciate any help!!!
  8. redsand23

    Creating a schedule with a twist

    I have a query that prioritized and determines actual hh:mm:ss each job takes. For example pri job time 1 abc 04:20:00 2 bca 01:10:00 I want to be able to popluate this data into a grid or calendar control based on a start time of 08:00am in 5 minute increments. Here...
  9. redsand23

    Mulitple "All" Parameter selection criteria question

    Thanks that works great
  10. redsand23

    Mulitple "All" Parameter selection criteria question

    I am running cr9.2 and am having difficulty with multiple paramter selection criteria The goal is to have the user have the ability to choose any combination (Both all/none all/1 all 1 value) {QryRep.ReqDate} in {?StartDate} to {?EndDate} and IF {?Cellname} <> "All" then {QryRep.Cellname} =...
  11. redsand23

    Can I make a conditional circle?

    That is it ibass. Perfect. Thanks
  12. redsand23

    Can I make a conditional circle?

    Whouldn't I need to change the backround color of the text box and not the font. There is nothing in the text box. With Webdings I have used the = to give me a circle but I do not know how to change the font. If I use a text box I need to be able to create a formula to change the backround...
  13. redsand23

    Can I make a conditional circle?

    I am attempting to create a corporate dashboard with metrics and a red/yellow/green circle next to the metric depending on the value. Is there a way to format a circle(Formated square) to do this. I had thought about the webdings but can't figure out how to change the font color for the...
  14. redsand23

    Postscript Newbie - Distiller

    I need help with the correct syntax. Mr. Greer was nice enough to point me in this direction. I am pulling data from my mainframe and can actually save in .ps format. I just need assistance on how to handle multiple lines of data. This is what I have in the .ps file %!PS /Courier 12...
  15. redsand23

    DISTILLER QUESTIONS

    I guess I am missing the correct .ps format. Can I take the text file, add some code, save it as a .ps file then run it through the distiller? I am trying to grab straight text from a mainframe (FTP'd to the in (Watch directory) and convert into pdf. Is there some simple code to put in the...
  16. redsand23

    DISTILLER QUESTIONS

    Hello all, I am trying to use distiller for the first time. I have created a watch dir and am trying to process a file. The file is a.txt and only has the word test in it. When I process the file I get the following errors. Start Time: Friday, July 22, 2005 at 2:39 PM Source: a.txt Destination...
  17. redsand23

    Problem Closing excel?

    I have DTS importing a couple of excel files into SQL for which I have linked in a view, I then take the view and dump it into excel which works great. The last step I take the excel file and e-mail it out. I get the following error, error sending mail: MAPI error: Could not open the attached...
  18. redsand23

    Is there a way??

    Is there a way of doing this in DTS. I want to merge 2 text files that are tab delimited and using 2 fields(Sales order & line) as the link between the files. After the merge I want to save in excel format and then send it out in an e-mail. (I have the e-mail figured out). Any help would be...
  19. redsand23

    SQL connection logon & password

    Is there a property that will allow me pass the logon & password to connect to the SQL database in the below asp code. I am having to login to get the page to load when connecting to an sql database. When I use access and use a trusted connection I do not have the problem. I have tried the ole...
  20. redsand23

    ASP - ODBC - IIS6

    I have an iis5 server that is running great and connecting to both sql & access dbs, so I do not think it has anything to do with sp3, that is unless iis6 is looking for something on sql that iis 5 does not need. I have the access db's stored locally on the iis server and the big databases I...

Part and Inventory Search

Back
Top