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

    Thank you very much. My program now compiles successfully! http://support.microsoft.com/kb/177799 had the information I was looking for. Thanks again
  2. 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...
  3. SpiderFlight

    Force Data type to Text

    Yes, SQL back end. The Cast and Convert worked great! Also, I found CSTR() will work for Access2000. Thanks.
  4. 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...
  5. SpiderFlight

    xp_cmdshell

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

    Access Compile Error

    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
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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
  14. 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.
  15. 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...
  16. SpiderFlight

    Updating a date field to 1st of the month

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

    Updating a date field to 1st of the month

    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)
  18. 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...
  19. SpiderFlight

    VB Trick

    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 :)
  20. 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...

Part and Inventory Search

Back
Top