AnthonyKautz's Q&A profile

• SQL Server SQL Server Express is locking the database

  I'm running a website on IIS 6.0 w. ASP.Net 2.0 and SQL Server Express 2005 via the native client. The connection string is fairly standard: <add name="SiteSqlServer" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=c:\DotNetNuke\App_Data\ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> I find that after the website has been running for a while I can no longer open the database using SQL Server Management Studio Express (I get an error indicating that the physical file has been locked). Even if I shutdown and restart both IIS and SQL Server, it rem ...Show All

• .NET Development How to get an IP address?

  Hi all, Would you like to tell me how to get an IP address of client, who invokes a WebServices method I'd like a short sample of code (in C#). Thanks. From the Webservice side, try this [WebMethod] public string GetClientAddress() { string UserAddress = Context.Request.UserHostAddress; // string hname = Context.Request.UserHostName; return UserAddress; } ...Show All

• SQL Server this should be easy but it's not.

  I have written 2 custom connection mgr’s. One connects the data from an oracle source One connects so I can put the data on a sql server. These both work well and it makes it a lot easier across development, test, production. But now I would like a good way to do this I have 10 tables to copy from oracle. The only difference is just the name of the table. static string [] g_tables = { "table_name_1" , "table_name_2" , "table_name_3" , … }; foreach ( string str_table in g_tables) { Oracle.DataAccess.Clien ...Show All

• Windows Forms Found SOlution !!!

  I've got forms with Master-Detail DataGridView that show data fine. Contract (master)   ContractJobNumber (Details) Edits made in data, then click on the 'Save' icon on the Navigator (the little blue disk thingy). Get out of program and go back in - data I just put in not saved. Trid adding this.Update on a clikc button - no change. Tried private void cONTRACT_JobNumberDataGridView_RowLeave( object sender, DataGridViewCellEventArgs e) { this .Validate(); this .cONTRACT_JobNumberTableAdapter.Update( this .drillTracker_DataDataSet.CONTRACT_JobNumber); } private void button2_Click( object s ...Show All

• SQL Server Code Completion of SQL Statements in 2005

  Will the new tools for SQL 2005 give us code completion of SQL Statements, e.g. if I type the following sql USE pubs GO SELECT pub. FROM   publishers AS pub When I type the "pub." will I see a list of the available columns in the publishers table.  This type of feature has been available in TOAD for years and years, will SQL Server programmer finally get this in the 2005 release. Cheers, Colin This may have been the video they saw at the PDC: http://channel9.msdn.com/Showpost.aspx postid=121794 Regard,    Damian ...Show All

• Windows Forms What is the best UI library to get for .NET windows forms development?

  Hi I am look at the various libraries/controls/... available, and am wondering which is the best option, based on experience Thanks Thanks for the response, I have downloaded his set and will give them a try. ...Show All

• Windows Forms DataGridView and Lookup ComboBox

  Hi, I do have one DataGridView bound to one datasource, two column are ComboBox (lookup), the ValueMember and DisplayMember as been set to the required lookup datasource Table (Different from the grid). When run, the grid does display the text instead of the value as expected, I can select the text in the combo and everything Looks ok. However, when I do close the Windows form an error related to the second ComboBox Stating the value is not ok is raise. If I add DataGridViewDataErrorEventHandler this .titresDataGridView.DataError += new System.Windows.Forms. DataGridViewDataErrorEventH ...Show All

• Visual C++ How do i stop any program that i run from exiting almost immediately.

  Hi! I am experiencing difficulties while using the Microsoft Visual C++ 2005 Express Edition: Any program that i write, upon pressing start to run it, would automatically end itself almost immediately, giving me no time to see the output. Is there any way to delay the programs from exiting (Any settings that i should change ) Thank you. Regards, Ebenezer Thank you all for taking the time to read my post and answering. =) Regards, Ebenezer ...Show All

• Visual Basic it is possible to make my app work without .net Framework!

  Hi Folk I have created a VB.NET Win Application and when I try to install it, it asks me to install the .net Framework first!! Is it possible to install a Win App on third party machines without the need to install the .net Framework !!!!!!!!! This is a big disaster, if I will need to install a 20 MB to make a 200 kb application Works! I need to run my application without the .net Framework! Any ideas please Thanks If you have concerns about .Net Adoption I would suggest checking out this post by our VP Soma... http://blogs.msdn.com/somasegar/archive/2004/06/03/148131.aspx ...Show All

• SQL Server Going From SQL Server 2000 to 2005

  It's been nightmarish and I need help fast! Customers now have to buy 2005 and we've discovered that the migration isn't smooth. I copied a 2005 and attached to it in 2005. Running under Windows XP Professional, I tried to run our application written in ColdFusion. We discovered that a query fell over (seemingly) having to do with bit datatypes Error: 'Unspecified error occurred on SQL Server. Connection may have been terminated by the server.'), NULLs, or something. A programmer got around it, as a test, by converting all the bit fields in the table to int, which we naturally can't do as a real world solution. I think upgrading the OS, incl ...Show All

• Visual C# ADO.net

  System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\DataBase\login.mdb'. It is already opened exclusively by another user, or you need permission to view its data. at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at DataBase.Login.OnInit(EventArgs e) in c:\inetpub\wwwroot\database\login.aspx.cs:line 53( I marked red) using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.Sessio ...Show All

• Visual Studio Express Editions How do I host my VWD website? Do I have to use Micorsoft's server software like SQL Server 2005?

  How do I host my VWD website   Do I have to use Micorsoft's server software like SQL Server 2005 Are there any other options available to me Michael Non Microsoft in what way Why on earth do you need 1024 terabytes of traffic I doubt you'll find any cheap hosting at that sort of level, no matter what you write your app in. I'd imagine all major hosts would be offering ASP.NET 2.0 by now. I've just done the math - you want to serve 420,000 MB every second of every minute of every hour of every day in the month Assuming that your users all get 150 kb/s, that's 2.8 million users at the same time, all the time. Even if my maths is wr ...Show All

• Windows Forms No append Row

  How do i disable the appendrow in a datagrid. The datagrid is not readonly....i want it to be that way.  Second, I saw a solution used by a programmer, he did it in c, but, my datagrid its filled by a dataset, not by a datatable....how do i do  thanks... You mean C# not c right The easy way would be to drop a dat ...Show All

• Visual Studio Team System TF80071 connecting MPP to Team project

  I have an MPP in my Team project. I have checked out the MPP file and opened it. When I click the Choose Team Project button and select my project, I get an error "TF8001: Team Foundation encountered an error while accessing the work item database.  Please contact the Team Foundation Server administrator." Any clues TIA, Doug Doug, please check the application tier for a corresponding event log entry.  It sounds like there should be one, and that would help to diagnose the problem. Buck ...Show All

• Visual Studio Express Editions Is there any way to work with graphics data in console applications ?

  Is there any way to work with graphics data (loading/changing/saving) in console applications You can do windows programming in general using the express edition. This is by installing the PSDK headers and libs separately. Take a look at the first video at http://msdn.microsoft.com/visualc/learning/vcexpvids/default.aspx Thanks, Ayman Shoukry VC++ Team ...Show All