Dudley's Q&A profile
SQL Server Database with empty name
I somehow managed to get a database object with an empty name into one of my instances of SQL Server. I can't delete it or otherwise work with it (I've tried renaming it so I could delete it) without getting an error message because of the empty name. I've tried these things (as well as a "Drop Database" query with no name, which I didn't expect to work and it didn't) from both the SQL 2000 and 2005 environments. Has anyone come across this before I don't suppose this database is hurting anything but I'd still like to get rid of it. The objects in it make it appear to be a copy of the Master database - it also doesn't show up where I would expect it to in the Data folder for this instance. Thanks, Dave ...Show All
SQL Server Trying to CONCAT a TEXT field with 2 VARCHAR fields - brick wall.
Hi all. I have been going round and round for the past 2 days on this and would appreciate any help. In a view select statement, I need to concat 2 varchar fields with a text field. If I CONVERT the TEXT field to VARCHAR, only the first 30 characters of the field appear in the result set. If I convert the VARCHAR fields to TEXT, I get an error that I cannot CONCAT TEXT fields. I'm not sure what to do. Can someone please offer some assistance Thanks in advance! Steve I tried this and it works fine (SQL Server 2005 as VARCHAR(MAX) does not work in 2000): SELECT CAST ( TextCol AS VARCHAR ( MAX )) + VarCol1 + VarCol2 FROM Table ...Show All
Visual Basic Program to execute on one machine only
Hello, My problem is that I want to deploy my program onto a 'thumb drive' and sell it that way and I need the program to only run off that drive. It is a small program that can easily be copied and run by anyone so I thought that if I could somehow 'lock' it to the small USB drive then that would solve my problem. Because some games require a CD to be in a drive before they will run I figured that that would be something that I could do, my problem is finding any help in how that might be accomplished. Can anyone point me in the right direction Thank you very much Bill Langston making the usb drive read-only would only keep people from writing to the drive, it would not keep them from copying the program contained ...Show All
Visual Studio Express Editions call procedure
Hey there, I have a problem because I would like to call a procedure during run time but I can't... for example if i would like to call the button1.click event in VB6 I used call(button1.click) but now in VB2005 I can't do that becuase that method no longer exist. so how can I call a procedure... I'm asking this because i don't want to use a private sub for doing the button.click thing and then call it from the button event, but if there is no other way then I think I'll have to go this way thanks... this is one of my problems, how do i call a sub, from another sub, when both are public. halifaxjack@aol.com ...Show All
Game Technologies: DirectX, XNA, XACT, etc. XNA + Standard Dialogs
Hi, Thanks in advance for any help. Sorry if it's a silly question - though I have done a quick search of the forums and found nothing. I'm aware that, because of the way XNA uses the graphics device, standard windows buttons etc. can't be used in the main game window. So I wrote a quick form to show some diagnostics / settings outside of the main window. All OK. I now want that form to have a 'save as' button, to save the current file I've been editing in the underlying XNA code. However when I launch a SaveFileDialog from the form I get a "System.Threading.ThreadStateException". Is that because XNA doesn't like modal forms Why does it handle my form OK but not this standard dialgo I'm guessing I could write my own Save As dia ...Show All
Visual C# How do I change/enable the configuration drop down on the Build events tab
Basically I’m trying to set up custom build events in VS 2005, and I can’t get the configuration Drop down to be not grayed out. I want one set of custom steps for debug and another for release. I’m programming a WinForms application in c#. I figured there is a setting somewhere that controls this, but I’ll be darned if I can find Any trace of it in google. Can anyone help point me in the right direction Thanks, E- Wierd I could swear that in the earlier versions vs6 , vs.net , vs,net 2003, this capability was supported.. I wonder why it was depricated. it's a very handy feature. Thanks for the help though! Eric- ...Show All
Visual Basic Rich Text Box Cursor location
Hi Guru's, I have a rich text box that i am appending text to all the time, and it ends up turning into a scrolling rich text box which is just great. However i would like it instead of just adding the text to the bottom, also add the cursor position to be with this new added text, so that the user doesnt have to scroll the box down to see the new text that has been added, is this possible Leads me to my second question, i have two functions which add text to this rich text box, Functions A and B is there a way to colour the text from function A to say Red and the text which gets added from Function B to say Blue Thanks in advance for your assistance. OK please excuse this total noob i got it ...Show All
Visual Studio 2008 (Pre-release) Include XAML into XAML
How can I include one XAML into an other XAML. i think you have a resourcedictionary as a external XAML-document ! now, you can use this document (reference this document) with the tag <RecourceDictionary source="MyXAMLDocument.XAML"/> in the "Recource" tag from any container’s. a small sample for using a ResourceDicnionary.xaml in a window tag. .... <Window> <Window.Resources> <ResourceDictionary source="MyXAMLDocument.xaml"/> </Window.Resources> ..... i hope it help ;-) sorry for my small englisch TOM ...Show All
.NET Development Help with Raw Socket
Are there any example of how to construct a raw icmp packet If you're just looking for Ping, there is a Ping class already in the System.Net namespace. http://msdn2.microsoft.com/en-us/library/system.net.networkinformation.ping.aspx Mariya ...Show All
SharePoint Products and Technologies Loading to Excel Services
Hello I have a question about loading to Excel Services. Is there any way that I can load data from a Project Portfolio Server 2007 or Project Server 2007 to an Excel Service and display that data in SharePoint Server 2007 Thanks and best regards, Mystique Did the answer above work out for you If not please let us know so we can try and continue helping, otherwise, please mark it as the answer for the thread so we can get it off the radar. Thanks! ...Show All
Visual Studio Express Editions progressbar help
Hi im new to this programing stuff im using visual basic express edition and im trying to make a program its like a internet explorer and i cant seem to figure out how to get the progressbar to work when im loading the web pages what do i do please help fast! This worked for me: Private Sub WebBrowser1_ProgressChanged(ByVal sender As Object, ByVal e As System.Windows.Forms.WebBrowserProgressChangedEventArgs) Handles WebBrowser1.ProgressChanged ProgressBar1.Value = CInt(100 * e.CurrentProgress / e.MaximumProgress) End Sub ...Show All
.NET Development Windows Logon Displayed on local maching when running ASP.NET applications
Hi, I am trying to run my web application on my local machine ( http://localhost(or machine name)/Sample ) and I am bieng shown a windows logon box to enter my user id and password. This is very wierd but, the wierdest part is when I enter my windows user id and password, it would not let me in. so, when I hit cancel, This error message is what I get: You do not have permission to view this directory or page using the credentials you supplied. Please try the following: Click the Refresh button to try again with different credentials. If you believe you should be able to view this directory or page, please contact the Web site administrator by using the e-mail address or phone number liste ...Show All
SQL Server Web Site Admin Tool problem in VS2005
Hi I am attempting to do what many folks on this site have tried to do and that is to use the web site admin tool. Like the others, I am receiving the following error message. There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow r ...Show All
Windows Forms Any sample pages how to use regex with RichTexBox?
I am using Richtextbox in my form application.I wanted to find some regex str and replace it one by one.Any sample pages how to use regex with RichTexBox Thanks Regex doesn't work with controls, only strings. You can retrieve the text from the RTB and then pass the text to Regex for parsing. Search for Regular Expressions in MSDN for many examples. You might also find Regulator ( http://tools.osherove.com/CoolTools/Regulator/tabid/185/Default.aspx ) a useful tool for testing REs prior to using them in code. Michael Taylor - 7/26/06 ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Spacewar first run
Being a complete newbie to all of this C# and XNA i loaded up spacewar click on build then installed the project. Then i ran it and a error window popped up, details said something about a missing something or file not found, i sent a report to MS from the window that popped up. I can see im going to have to buy a C# for dummys book cause im totaly lost as to what to do first... This definition for D-pad is from http://en.wikipedia.org/wiki/D-pad A D-pad (short for directional pad ) is a plus sign –shaped control found on nearly all modern video game console gamepads and game controllers , with one button on each point. Like early video game joysticks , the vast majority of D-pads are di ...Show All