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 Mike Lewis 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. cmartin75

    error '8007045a'

    Only for a test and only for a moment try to give administrator privilegies to the iis user to ensure that the user is the problem
  2. cmartin75

    error '8007045a'

    The dependency walker can help you to find if there's another dll you must install on the server http://www.dependencywalker.com/
  3. cmartin75

    error '8007045a'

    In the event viewer of the server will be some error about it. And It helps you to find the component
  4. cmartin75

    error '8007045a'

    Has the user IWAM (or IUSR) permissions to create the ActiveX in the DCOM configuration?
  5. cmartin75

    BROWSEFORFILE?

    Follow this link: http://www.microsoft.com/technet/scriptcenter/resources/qanda/jan05/hey0128.mspx
  6. cmartin75

    How can I run an SSIS package on a remote web hosting SQL SERVER 2005

    With the command-line utility "dtexec" of SQL Server 2005. You can execute packages saved as "stored packages" on the SSIS server. Another way would be execute the package from a local machine, and connect the SSIS data sources to the server of the hosting company
  7. cmartin75

    sort order query

    You can use the CASE statement in the ORDER clause Like this: ORDER BY CatId, CASE SubCatId WHEN 0 THEN '0' + Description ELSE '1' + Description END If it doesn't delay too much your query, it would be a solution.
  8. cmartin75

    objFSO.FileCopy error copying a file

    The method is CopyFile, not FileCopy http://msdn.microsoft.com/en-us/library/6tkce7xa(VS.85).aspx
  9. cmartin75

    Cannot connect to Server

    this error may suggest that the problem is that the server don't allow remote connections (By default on SQL Express, for example) To configure the server to allow remote connections, try this: Open the surface area configuration tool of SQL Server 2005 On the surface configuration window...
  10. cmartin75

    Script to get the screen resolution

    Follow this link http://www.microsoft.com/technet/scriptcenter/resources/qanda/jul05/hey0721.mspx
  11. cmartin75

    SQL Query construction

    Also you can use the SQL Server 2005 Import Wizard and check the option "Save as SSIS package" at the last step of the wizard. You can schedule this SSIS package generated by the wizard
  12. cmartin75

    script error when file not in same folder as script

    The commondialog control of vb, the opendialog changes the current directory. I think is the problem here. In the commondialog control of vb you can avoid change the current directory with the flags property of the control. (Value = 8), but I don't know if it's applicable on this case
  13. cmartin75

    SQL aggregate SUM statements

    I think you can get the same results without the first sum Having abs(sum(Case tr.upostdate When convert(datetime,'01/01/#dat1#') then d.samount else 0 End)) + abs(sum(Case tr.upostdate When convert(datetime,'02/01/#dat1#') then d.samount else 0 End))<> 0
  14. cmartin75

    Remove network printer based on driver used

    Maybe this pages can help you How Can I Retrieve Information About the Printer Driver Used by a Printer? http://www.microsoft.com/technet/scriptcenter/resources/qanda/jul05/hey0719.mspx How Can I Remove All the Network Printers on a Computer...
  15. cmartin75

    Contents of include file not displaying

    Only to ensure that the path is ok
  16. cmartin75

    ASP page needs to find a dll file

    It seems like the CDOExm is interpreted like an asp variable In the CreateObject line. Are you sure that the object is inside quotes? Set objMailbox = CreateObject("CDOEXM.IMailboxStore")
  17. cmartin75

    SSIS Sql server 2005 - Adding 0 to day or Month if length is 1

    Something like: REPLICATE("0",2 - LEN(DCDAY)) + DCDAY If there's not rows with more than 2 characters length in the field DCDAY
  18. cmartin75

    Set parameter in scheduled job step

    On the books on line the syntax for the property path is the same that the dtexec utility. (in the command line tab, it generates the command line with the property) The sintax is: \Package.Variables[User::Variable].value http://msdn.microsoft.com/en-us/library/ms162810.aspx In Microsoft...
  19. cmartin75

    WQL - Select /Where structure

    You must include double \ in the pathname. C:\\utilities
  20. cmartin75

    Changing a DateTime field to a Date field.

    You can use the day(date), month(date) and year(date) to get the date without time and the dateadd function to get the previous date. dateadd("d", -1, date)

Part and Inventory Search

Back
Top