ron nash's Q&A profile

• SQL Server looking to write my own simple SQL Client via TCP/IP

  I'm looking to write my own simple SQL Client via TCP/IP. We have some hardware that does not run an OS of sorts, but I can create TCP Connectons. We's like to be able to Query our SQL Server with this hardware. The SQL Servers we are talking to are MS SQL2000 and MS SQL 2005 both via TCP port 1433. We can telnet to the port of the SQL Server. Any resources to the SQL Protocol you could pass along would be great. Thank you, Scott<- Its not too proprietary since there are Linux and Java versions of the TDS Protocol out there with the Source If its not too much trouble wont hurt to see whats involved in geting the License for the Protocol. I've found the Following on TDS since I did the origin ...Show All

• SQL Server Management Studio Express breaks database connectivity

  Hi, I'm using SQL Express to run DotNetNuke on my own Windows 2003 server. DotNetNuke(DNN) copies a database on to the server from it's installation files and during the installtion process it fills the database with starter data. That process works fine. But the minute I attach to the database in SQL Server Management Studio Express (MSE), my web app loses connectivity to the database. When browsing to the default.aspx, I see the following message: Error Installing DotNetNuke Current Assembly Version: 04.03.05 ERROR: Could not connect to database specified in connectionString for SqlDataProvider __________________________________________________________________ (don't be fooled by the error message, Dot Net Nuke was fu ...Show All

• Visual Studio 2008 (Pre-release) C++/CLI, DataContract

  Hi! I have this legacy app in C++ and would like to put WCF atop of it. (in C++/CLI) I already managed to create a rudimentary service, but fail to use the DataContract attribute. Is this not possible in C++/CLI Thanks, Bernd Hi Ben! What I'm trying to say, but failed to do so, is that when writing something like this: [DataContract] ref class MyArray { ... } I get: error C2337: 'DataContract' : attribute not found My question is: Why does the compiler not recognize this attribute Thank you ...Show All

• Visual Studio Team System How one can sense that there a Check in happens to something

  Hi all, I wonder about TFS source control in something as one developer check out some part in a solution project .... class .. etc. and after he done his work he checked it in ..... so how the other developers could be noted about that check in ...... as the others can know anything about that code that has been checked except that the person who checked in told them about that check in so he can get the latest version ........ so is there a solution to infrom the team about the different check ins that happened thanks The most common solution is checkin emails. An administrator can configure checkin emails to be sent to a DL, or users can subscribe to checkin events in areas of the tree they care about. There are lots of samp ...Show All

• Software Development for Windows Vista Disconnect pin cause video card driver Stop

  Hi I use Direchshowlib-2005 with C# and 2 head room video card. for the first video card i use VMR and for the secound one i just use simple Video Renderer. I dont have any problem with VMR at all but when I want to close the program, blue screen appear and said: graphic card driver stop. i release all of the direct show object and put the owner of video window to IntPtr.Zero. But when ever that i want to disconnect the Video Renderer Pin my application crashed and windows also restart. i be appreciated if someone help me Yes, a driver is software. However, it is not an application. Unlike applications, drivers talk directly to hw. This gives them more scope for making mischief. ...Show All

• Smart Device Development USB External Hard Drive

    This forum is smart device development related. Since your question is not related to smart device development, it's off topic here. Please post to relevant forum or news group: http://support.microsoft.com/newsgroups/default.aspx Closing as off topic. ...Show All

• Visual Basic URGENT coding help required.

  Hi ive got every thing the way i want it but have problems with some code (probly only about two lines.) I have a text file (.txt) in my project but dont know the code to get it to open. when a button is clicked. Please reply ASAP to aitken91@msn.com Iain Aitken Dim FileContents As String Private Sub Button1_Click ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles Button1 . Click Dim tr As IO . TextReader = My . Computer . FileSystem . OpenTextFileReader ( "FilePath" ) FileContents = tr . ReadToEnd tr . Close () End Sub ...Show All

• Visual Studio 2008 (Pre-release) Hyperlink and navigation

  Hi, How can I create a Hyperlink in XAML that navigates the Frame back and forward I know how to do it with code behind, but I'm curious to know whether there is a clean way to specify that behavior in XAML only. Thanks, - Imad <TextBlock> <Hyperlink Command="{x:Static NavigationCommands.BrowseBack}">Go back</Hyperlink> </TextBlock> ...Show All

• Visual Studio Express Editions Change a window position

  I am a beginner and I was wondering how I could make a form/window look like its sliding accross the screen. I have set up the timer and that, I just need something like: Me.location = (x + 1, (middle of screen)) Thanks Nathan Or even this: Dim X As Integer Dim Y As Integer = CInt(Screen.PrimaryScreen.Bounds.Height / 2 - Me.Height / 2) Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick X += 1 Me.Location = New Point(X, Y) End Sub If you press Alt-Spacebar while the window is moving it leaves it's control menu behind - weird. ...Show All

• Visual Studio Team System how can i remove files from my drive

  and have TFS be aware for instance, i synchronize the entire tree in TFS. later i decide that i only need some of it and want to free disk space. how do i remove those unwanted files from my drive and have TFS be aware when i later decide to get those files again remember, directly deleting files on the local HDD defeats the purpose of TFS. TFS does not know they were deleted so it thinks you still have those files. attempting to do a "get latest" only shows a dialog telling you that your files are up to date. thanks, scott hi buck, i nearly forgot about this question. too much pumpkin pie i think. that solution does indeed work. still though, it *is* a hack. i wonder if a "remove files&qu ...Show All

• Visual Studio Express Editions Lesson #2 - The Step Into and Step Over Buttons

  Sometimes the idea of using the debugger, can be intimdating to those unfamiliar with them. This is a tutorial based in a standard piece a source code that we will supply for the purposes of this tutorial. We're going to make a cheap MP3 player. I hope this tutorial is highly interactive and constructive. Needed Ingredients: 1.) A test directory with about 4 mp3 files. Make them as short as possible. 2.) Create a new Windows project. In the form Designer, add: a.) A progressbar called progressbar b.) Two buttons, One named btPlay and the other called btStop. In their respective text property boxes in the designer, insert Play and Stop. c.) A windows Media Player control. This probably is not in your toolbox ...Show All

• SQL Server Executing a batch script from "Execute Process" Task

  Hello, I have an "execute process" task which executes a perl script. When I run the task, it shows a prompt with the message "the publisher can not be verified". It gives the option to continue the task or to cancel. The problem for me is that I want to schedule this package to run automatically, and I don't want the automated process to show this dialog. I need to override the security setting and have SSIS execute my batch scripts without prompting. Assuming I don't want to rewrite the Perl code into a script task, is there a way to do acomplish this Thanks! Arkadiy Thanks, I found another way of solving this without changing the security settings. The trick is to inv ...Show All

• SQL Server Is there anything like rowid, rownum like in MySql and Oracle??

  Hi, i am new to SQL Server. I want to write a query where in i want to delete duplicate rows from a table keeping the master copy. If it is MySQL or Oracle we can write that using built in rownum or rowid. How to do that task in SQL Server 2005. Is there anything like rowid, rownum in SQL Server If not suggest me a way to do that ...aazad Thank god .. you are using SQL Server 2005 use the following query Example: CREATE TABLE Table1 ( [Id] [int] NULL ) go INSERT INTO Table1 values ( 10 ); INSERT INTO Table1 values ( 10 ); INSERT INTO Table1 values ( 20 ); INSERT INTO Table1 values ( 20 ); go   With Test ( rownum , ID ) as ( Select Row_N ...Show All

• Smart Device Development Connecting to a Pocket PC database (ie: contacts in pocket outlook)

  How can I connect to a database file on the Pocket PC I am trying to extract contact data from the native application on my Pocket PC, which I believe is called "Pocket Outlook." I've searched for information on this, and everything either points me to using some other database (like SQL Server CE), or to using ActiveSync to sync the Pocket PC with Outlook on a desktop. Is there any way to connect directly to the native database on a handheld device from a desktop application I'd like to do it through C#. Any help (even a simple connection string) would be greatly appreciated. POOM is the way to go. It's not exactly a database though so no connection strings. WM 5.0 has Microsoft ...Show All

• Windows Forms How to create a Custom Form that appears in the Toolbox and is droppable on the Design Surface?

  I like to create a dll with a custom form that contains other controls (buttons, check boxes, etc). I am using vb.net or c#.net (2005). I like the form to appear in the Toolbox and be able to drop it on the design surface. This behavior is the same as the provided dialogs such as FontDialog. Searching the web showed that I need to add a designer attribute of ComponentDesigner: "Set the Designer attribute for your custom dialog to be ComponentDesigner (instead of the default ControlDesigner). That should make it droppable in the design surface as a component." But I have not been able to make this work. Can someone help Thanks, Rene Do the users actually need to see the form on the d ...Show All