Showing posts with label complete. Show all posts
Showing posts with label complete. Show all posts

Friday, March 30, 2012

Problem in installing SQLSERVER2000 Developer Edition

You have a TCP/IP alias established created on your computer. Remove it and
setup should complete successfully. Setup starts SQL Server in a mode to
accept only shared memory connections. The alias is preventing setup from
connecting.
Run cliconfg from Start - Run. Go to the ALias tab and delete the alias for
this server, You do not need it. Or should not need it. If you do then
there is another problem that needs to be addressed.
Rand
This posting is provided "as is" with no warranties and confers no rights.Rand!
You the man! I was about to have a heart attack when i had uninstalled our
SQL Developer server and could not install Standard edition. Your suggestio
n worked like a charm! Your advice is excellent even 6 months later.

Tuesday, March 20, 2012

Problem Extracting DTS to Excel

HI,

I'm creating an Scheduled DTS to extract Sales data into Excel and Email the Excel sheet and I almost have it complete :) Apart of one small problem. (The bit I though would be easy).

The DTS is Emailing, scheduling and executing ok.

I have had to write a little bit of VBscript to cleardown the contents of the Excel fle before I begin loading the data each time, but when the data is loaded into Excel it does not start at the first Cell but maybe 700 lines down the worksheet

I think it is my VBscript that is the problem but I'm not sure. Has anyone else had problems like this?

Example

For Each Excel_WorkSheet in Excel_WorkBook.WorkSheets
If Excel_WorkSheet.Name = CStr(sSheetName) Then
Excel_WorkBook.Worksheets(sSheetName).Range
("A2:IV65536").ClearContents
Excel_WorkBook.Save
bFound = True
Exit For
End if
Nexti haven't looked into excel object, but can't you issue something like Excel_WorkBook.Home before you do Excel_WorkBook.Save?|||Have you tried deleting the range rather than clearing the contents ? Why do you need to do this ?