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

    VBA model password

    I have an issue in using another piece of vba to make changes to several other excel workbooks vba code. The other vba projects are password protected, I know the password to the vba, but I do not know how to open the other vba sources and pass the password to it. Any Ideas. Thanks
  2. habfan

    Type mismatch on accessing an array

    Thanks, I have read the post and it does not offer a solution to the issue I am facing though it did give me some ideas. My issue is moving data from com to asp. Which is most likely the same type of issue. So I will pass a string then parse it in the asp page. If anyone knows of a solution to...
  3. habfan

    Type mismatch on accessing an array

    I have http friendly on, the exact message I get is Microsoft VBScript runtime error '800a000d' type mismatch The code is Dim oCustomSecurity Dim strReturn Set oCustomSecurity CreateObject("CPMCustomSecurity.Class1") strReturn = oCustomSecurity.fnGetUserGroup("localhost") if...
  4. habfan

    Type mismatch on accessing an array

    I am having an issue where I call a com object that returns an array of values. The function is a variant that returns the error code or array. I can access the isarray, lbound, ubound, and correct vartype (8200). When I attempt to access the actual values I get the error on the page. The code I...
  5. habfan

    Unix to Db2 on OS/390 Issues

    I am having problems setting up an ODBC connection to a DB2 database on a OS/390 installation. I have been able to connect to SQL server, dbase and a text file. I am using the same Driver Manager and the DB2/UDB Driver from Merant. I am getting the following errors, ODBC layer S1000 and native...
  6. habfan

    Using DB2 connect from Sun to OS/390

    I am trying to setup a sun box to connect to a DB2 database that resides on a OS/390 system. I need to use ODBC because of the packaged software. I have been successful in setting up on a NT box but have no Experience with Unix and ODBC. I have access to a DB2 DBA and Unix guy but no neither has...
  7. habfan

    trouble getting ODBC connection from unix to a db2 on os/390

    I have a sun box that is running an application that requires an ODBC connection. I have been able to connect to SQL server, dbase, text file without major issues. But when I try to connect to the DB2 database on a OS/390 I get an error "native code 364". I have DB2 connect on the sun...
  8. habfan

    Need Good CPU Memory Monitor

    I need to monitor the CPU and memory usage on an NT 2-processor box. I need the information written to a file for future use. Does anyone know of any good tools. Thanks
  9. habfan

    SQL 2 Oracle ole conection error

    I have fixed that issue now it seems that I have an issue with SQL server reading a table with a function based index. I cannot find any reference to this type of issue anywhere.
  10. habfan

    SQL 2 Oracle ole conection error

    I am trying to save/run a new view but I am getting an error message that the object does not exist. I am getting the table to appear with all of the columns. In fact I have tried to copy the SQL statement from an existing view and am getting the same error. I can access the data in an existing...
  11. habfan

    Connection Broken Error

    I have gone through Microsoft on this one and after 5 hours on the phone they have concluded the cause is a corruption of the SQL files. A complete uninstall, included any reference in the Reg. Then intall corrected the problem but, if you do this make sure you have backed up everything.
  12. habfan

    Connection Broken Error

    I am running MSQL 7 patch 2. on NT4 patch 6 both on the same server. I am getting the following error message, "ConnectionCheckForData (PeekNamedPipe()). [SQLSTATE 01000] (Message 109) Connection broken. [SQLSTATE 08S01] (Error 4). The step failed." and also getting an alert box...
  13. habfan

    Inserting stored procedure results into a temp table

    Here is a samll piece SQL Code that I think is what you are looking for. TRUNCATE TABLE tmpTable (your table name replaces tmptable) INSERT INTO tmpTable SELECT insert your select code
  14. habfan

    restoring the security file without rebooting the machine

    I do not know if this is possible. But for some reason the security file gets corrupted every month or two and restarting the server is not an option. I would like to know if there is a way to restore the settings without restarting the server, possible from a dump of the security file and...
  15. habfan

    Problem with long spreadsheets when printing

    have you heard of a product called fineprint.&nbsp;&nbsp;It can be located at <A HREF="http://www.fineprint.com.&nbsp" TARGET="_new">www.fineprint.com.&nbsp</A>;&nbsp;It will allow you to print upto 8 pages on one sheet.&nbsp;&nbsp;If you adjust your page width you will not need to reduce the...

Part and Inventory Search

Back
Top