Search results for query: *

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

Sorry, I spoke too soon... I tested this in the SQL Query Analyzer and I received the error. When I ran this in my DTS package the statement worked as stated. Not sure why the Analyzer report an error. Thanks for your help.

I used the command referenced in Thread183-921333 however I received the following error: Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string. This is the command I entered. UPDATE Table SET [Event Date] = DateAdd(mm,DateDiff(mm,0,[Event Date]),0)

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

Just my 2 cent here ctl + enter on the IE address box will append WWW. to the begining of your text and add the suffix .COM :)

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