Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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

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.

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...

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...

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...

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

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

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...

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...

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...

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...

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