Search results for query: *

I agree with not using cursors unless absolutely necessary. The solution is not always to move it to the app. You would be amazed how often a cursor can be replaced with a well developed sql statement. I prefer the use of sprocs as well. However, there are situations that they do not seem...

It sounds as if you are dynamically building your DTS in your VB app each time it is run as opposed to creating it one time in Enterprise Mgr, saving it, and scheduling it. If this is the case, you can use windows scheduler to kick off your VB app. If the user doesn't access the scheduler...

The type libary is what the remote pc needs. if you are using VB, the type library is embeded in the .dll, therefore the entire dll is copied over. Using C++ you can seperate the type lib from the dll.

I had this or a similar problem the other day. I found the dll in my system32 folder and re-registered it. This solved my problem. regsvr32 c:\winnt\system32\mmcndmgr.dll

I am having a strange occurence on one of our servers. I have an ASP page calling a COM+ VB component. When setting the identitiy to a domain account, sometimes I get object creation errors and sometimes it works. If I set it to a domain admin account, it works fine. Obviously I do not want...

Nevermind. I found it on a website. The answer is to set the mapping name to the type name. For array lists, you set it to "ArrayList". The site I found it on has a very good list of FAQ for .net: http://www.syncfusion.com/FAQ/WinForms

I have been able to create a Datagrid and use an ArrayList as the data source. I have also added a DataGridTableStyle to the datagrid that is populated with DataGridColumnStyles. However, I cannot get the table styles to affect the columns in the datagrid. One problem is I don't know what to...

That appears to be an operating system error indicating it could not find the file you are trying to execute. You are using UNC naming for the server. Is this server different from the SQL Server you are running the sproc on? If so, the user account running the sql server service must have...

You can use the Scripting object to determine if a file exists and moving it to other directories. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/sgFileSystemObjectModel.asp

Why not simplify it even further and make it even more accurate: if @date1 < @date2 select @date1 else select @date2 This will make it accurate down to the level in which datetime tracks time. Chris.

What is the error you are getting?

db size or log size will not make data disappear. If db size and log size exceeded limits, the records would not get inserted to begin with. Whatever your process that inserted the data should have recevied errors if that was the case. You could look into Log mining software. That might tell...

If you are wanting to use it in a select statement, you can use a case statement: SELECT CASE WHEN col1 < col2 THEN col1 ELSE col2 END AS MinColValue, col3, ... FROM table Chris.

Disconnected recordset help you out when you marshall the recordset between processes. Chris.

Maybe if you define &quot;it will not update&quot; will help a bit. Are you getting an error? if so, please post it. or is there no error and the data is not getting updated? Chris.

This could really depend on how you are using ADO. There are a lot of variables that can cause this problem. Where are you using ADO from? ASP? COM+ component and passing it to ASP? Are you using a client-side cursor or server-side? What are you doing to pull all the records into ADO? Are...

There are several ways to approach this. It all depends on how the values are stored in the database. The best method is to make it a numeric column when the table was created if numeric is the only type of valued that is wanted. If you do not have control of the design, you could cast the...

Are you sure the statement is not inserting a null? Do you have the code? or are you saying the field is not on a screen (assuming there is a UI)?

Views are indeed another way to pull data from Crystal. However, with views you have to be very careful. A complicated view can cause performance problems. If the view has nested selects, it could be more efficient with stored procedures if you need to strategically place a parameter in the...

SemperFiDownUnda is correct on calling a COM+ component as few times as possible is more efficient. However, making multiple calls to a component in itself does not make it stateful. Stateful is when you store the data in a class level variable in one call and expect it to still be there in...