Search results for query: *

I have developed a web service using C# and I am now working on the installation msi. I would like to have the installation process ask the user the specific site to which the webservice should be installed (using WIN2K or WIN2003 SERVER with multiple Websites installed). I have no problem...

I know that runnning sp_updatestats will increase performance on a SQL 2000 database, but my question is how often is sp_updatestats run in a day. I am working on an application that is about to be deployed worldwide with a central database. Using a small testing group (approx. 30 users), we are...

...using the following API . . . ProgIDFromCLSID Retrieves the ProgID for a given CLSID. WINOLEAPI ProgIDFromCLSID( REFCLSID clsid, LPOLESTR * lplpszProgID ); Parameters clsid [in] Specifies the CLSID for which the ProgID is requested. lplpszProgID [out] Address of LPOLESTR pointer...

But if the code is in an ActiveX control running in a web browser it is still running on the MAC. And if the ActiveX was compiled to binary code for an Intel process (I.E. Pentium) then how would the same binary code run on a Motorola based processor? Unless MAC's IE provides some sort of...

Hey Jon, Thanks for the info . . . I did not know that there was a formatcurrency command . . . you learn soething new everyday! Have a star! - Jeff Marler B-)

...Value) 1011.6 (Multiply by 100) 1012.1 (Add .5) 1012.0 (Take the integral value) 10.12 (Divide by 100) Or in code Dim RoundedValue As Currency Dim OriginalValue as currency OriginalValue = 10.125 RoundedValue = Int((OriginalValue *100 + .5))/100 - Jeff Marler B-)

Craig, I was looking at performance (specifically netowrk traffic) Why bring the entire recordset across the network (assuming this is a networked application) when all you need is one row with the count. Let the DB server count the record for you locally and then simply return the total...

...Recordset Dim strSQL As String Set gcnAP = New Connection Set rsTotal = New Recordset If bTestProd = True Then strSQL = "SELECT COUNT (*) AS TotalCount FROM registuser" Else strSQL = "SELECT COUNT (*) AS TotalCount FROM registuser_pro" End If strConnect =...

Thanks for answering Chip . . . All of the components were written in VB 6.0 running on WIN2k Pro Servers. The overall load at the time was very light ( 4-5 users). This error only seems to happen when we are running on the cluster boxes. When we break the MSMQ cluster into a single MSMQ box...

Has anyone here ever seen the message "Waiting to connect" on outgoing queues when using queued components? We have an application that was written in part with queued components. Both the Application server and MSMQ server are on clusters. The COM+ proxy exports for the queued...

Thanks John . . . actually, someone at work gave me what I need. It's simply Format$(Now, "hh:mm:ss:ms"). - Jeff Marler B-)

Does anyone know of a way to format the Date command or the Now command so that it will return milliseconds along with the actual HH:MM:SS data? - Jeff Marler B-)

...sure that your code has an Option Explicit in the top of every file and then the complier will warn you. Better yet, turn in on it your options *for some reason, the default is to leave this off) and VB will automatically put it there for you. here is how . . . 1) Select Tools from the...

...As ADODB.Recordset Dim artData As ADODB.Recordset Dim strSQL As String Dim strConnection As String strSQL = "select * from tsble" strConnection = "Your Connection String" Set artData = New ADODB.Recordset With artData .CursorLocation...

Look in the directory where the source code is and delete the *.Scc files. this will remove the SourceSafe protection. - Jeff Marler B-)

Forms are VB objects rather than true COM objects (I imagine that you are passing the form as an Object). This might work better if you created a class wrapper to place around your form (so that the form could remain native to its EXE) and then you would call functions on the class wrapper that...

I would also add that you will want to make sure that you are not passing the object across and process baoundaries and/or machine boundaries. This will kill performance as will as cause security issues. If the object is to be passed around in a single process, then you will be fine. - Jeff...

I am working on an n-tiered application written in VB DLLs running under component services/COM+ and part of the application requires asynchronous functionality. To implement the asynchronous functionality, I am using queued components where MSMQ delivers the marshalled data without forcing the...

You can use a normal nonfixed length string, but the API call does expect a buffer in which to insert its results. Almost all APIs dealing with strings work this way. If you use a normal string, then you need to allocate space for the answer using the Space$ command. For example . . . dim...

Use the Command$ instruction in Visual Basic. It returns whatever follows the actual application name when it is run. For example, given the following scenario - <From the Command Prompt, your script called> C:\MyApp.exe /A SomeData /B MoreData <In your application Startup code - could be...