Recent content by topher0303

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.