Recent content by SpiderFlight

Thank you very much. My program now compiles successfully! http://support.microsoft.com/kb/177799 had the information I was looking for. Thanks again

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

Yes, SQL back end. The Cast and Convert worked great! Also, I found CSTR() will work for Access2000. Thanks.

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

This is a SQL2000 server. I have tried removing & reinstalling the client tools. If connected to the server via pcAnywhere and I enter in the code everything is good. If connected thru Enterprise Manger and I remove the line containing xp_cmdshell I can save the stored procedure. If I place...

Problem resolved. The user didn't hold down the shift key to suppress the restriction. Also, there was a missing reference. Thanks for your fast response

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