John R. Garrett's Q&A profile

• SQL Server Mirror Setup Problems

  We are having problems getting the two databases to connect with each other for mirroring. We have the following setup: - Doing Principal and Mirror (no witness) - Using Management Studio - Both servers are SQL Server 2005 SP1 Standard Edition - Same domain account, same user id - We can telnet to both and connect to both from Stuio. We were originally getting error 1418, but now we're getting: " Neither the partner nor the witness server instance for database "tmsng" is available. Reissue the command when at least one of the instances becomes available. (Microsoft SQL Server, Error: 1431)" This is what the log file looks like: ------------------------------ 2006-11-06 13:01:59.62 spid24 ...Show All

• Visual Basic How to insert data into Excel sheet from VB.NET

  How to insert data into Excel sheet from VB.NET For Each f In folder.GetFiles() Try ' ObjWSheet = New Worksheet ObjWSheet.Range("A" & cellCount).Value = f.Name cellCount += 1 Catch exc As Exception MsgBox(exc.Message) End Try Next this code contain errors "object refrence not set to an instance of an object" ...Show All

• SQL Server File System Task Error - Process in use

  Hi, In the integration services package i'm working on i connect to an excel database and have two data flows which deal with two work sheets in the excel spreadsheet. The data flows do some transformation and then write the data out to a SQL database (two differnet tables). This is all working great however what i want to do once both data flows are complete is to move the directory which contains the current file that is being looped through. At present there is a foreach loop going through a number of directories. I have tried to implement the File System Task object to move the directory but get the following error: [File System Task] Error: An error occurred with the following error message: "The process cannot access the file be ...Show All

• .NET Development TypeInitializationException + windows xp 64 ??

  Hi, I have develped a C# application that runs well on windows xp SP2, but when I try to run it on windows xp 64 I get the 'TypeInitializationException' exception, the exception details is: System.TypeInitializationException was unhandled   Message="The type initializer for 'StartWindow.ArabicTextMiningForm' threw an exception."   Source="StartWindow"   TypeName="StartWindow.ArabicTextMiningForm"   StackTrace:        at StartWindow.ArabicTextMiningForm..ctor()        at StartWindow.Program.Main() in C:\GetDataBack_car\CAR\Soft_Associations_Charm_Apriori\StartWindow\Program.cs:line 17        at System.AppDomain.nExecuteAssembl ...Show All

• Visual Studio Team System deploy/schema compare scripts - Option for checking IF EXISTS

  My scripts need to check for existence of tables, columns, etc. before creating or altering. My procs and functions need to check existence and drop if they do already exist then create. Is there any way to control script preferences to accomplish this Gert was, I believe, pointing out that the recommended model for how you work with Team Edition for Database Professionals is slightly different from the way you are using it. Your approach can work, if you put your scripts under the scripts folder, rather than treating them as database objects, but it's an alternate approach. The recommended approach is that your schema is represented as a set of objects that you work with as CREATE (or ALTER in some ...Show All

• Visual Basic deleting a particular line in a File(txt)

  hi everyone , i need a solution to delete a particular line(ptr currently seeks) in a file with out disturbing other lines. plz confirm that the file is not completly read again to achieve this. all i need is just removing the line which is pointed by the streamreader/writer Thanks in advance.. my code that i have tried : ' Dim detailAdd As String ' Dim DetailTxt As String ' DetailTxt = Me.txbdetails.Text ' Dim comstr As String ' comstr = chkmsg(selitem.Item(0).Text)' getting the selected item from the list vwer ' Dim seekPtr As Long ' Try ' ' Create an instance of StreamReader to read from a file. ' Dim str As String ' Dim sr As StreamReader = New StreamReader(filename) ...Show All

• Visual Studio Express Editions Use String to reference form controls

  Hi folks, this must be an easy one for many of you, but at the moment my bleary eyes cannot find it: I have a string (say myString) that contains the name of a control ( e.g. "TextBox1") Now, I want to change the contents of that textbox, like TextBox1.Text = "This Text", but instead use the string to reference the control. Thus: Me.Textbox1.Text = "my Text" shoud become something like: Me.Controls.myString.Text = "my Text" Help appreciated, Thymen Hi folks, yes, the sample provided works, I tried that already, but not for what I am doing right now.<< should have been more specific in my thread start>>. In my case, I have se ...Show All

• Visual C++ create dll with visual 2005

  Hi, I have got my own mathematic classes (vector , matrix etc.) and I wish to export those classes in toa dll. How should I proceed to make it with visual studio 2005. thanks I wish to create my mathlib with Matrix4D Vector3D and Vector4D I have used this internet url : http://www.codeproject.com/dll/dllexport.asp so I have done , everyting which is explained in this tutorial but problems occured. (Visual C++ C1010 unexpected end of file while looking for precompiled header directive) what's wrong ...Show All

• Visual Studio 2008 (Pre-release) svcutil.exe missing in Microsoft Pre-Release Software Microsoft .NET Framework 3.0 - July 2006 CTP

  Hi I just finished installing .NET 3.0 July CTP and when I tried to find svcutil.exe to generate something :) it wasn't on the machine at all ! I have previously intalled on the pc vNext and Linq and I didn't removed them before intalling .net 3.0. I got successful intall. Where is the tool 10x Hi, I got caught out by this also! It's in the Windows SDK (http://www.microsoft.com/downloads/details.aspx FamilyId=117ECFD3-98AD-4D67-87D2-E95A8407FA86&displaylang=en) ...Show All

• SQL Server memory

  Hi, can anyone point me in the direction of any articles or whitepapers that give some ideas on memory requirements for running SQL Server 2005 analysis services. Say we have 250 concurrent users, can anyone tell how much memory I would require. I know this will also depend on cube sizes and number of dimensions, in our case we have approximately 20 AS databases with an estimated 300 cubes in total. Some of the dimensions get up to 100,000 members. Thinking that 3gb (32bit mode) isn't going to cut it and we will need to run in 64 bit mode for the additional memory availability. Need some help with concret figures, and how I can prove that we need to run in the 64bit mode. Any assistance much appreciated. Thanks Mick ...Show All

• Visual Studio 2008 (Pre-release) Config Equivalent for Credentials.IssuedTokenAuthentication.CertificateValidationMode

  I have to set this in code for issued tokens and peer certificate validation - that's fine and i know the implications. hostIssuedToken.Credentials.IssuedTokenAuthentication.CertificateValidationMode = X509CertificateValidationMode.PeerTrust; But how can I set this in config the <issuedTokenAuthentication> section does not seem to support this... ...Show All

• Windows Forms publish to all users

  Hi!! When i have publish a application, and then install this on a Pc. then my application is only install under the current user, so when a new user come to this Pc the new user must also install my application, is there a way to say thist the application shall install under all users sorry my bad english regards alvin Bad news... the current version of ClickOnce only supports single user installation, not multi/all user installation. Rumor has it such a feature is being considered for later versions but that doesn’t do you much good today. You’ve really got two options... you can either manually install your ClickOnce app for each user... or you could build an MSI installer which is capable of installing for a ...Show All

• SQL Server Random Number of column in SQL Server Reporting Services

  I want to create a report using SP. In this report i need to grow columns(number of columns can be chage according to sp) & Rows both.. Pls help me Have you considered a matrix report Another option - Is it truely dynamic in a sense that the number of columns can go from 1 to x or do you know the max, if so, you could dynamicaly hide columns based upon user input. ...Show All

• SQL Server Most charts not displaying

  I've got a report with a table holding a subreport that contains a number of Dundas charts. Each of these charts displays A LOT of data. Now... after deploying the report, only a few charts at the bottom of the report are displayed -- the rest display the Image-doesn't-exist icon (File image with red X across it). Can anyone tell me what's going on My best guess is that this is a memory issue on the server side... ...Show All

• Smart Device Development Deployment and/or registration failed with error: 0x8973190e. Error writing file '%csidl_program_files%\test\system.wind

  hi, I have wrote a simple C# device application program intend to call the function from the managed C++/CLI Class library in the form of *.dll file. The *.dll is named as pll.dll. My procedure is added the pll.dll file as 'add reference' and i Rebuild the C# device application project concurrently. Afterthat, i tried to deploy it to the PC Pocket emulator. Somehow the deploying process failed all the time and the error is like below. Error 1 Deployment and/or registration failed with error: 0x8973190e. Error writing file '%csidl_program_files%\test\system.windows.forms.dll'. Error 0x80070070: There is not enough space on the disk. Device Connectivity Component Is there anyone can help me to solve this problem and tell me the ...Show All