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 Chriss Miller 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. SpiderFlight

    License information for this component not found

    Hi eveyone, I get the following when compiling a VB program. "License information for this component not found. You do not have an appropriate license to use this functionality in the desgin environment". I an using VB6 SP6. I have run VBC6.EXE which is a utility designed to fix License...
  2. SpiderFlight

    Force Data type to Text

    I have a select into query (see below). The problem is I'd like to force the data type to be TEXT for these 2 column dbo_medstat_physician_role.phys_id AS [upin#], dbo_medstat_patient_visit.hosp_id. Is this possible? SELECT dbo_medstat_patient_visit.case_mix_id...
  3. SpiderFlight

    xp_cmdshell

    I am trying to use the extended SP of xp_cmdshell . However when try to save my store procedure I receive the following message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()). Server: Msg 11, Level 16, State 1, Line 0 General network error. Check your...
  4. SpiderFlight

    Access Compile Error

    I have an Access2000 database where I have some vb code entered. This runs fine on most PC's. However I have a user who get "Compile error: Can't fine project or library". I asked the user to check the references but the code icon is grayed out! How can I enable this on their PC and allow...
  5. SpiderFlight

    Table joining question

    I don't write many queries so I'm not sure if this join will do what I want. I have 2 tables on different databases. Each table contains hospital specific data. I want to combine the 2 tables and report off this one table. My dba will not allow a new table to be created containing the data...
  6. SpiderFlight

    Copy SQL server Objects task doesn't copy data

    Hi everyone, I am hoping one of you SQL gurus can help me with this. I am developing on SQL 2000 and have a DTS process that contains a Copy SQL Object Task. When I execute this step manually the process tells me it was successfully executed. However, when I go verify there is no data copied...
  7. SpiderFlight

    How to estimate a VB projects time

    Hi everyone, Not really sure if this is the appropriate forum for this question. So I apologize if it isn't. Is there a standard rule of thumb in estimating VB projects times. I have written a number of VB projects and usually I under estimate or over estimate the time needed. Any direction...
  8. SpiderFlight

    DataTypes with a make table query

    Do any of you Access grus know the answer to this? After running the query below (Make Table) the field Entry_date has a data type of Number. How can I force the data type to be Date/Time? Any assistance is greatly welcome. SELECT DISTINCTROW MonthlyAuditSubQry1.dsu...
  9. SpiderFlight

    Data files

    Hi Cognos gurus, I have, what I think is a simple question. Once I have created my cube is there a need to keep the source data? I think I should be able to backup the file and then delete it from my PC. Please advise, Thanks
  10. SpiderFlight

    Reading and excel sheet via transformations

    Perhaps one of you gurus out there can be of some assistance. I am trying to figure out a way to read in a spreadsheet in the transformations and to pull certain cells out and populate and database. Any assistance would be greatly appreciated.
  11. SpiderFlight

    converting access queries to SQL queries

    I have a project which includes converting access queries to SQL queries. Is there software what will do the conversion? Below is an access where clause I need to convert to SQL. WHERE (((weekofyr([TblEShareData].[CHECKIN_DT_TM])) Not Between #1/1/2004# And #12/31/2004#) AND...
  12. SpiderFlight

    Updating a date field to 1st of the month

    I know this is probably very simple to do but I just seem to be stumped. I have a table with a column data type of datetime. The data in this column contains dates spanning of the last few years. What I want to do is update this column with its month and year but change the day to the 1st of...
  13. SpiderFlight

    Cognos Application Firewall

    When attempting to try to hide/show groups in a Cube Upfront, the following error message is produced: "Your request was rejected by the security firewall. Please try again or contact your administrator." When I disable the Cognos Application Firewall (CAF) the request works as expected. Are...
  14. SpiderFlight

    How do you print the source data file name on a report?

    I'd like to print the source data file name(s) on a report I'm printing. Does anyone have a solution to this? I saw the question asked a couple years ago put there wasn't a solution attached. TIA
  15. SpiderFlight

    Scheduler as a service?

    Its there a way to run the Cognos scheduler as a service?
  16. SpiderFlight

    upfront problem

    After refreshing a cube and placing it into our production directory I use upfront to publish the cube. When I go to look on the web page there is an older version of the cube still present. Is there a way to have this removed automatically? How about using the cammand line for an automated...
  17. SpiderFlight

    File locking and waiting

    I hope I have the right forum for this question. I have a VBscript that is called from a VB app. The VBscript opens and writes/appends the data to a file. My issue is the vbscript is executed many times within a loop and sends the output to a file, however I receive permission denied errors...
  18. SpiderFlight

    ppes_audit.log

    I am now the Administrator of Cognos at my company and we would like to know which users actually use which cubes, what dimensions, etc. I'm looking for some software to help me analyze the log file. As you know, if you have looked at the log file, YUCK!! Do any of you have such? I have...
  19. SpiderFlight

    Business rule coding help.

    Here is my question. We have employees which will be assigned tasks. The tasks are divided into 3 catergories (easy, medium, hard). Each catergory is assign a percent and the total cannot be greater then 100%. I need to randomly assign the tasks based on the percentage defined which each...
  20. SpiderFlight

    MSHFlexGrid

    I have a project I'm rewritting from vb3 to vb6. This project requires using MSHFlexGrid. The vb3 app used TRUEGRID. I want to convert this to use MSHFlexGrid. My question: Is there a way to bind an arry to the grid? Thanks

Part and Inventory Search

Back
Top