Recent content by nondrinker

Hello, I am trying to add the string "XYZ" to each file name and then move my files from folderA to folderB. This is the code that i have so far. ********************************** Private Const varSourceAddress As String = "\\serverA\drivename\FolderA\" Dim diaddr As New...

Thank you, It worked!

Hello, I am trying to increase the field size of column of a table, that has 500,000+ records in it, but the system keeps timing out. I have tried to stop and restart the SQL Server service also, and then tried to make my change but same thing happens. In the database the connection time...

Thanks to both of you for your help.

Ok finally it worked. DatabaseName.dbo.Tablename(EmployeeID, Name) VALUES ('100', 'TestName')

I didn't see any option of spefiying a database name. I tried: Insert INTO DatabaseName.Test3 (EmployeeID, Name) VALUE ('100', 'TestName') But i got the same error.

Hello, I have been to trying add a new maintenace package. I chose the "Execute T-SQL Statementtask", and all i am trying to do here is run an insert statment. But whenever i try to run it, it gives me this error: Executing the query "Insert INTO Test3 (EmployeeID, Name) VALUES...

Thank you very much. I will try that.

Hello, I am trying to send out an email where the receiver should see a person's name in the from part instead of the email address. This is the code i currently have. Something like: Set iMsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.configuration") Set Flds =...

Currently we have 3 back ups that run on our SQLServer 2000 like this. 1. Daily diff back up (runs once a day) 2. trans back up (runs every half an hour) 3. Weekly full back up (runs once a week). Last week i moved the physical location of the .bak file to a different machine. #1 and #2 still...

Thank you for your time. Instead of using the multiline text box, i changed it to a listbox (named lstbox) and adding this line of code did the trick: lstBox.Items.Add(t)

Hello, I have been trying to display the contents of a folder in a list box but so far i am having some problems. The closest i have come to is display the file name in a multiline textbox using this code. *********************************** Dim varFolderPath As String varFolderPath = "\\[My...

Hello, First let me tell you that this is the first time for me to work on a vb.NET project, or even on an OO based project for that matter. In my vb.NET project currently i have 2 forms and one class file. Form1 (that has the datagrid on it), form2 and my class (MainOrder.vb). What i am...

tsuji, Thank you for your help. Well for some reason my code was hanging on this line, with the same error: ************************** varstatus = objRefAttr.Text ************************** I changed the code to: ************************** varClientId =...

Hello, I have a datagrid populated with records, with OrderID being the left most column. On the Double click event, I am trying to pass the value of the selected orderID to a class. In that class i have my SQL query which i am building based on the orderid passed from the datagrid. On the...