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 SkipVought 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: *

  • Users: grad
  • Order by date
  1. grad

    DLLS

    Does anyone know how I can use the microsoft DLLs to count the number of words in a text box and also do a spell check and correction on the text. It is a multi-line text box.
  2. grad

    Finding user information from Browser

    I am trying to find out which country/state a user hitting my website from.&nbsp;&nbsp;I tried using the certificate object on a secure server but this did not seem to work.&nbsp;&nbsp;I can do it through the HTTP_ACCEPT_LANGUAGE but this is not foolproof.<br><br>Does anyone know how I can get...
  3. grad

    MTS object creation error

    I created a COM object in VB and registered it with MTS.&nbsp;&nbsp;I try to create the component from a client applicaiton on the same machine, I remembered to reference the DLL in the client project.<br><br>When I try to use the createobject call I get the error:<br><br>Runtime 429, Active x...
  4. grad

    VB /SQL server and the identity column

    I am using a ado recordset to insert a new record into a table in SQL server where the primary key is and integer identity column.&nbsp;&nbsp;Does anyone know how I can get the id that SQL assigned to the new record immediately after I call the update function:<br><br>rs.addnew<br>&nbsp;'do some...
  5. grad

    Missing transactions in MMC statistics for MTS

    I did configure the component to use transactions but this still did not help.&nbsp;&nbsp;Funny thing is it works fine on another NT server!!!&nbsp;&nbsp;Is something installed differently?&nbsp;&nbsp;The installation of the option pack seems pretty straight forward<br><br>
  6. grad

    DCOM registration

    I have create an Activex dll and registered it on a server.&nbsp;&nbsp;I took the remote files VBR and TLB and placed them on the client in the winnt\system32 directory and ran clireg32 xx.vbr<br><br>I then created a client app and pointed the reference setting to the xxx.tlb file on the...
  7. grad

    Cross-Tab / pivot table query for SQL 7

    How many records are you looking at retrieving?&nbsp;&nbsp;I have done this but using Excel to create a pivot table and it is much much more flexible than writing the CT query.<br><br>basically you retrieve all of the data from SQL into Microsoft Excel and you can give it to the users and they...
  8. grad

    CREATE PROCEDURE......

    I am not clear on the question.&nbsp;&nbsp;Also what version of SQL server and you using??
  9. grad

    HELP: SELECT two related tables in differents databases

    If you are using sql you can register the one server to the other using the sp_addlinkedserver and then login to one database and access the other database using<br><br>select ...<br>&nbsp;<br>from table1 a, server2.database2.user2.table2 b<br>where a.x = b.x<br><br>I have tried this in SQL...
  10. grad

    Missing transactions in MMC statistics for MTS

    I created a COM object that simple connects to a database and executes a sql string which I pass in.&nbsp;&nbsp;I then call setabort or setcomplete.<br><br>I register the object in MTS and create a VB client, point to the reference of the DLL and code my client calls to the...
  11. grad

    Object Pooloing im MTS?!! What is the strategy followed?

    from what I understand about MTS (and I understand very little at this point)...&nbsp;&nbsp;&nbsp;Setabort or set complete tells MTS that the object instance can be reused by other clients.&nbsp;&nbsp;The previous client still hangs onto the context wrapper so it thinks that it has a pointer the...
  12. grad

    MTS transactions

    This helps a lot now for my second question!!<br><br>On my client when I create an instance of the object, MTS starts a surrogate process.&nbsp;&nbsp;Can I get the object context in my client and do the commits and aborts from the client or do I have to create another COM object under MTS to do...
  13. grad

    DCOM registration

    How do I register the DLL on the client machine?&nbsp;&nbsp;Do I run the clireg32 as I did with the VBR and TLB files or is there another easier way&gt;<br><br><br>mark
  14. grad

    DCOM registration

    I am new to using DCOM. I am developing using VB6.0&nbsp;&nbsp;How do I remotely register a DCOM component without creating an installation &quot;package&quot; or using the install builder (this seems a bit too much)<br><br>I placed the DLL on the server and did a regsvr32 and on the client I...
  15. grad

    MTS transactions

    I am new to MTS but I have developed COM objects in VB before.&nbsp;&nbsp;I am using VB6.<br><br>Scenario:<br>If I have a functions withdraw(account, amount) and <br>deposit(account, amount)<br>the two functions can process transactions independently.&nbsp;&nbsp;Within each function I connect...

Part and Inventory Search

Back
Top