Recent content by scimatic

I'm working with 64bit SQL 2000 server and there is a stored procedure that executes and copies object files to a temporary directory where subfolders and files are stored. I want to create a solution to clean this directory and delete all the files and subfolders that are older then 3 days. I...

I'm looking for something like what this company offers: http://www.anosoft.com/ but more advanced. What I need is something where I can choose databases from different servers and deploy 1 or more sql scripts to them, but it needs to keep some sort of log so I know if any errors occurred...

Does anyone know of any 3rd party software that allows you to execute sql scripts against multiple databases within multiple servers?

I can't find any examples that are very clear how to make a connection, I guess how you make the connection doesn't really matter. ODBC has been what I've ben looking for.

I haven't had much luck on finding information or examples of connecting to mssql using c++. Can anyone tell me how to make a simple connection to a mssql, runa query, store the results to text file and close the connection? Any help will be greatly appreciated. Thanks

I want to create an excel file with java and write data to it, here is what I have so far. How do I create new worksheets and add data to them? Is there a better way of doing it? import java.io.*; import java.text.DateFormat; import java.util.Date; import java.io.File; public class...

I don't know where to begin with this one. I want to query a table that contains a list of 1000's of user names. I would like the query results to show me a list of user names that are grouped by similarity. By similarity I mean user names that differ only by one or two characters usually at...

I found that I can use: system("mkdir directory") to create the folder and then change the working directory by using: #include <direct.h> _chdir("directory"); //change working directory ... write files ... _chdir(".."); //go back to main directory

How do I create a user specified folder and then have all my ouput files be written to that folder? I'm currently using this to create the folder: system("mkdir Records"); But I cannot get the files generated from my program to be written to that folder.

What I want to do is read a string with a bunch of words seperated by a delimiter, in this case the delimiter is a tilda ('~'). The number of words in the string i want to split is always unknown. I want to store the words in a structure where I can print out each word using a for loop like I...

How would I write a program that could search and replace strings in a text file. The string I want to search for is "," and replace with a ~ The problem is that I want to replace the comma and the quotes with the tilda in a file and i get errors with having double quoted strings, like "",""...

is there a way to make all the fields on a form automatically adjust the width so they grow or shrink to fit the data currently being displayed?

I have 5 tables and 1 main form. Is there a way to create a subform area in the main form and make 5 buttons, one for each table so that when a user clicks on button1 it will open table1 in an area on the main form and when the user clicks on button2 it will close table1 and open table2 in it...

That gets rid of the error i was getting but the statement still does not work. The ELSE statement is always executed. Even if I substitute a value that should trigger the IF statement into the SELECT statement for Me.ID.Value: ...WHERE table2.ID = value", dbOpenDynaset) the if statement is...

I'm getting a Run-time error '3464' Data type mismatch in criteria expression and it points to the line with the SELECT statement. The ID fields in all the tables are the same data type which is number. Any ideas? Private Sub Form_Current() Dim rst As Recordset Set rst =...