Marshes's Q&A profile

• SQL Server Error Creating DSN using odbcconf.exe for SQL Server

  hi there i want to create a DSN using command line arguments,with Trusted connection=no, Login name= sa password=******* i try creating like this C:\>odbcconf.exe /a {CONFIGSYSDSN "SQL Server" "DSN=blabla|Description=blablubb|SERVER=vsnet1|Trusted_Connection=no |Database=dm"} this work fine, but when i specify the login id & password as C:\>odbcconf.exe /a {CONFIGSYSDSN "SQL Server" "DSN=blabla|Description=blablubb|SERVER=vsnet1|Trusted_Connection=no|loginid=sa|password=sysadm|Database=dm"} this throws an error as CONFIGSYSDSN: Unable to create a data source for the 'SQL Server' Driver: Invalid keyword-value pair with error code :2147467259 I too try the loginID, ...Show All

• Visual C# Program Crashes.

  I have been creating this program for a while now.. its a program that scans my works network IP's to see there hostnames.. and remove ip addr that does not have any host names.. but the program keeps crashing... The program crashes when I enter an IP address that does not have a hostname.. Can someone point me on the right direction Also.. Please forgive the way I coded it... I'm still learning.. and I'm still reading tutorials on a daily basis. Anyways.. I added the codes in a pastebin.. also any recommendations on the program would be helpfull. here is the link to the codes...   http://pastebin.com/823524 P.S: Unless you want me to post it here.. I will. This is probably in line 165, not 164. Your CheckBox array (chk) i ...Show All

• Visual Studio Team System Custom Test Install issues

  Good Day, I am trying to build custom tests. I am a newbie to this so please bare with me. I have RTM VS TFS Test edition with the VSIP SDK loaded. When I attempt to build the MyTest Sample, I get the following Build error for the MyTestUI: Creating temporary file "c:\TestTemp\MyTestUI\Debug\BAT00000135402424.bat" with contents [ @echo off "C:\Program Files\Visual Studio 2005 SDK\2005.10\VisualStudioIntegration\tools\bin\ctc" -nologo .\PackageCmd.ctc pkgcmd.cto -Ccl "-IC:\Program Files\Visual Studio 2005 SDK\2005.10\VisualStudioIntegration\common\inc" "-IC:\Program Files\Visual Studio 2005 SDK\2005.10\VisualStudioIntegration\common\inc\office10" if errorlevel 1 got ...Show All

• SQL Server Why am I getting zeros?

  I'm not sure why for each ProductID incoming to my function it first creates zeros like this ProductID  RelatedProductID 105744     0 0             105744 ...and then it's fine and then it does what I want it to, splits out the incoming Product / Childs and inserts them into my table. I don't see why the zeros are the value the first time through the loop for convert(bigint, @str) as well as ProductID Example incoming string looks like this (just one example, it's not always fixed length meaning fixed # of ChildIDs): 105234,105235,105236,105237,105238,10523 9,105240,1 05241,1052 42,105243, 105244,105 245,105246 ,105247,10 5248,10524 9,105250,1 05251,1052 ...Show All

• SQL Server Truncation error when importing from ODBC to flat file

  I am having problems reading from and ODBC conncetion from Oracle RDB into SSIS. I am using a DataReader source which uses a ADO.NET odbc connection to an oracle RDB database. I am having that write to a flat file. When I read integers from the source, it works just fine. When I read character data (char(48) for example), it gives me trucation errors. Is the DataReader source capable of reading char data from an odbc connection Here is the errors I receive: SSIS package "Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, DTS.P ...Show All

• Visual Basic Retrieving decimal symbol

  Hi, I'm looking for a way to access the regional option of Windows to retrieved what character is used as the decimal symbol. I'm building a little calculator application that have to work with the English or French setting. So I need to know the decimal symbol to be use "." or "," or the programme crash when converting string to number. Thanks you The following should help you Dim x As System.Globalization.NumberFormatInfo = My .Computer.Info.InstalledUICulture.NumberFormat Dim s As String = x.NumberDecimalSeparator The following class has numerous useful localization information for the machine My.Computer.Info.InstalledUICulture ...Show All

• Visual C# What is "\n"? Any difference from "\r"?

  I know "\r" indicates a sentence break. Then what about "\n" HtmlText = HtmlText.Replace( "\r\n" , "\r" ); HtmlText = HtmlText.Replace( "\n" , "\r" ); HtmlText = HtmlText.Replace( "\r\r" , "<p>" ); HtmlText = HtmlText.Replace( "\r" , "<br>" ); In the above line, since "\r" is to changed into "<br>", why should not directly change "\n" and "\r\n"directly into "<br>" http://west-wind.com/weblog/posts/1499.aspx if you are asking why it does not automatically convert to <br>, its because its not an H ...Show All

• SQL Server WM Shell

  hello all, how can run my application as a first application i mean before start up programs. ...Show All

• Windows Forms publish.htm and web not created by PublishOnly target in Microsoft.Common.targets

  Hi, Does anyone know why when I run publish from the project menu a publish.htm is created and the app is published to the web but when I invoke the PublishOnly target from my AfterBuild target the app only gets published to the app.publish folder under the project/bin/debug folder and not to the web (wwwroot) and no publish.htm is created, Geoffrey ...Show All

• Visual Studio files opened from the debugger are all lower case

  I am using Visual Pro, C++ 2005, on XP pro SP2 Every time I debug a program, and have the debugger open source files (they are not part of the project, the project was created by visual for the debugging session), it opens them with a filename that is all lower case, no matter what the actual case of the file is -e.g. stepping through a function in mySourceFile.cpp will open mysourcefile.cpp (the debug symbols do not keep track of the case ). Well, the problem starts coming if I modify said file in the IDE: it will actually save the file with the lowercase filename (effectively changing the case, not the same for the source control I use...). Manually opening the file from the IDE beforehand fixes the problem, but is not very practical, no ...Show All

• Visual Studio Express Editions Linking error message....

  <hr style="width: 100%; height: 2px;"><hr style="width: 100%; height: 2px;">Hi, I'm trying to compile an application that I got online and when linking I get the following message:Linking...LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corruptCVTRES : fatal error CVT1100: duplicate resource. type:MANIFEST, name:1, language:0x0409Any idea how I can solve this problem Thanks a lot in advance for your help!! Alejandro. It seems like you may be presenting the linker with a corrupt file - you should ensure that all the files in the program have been recompiled for Visual C++ - in general you cannot mix *.obj files built with difference compilers. ...Show All

• Visual Studio 2008 (Pre-release) listbox binding issue

  I have a template for a class in which I have the following XAML <Setter.Value> <ControlTemplate TargetType="{x:Type local:P1}"> . . . <StackPanel Grid.Row="1" Grid.Column="2"> <ListBox ItemTemplate="{StaticResource dtc}" ItemsSource="{Binding RelativeSource={RelativeSource TemplatedParent}, Path= AcrossClues}"></ListBox> <Expander Header="Across" > <ListBox Height="150" ItemTemplate="{StaticResource dtc}" ItemsSource="{Binding RelativeSource={RelativeSource TemplatedParent}, Path= AcrossClues}"></ListBox> </Expander> </StackPanel> . . . </ControlTemplate> the lis ...Show All

• SQL Server Invalid column name 'rowguid'

  I'm trying to set up a merge publication in MSSQL 2005 SP1. I have a database which I have successfully made into a merge publication.  When I run the snapshot agent, several articles are processed successfully, then I encounter an error with the following: Invalid column name 'rowguid' Note that none of the tables contain 'rowguid' columns before this process - I let MSSQL automatically create these as needed. The replication monitor details the following error: Error messages: ·           Message: Invalid column name 'rowguid'. Command Text: sp_MSpublicationview Parameters:    @publication = RelMS Publication Stack:    at Microsoft.SqlServe ...Show All

• .NET Development Finalizer guarantees for access to other objects

  When a finalizer runs are there any gurantees that any other object has not already been finalized This would include another object to which a reference in the finalizer's class still exists or a public static object in the finalizer's class, or any other class. nope, there aren't. Let say you have a object A, that have 2 private members of types B & C. B & C do not have a finalizer in my example public class A { private B _b = new B(); private C _c = new C(); public A(){} ~A() { //here in my finalizer i want to use _b en _c } } static void Main() { A a = new A(); System.Threading.Thread.Sleep(5000); a = null; GC.Collect() } let's say you dump your ...Show All

• Visual Basic TabControls

  Is there a way to hide a tab on a tab control. I am trying to hide a tab if a certain condition is meet. Davids Learning Is there a way to do an array Say if I had 6 pages I wanted to remove. One thing that I did notice, was that if I remove and inserted more than once per session, the pages didnt remove the second time, but they were empty. Davids Learning ...Show All