clint 2's Q&A profile

• SQL Server Access/Server

  How do you change the connection string of a DataSet We have been using MSAccess for our database, but have recently upgraded to SQLServer Express. I was able to successfully upsize the Access database and now all information resides on the server. In my VisualBasic program, the dataset itself has around 200 queries total spread out on multiple table adapters. The problem now is that none of these queries work because the dataset is bound to the Access table. I have changed connection string through code and am able to display the information, but am unable to interact with it until i get the dataset connection changed. I would rather just change the connection of the dataset somehow rather than build a new dataset, reconnect all form ...Show All

• Windows Forms Try..finally

  hi.,i try the following code in C#.net . try { TextBox1.Text = "hi.."; return ; } finally { TextBox1.Text = "Nice one.."; } whenever i run this code it gives me o/p like Nice one.. but whever i trace it, it goes through try block but go in finally block and show the finally blocks result, so i can not understand that why it can not show the try block's result protected void ExampleTry() { // Consider Try Catch Finally as a wrapper for the code in the Try block // the finally block is executed after the code in the try block regardless of that code. string str = string .Empty; try { str = "Try block<br/>" ; ...Show All

• SharePoint Products and Technologies Options for Updating Excel displayed thru Excel Web Access ?

  I'm developing a dashboard which contains some graphs surfaced through Excel Web Access. This works great. However, is there a way of updating the Excel data without going into Excel (e.g. via a synchronized SharePoint list or by using infoPath) so I have more control over the UI I'm really looked for a code free solution so I don't have to worry about maintenance and deployment issues in the future, and so power users can also use the same method for their own sites. I am having a similar problem. Here is the background: I have InfoPath forms that collect data and are then pushed up to a forms library on MOSS 2007. I promoted the appropriate fields from InfoPath into columns in the form library. I then ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. D3D Mesh Object does not exist...and Spacewar is using new "swm" format?

  Looking at the SpaceWar sample...I am wondering if there is somewhere a converter from .X or .XBF to the SWM format. Looking at the loader in the Simplemesh.cs class, it looks like the SWM is using a propriatary header and than the binary .X format.. Can anybody help with this format I would love to use 3D Max and export to .X than read it into my game...but without a code converter to SWM...hard:-) I created a .X to .SWM converter. x2swm - http://astaroth.beatbuggy.net:8080/Downloads/x2swm.zip It's not properly tested, so let me know if it works ok. ...Show All

• Visual Basic Tables In Drop Down List Boxes?

  Is it possible to show a table for a SQL Server in a Drop Down List box Do you mean is it possible to list the contents of a table in a drop down Or show a list of tables Either way the answer is yes. You could for example simly bind a dataset containing the required data to the drop down. ...Show All

• Visual Studio Source Safe 2005 & IIS 7.0 ( Vista )

  I can't get the webservice to allow PUT requests ( checking in files ), I get a failed authorization every time. Everything but the PUT works. I'm guessing it's some time of setting/permission that's not allowing the PUT verb, but I can't find anything that could be blocking it. Anyong have any ideas Ahh, I see! Seems to be somewhat of a shame that you can't run it under Vista. Will this be fixed on the Longhorn Server, or is MS trying to force Team Foundation I find it funny that I got real responses here, and I didn't get a single one on the actual IIS 7.0 forum..... Colin ...Show All

• Visual Studio Express Editions MS access content change notification

  Hi, How can I know if the access content is changed so that the content is update thank you   If I understand you correctly, you are using an access database, which is not the same as  Access itself. If I had multiple users like you do, I'd run, not walk to import your data to SQLE with advanced services. With SQLE you can define trigger conditions that will notify your process and cause a process update to occur. It's complicated but to be honest, I think you will need it. ...Show All

• SQL Server Configure IIS for Reporting Manager and reporting server site

  Dear All: My reporting manager and reporting server were working fine in IIS. But when I booted the system one day, one error message came "Unexpected error" for the IIS. So I removed the IIS and reinstalled he same. But after that, I tried to give virtual directories to reporting manager and reporting server sites. But it ain't working. Could you please help me My IIS 5.1 Reporting service 2005 Express with SQL Server Express ASP.NET 2.0 Express. Please help. Thanks in Advance Emmanuel Mathew Dear All: I got it somehow worked. But now the problem is that when I take the report manager and display the report, it shows me a wrongly formatted page with "Object reference not set to an isntance of an Object" But in ...Show All

• SQL Server Subsystems could not be loaded

  Hi, I'm running SQL Server Agent services and SQL Server Integration services under same Domain\User account and the same Domain\User account is also having sysadmin rights in sql server. And below is the SQLAgent.OUT file details which I'm getting while running the SSIS from SQL Agent job. [100] Microsoft SQLServerAgent version 9.00.1399.06 (x86 unicode retail build) : Process ID 4012 [101] SQL Server MachineNameXYZ version 9.00.1399 (0 connection limit) [102] SQL Server ODBC driver version 9.00.1399 [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is [310] 4 processor(s) and 3072 MB RAM detected [339] Local computer is MachineNameXYZ running Windows NT 5.2 (3790) Service Pack 1 [432] There are 11 subsystems ...Show All

• Visual Basic Convert string to AddressOf Method VBExpress

  I'm trying to take a list of names and put them into a ContextMenuStrip under the current item "Assign": [CODE] cmiAssign.DropDown.Items.Add( "Test" , tstimg, AddressOf cmiTest_Click) [/CODE] In place of "Test" is the person's name and cmi[Person's Name]_Click I can't find how to take a person's name as a string and get AddressOf to understand where to go on the click. Thanks! kramas, 1. The AddressOf Operator creates a procedure delegate instance that references the specific procedure. For example, the following example uses the AddressOf operator to designate the startup function for a thread. Public Sub CountSheep() Dim i As Integer = 1 ' Sheep do not count from ...Show All

• SQL Server insert /modify ONLY in certain elements

  I have XML in a table and I must update legacy data. I need to update some, but not all of the elements The structure of this is <SeveralActions> <Action>DoNotUpdate</Action> <Action> <elementToUpdate/> <elemntID4Update/> </Action> <Action>DoNotUpdate</Action> <Action> UpdateThisOne <elementToUpdate/> <elemntID4Update/> </Action> </SeveralActions> The element that must be updated is not always in the 2nd and 4th position. It can move at random. Also the minimum number of <Action> elements is 0, so I need to ascertain the existence of the element, whether it should be updated and then update it. Is there any way to pick and ...Show All

• SQL Server Dedicated Administrator Connection

  Hi: I am trying to connect to my local instance of SQL Server 2005 using Dedicated Administrator Connection by using Admin:Servername\Instancename and I end up with the following error. Dedicated administrator connections are not supported. I enabled the connection in the SQL Configuration Manager and still get the error. Any ideas on how to resolve this error . Note: SQL Browser service is running. Thanks Ak Sorry for the late reply. I've seen the same error when the server\instance is incorrect. Since this is a local instance, please try one of the following: sqlcmd -S".\SQL2K5" -A -E sqlcmd -S"MyMachine,1771" -A -E Be sure to start the instan ...Show All

• Windows Live Developer Forums Virtual Earth Bugs & Workarounds

  Here's a short list of bugs/missing items and workarounds we found while developing Atlas using the Virtual Earth API. http://blogs.freshlogicstudios.com/Posts/View.aspx Id=b733b75e-7cd7-4c0c-97b6-2c53d6ce076b Yeah, not cool. I shouldn't have to type O''Fallon into local.live.com to get directions. I'll add it to the list of workarounds. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GSE RTM on Vista RTM (unsupported)

  i know it's not supported ... but has anybody got it to work bought the club account on the 360 and downloaded the app on the 360. installed Express on Vista with no problems and registered. tried an update, but didn't see any service packs. then i installed GSE, which complained about the VS projects, but it still seemed to install. fired up Express and the XBox 360 Starter kit project was there and built fine. went to tools options, and setup the connection to the 360. then i set the 360 to listening mode. but when i try to deploy, it just comes back and says make sure the the 360 is listening. also, turned off the vista firewall but got the same results. any ideas Thanks, casey Only W ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Good place for free sprite sheets?

  Does anyone have a good site for free 2D sprite sheets (for sprite animation) or does anyone have (or willing to create) any good sprite sheets they are willing to share I have a new project that I'm going to put on CodePlex which I think will be very useful and I need a good sprite sheet that I can include with the sample. Thanks, Bill http://tsgk.captainn.net/ I doubt you could use most of that stuff due to copyright issues, but a good resource nevertheless. ...Show All