Esprit's Q&A profile

• Microsoft ISV Community Center Forums CreateProcessA problem - no DOS windows appearing

  Hi I have an Excel model which (once a lot of data is entered) saves some data as a text file and uploads it to an OLAP database. It does this using CreateProcessA to run a command line. (Code at the bottom of this message.) The code wasn't written by me, but comments on the code say it was from the MS web site. This has worked fine in the past, but I have recently upgrated from Windows 2000 to XP (and from Office 2000 to 2003) and it no longer works. The CreateProcessA command fails to open a DOS window. I thought it was an XP problem, but a colleage has the same set up as me and the upload works fine on his PC. So I think the code's OK, but it seems there's something on my PC that's interfering with it. Any ideas where I can start to loo ...Show All

• Visual Basic more help please!?!?!?

  That helps... but i still dont fully understand it :(... I like the datagridview way better... but seeing as how many users will be using it i dont think that my boss will like it so much... unfortunately... I am going to do it both ways and see which he likes better... however, what i dont understand is: (i am only going to be asking questions from the insert into the database from textbox b/c i am pretty sure thats how he wants it) A) how does the OLEdbCommand work... (sorry i am just a student trying to do a proffessional's job :( ) B) all the code is done on the submit button right we dont need to establish the connection on the form load C) what is an nvarchar :( I think i am going to leave it at that for now... and ...Show All

• SQL Server Finding the Month with only Week and Year

  I'm having trouble figuring out how to do this, but I'm sure there must be a way. I have a table with a column for week number and another for year. I need to find out what month this particular week fell into. I realize that some weeks will cross over two months, so I'm fine with using either the first or last day of the week which could be turned to the day of the year. Any ideas how to get the month when you only have a week number and year to work with Also, I'm not the one who decided to save just a week and a year. I'm just one stuck trying to figure out how to use the data. :) Perhaps something like: declare @numberOfWeeks integer set @numberOfWeeks = 18 declare @year integer set @ye ...Show All

• SQL Server Error 1418, fails to connect mirror server

  I I use the mirroring wizard to config all these three servers(windows authorization is used), the error logs in primary server and mirror server are showed as below a) On primary server: Error: 1474, Severity: 16, State: 1 Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.' for 'TCP://mymirror.mydomain:5022' b) On mirror server: Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error: 'Connection handshake failed. The login 'NT AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84.' . It states I do NOT hav ...Show All

• Windows Forms C# open a new form, and close a form...

  Well... i want to do this: open a form and close the form that is open... Example: Form_P f = new Form_P(); f.Show(); this.Close(); But, my program close.. why Hi jaomello: we have two ways for this problem: #1, Registering Form1.Closing event, cancel it and hide the main form #2, Start another thread for the second form: public static void ThreadProc() { Application .Run( new Form ()); } private void button1_Click( object sender, EventArgs e) { System.Threading. Thread t = new System.Threading. Thread ( new System.Threading. ThreadStart (ThreadProc)); t.Start(); } Beat regards! ...Show All

• Visual C# Inserting a List into a database

  If i have an ArrayList of items all with a different object value like Index(0) is "Hello" and Index(1) is "GoodMourning" how would i got about inserting that to a database...I want to insert the index and the value....the value being "hello" and "goodmourning" just to add, after executing the query, clear the parameters otherwise you will get an exception that there are more/less parameters than what is needed. cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); ...Show All

• SQL Server Access with an SQL Server backend.

  My question is this: "Does anyone know where to set up the connectivity for an access database to store data on an Sql Server " lamont_23 wrote: It was the answer, but I have tried that. I cannot get at the data source on the server. We have tight security here, that maybe the problem. Is there a way I can convince the Network Engineer to allow this It is the only way I can get something like this to work properly. Hi Lamont, First off, if you are using WindowsNT Authentication check that the account you are using is in the security node of sql server. If you are using domain security, you may also want to check the user of the NTWindows Account is added to the appropriate security group with the appropriate perm ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vista Compatibility

  Looking for any hints on when a Vista version will be released. (Note that I'm in the middle of installing the same version as everyone else is right now, but the web site says it won't be out for a bit). I really don't want to put a third OS on my system just so I can run xna express. (I've already got Vista Ultimate 32 and 64 bit on here - starting to get crowded) Dan Sounds good. Will try this set of instructions when I get home. Maybe I forgot to ask, but are you doing this under Vista 32 bit or 64 bit (I'm running 64 bit) At worst, I'll work in virtual PC. Slightly better than paving my machine and installing xp from scratch, then vista to a different drive. Cheers, and thanks ...Show All

• SQL Server Show table create date AND TIME for tables in a database?

  Is there a way to change the info displayed when working with tables in a database I'm really, really, _REALLY_ missing the timestamp component on in the "Created" column and would like to have it back if possible. Seems like it is there behind the scenes, but just isn't displayed. Did I miss a date format option setting somewhere Thanks for any assists Rob Hi, do you mean when a table was created That would be: SELECT name , crdate FROM sysobjects WHERE name = 'ErrorLog' Displaying when a rows was inserted you would have to create a default value on a column defining the GETDATE() as a default value. (...) InsertedAt DATETIME DEFAULT GETDAT ...Show All

• Visual C# Compare ArrayList

  Hello, I have 2 sorted array lists. e.g.  arrayList1 = a,b,c,d,e,f,h,k,l  and  arrayList2 = a,c,d,f,g,h,i,j ArrayList1 contains the list of strings that are to be compared against.  Unfortunately there are thousands of strings in each.  So I don't know if it would be any good doing something like; does arrayList[0] == arrayList[0]||arrayList[1]||.... (in a loop of course). Another thing, arrayList2 is getting its (distinct) data from a database so I can't really check it against arrayList1 there and then, as it would leave the connection open for longer... I don't know maybe this is an ok trade off I don't suppose there is an efficient arrayList1.compare(arrayList2) method out there   ...Show All

• Visual Studio Team System Project Creation Failed--Cannot connect to Sharepoint

  I am getting a Project Creation Failed error message--appears that it has difficulty connecting to the Sharepoint site. This is a clean install of the TFS trial on a Windows Server 2003 SP1 box with WSS 2.0 SP2. Any ideas on why this is failing I checked to make sure the port the TFS project creation wizard was using to access the site with the port specified in the Sharepoint Central Administration website and they match. Perhaps a complete uninstall/reinstall is the only answer... 2006-06-13 19:01:31Z | Module: Internal | Team Foundation Server proxy retrieved | Completion time: 0 seconds 2006-06-13 19:01:31Z | Module: Wizard | Retrieved IAuthorizationService proxy | Completion time: 0 seconds 2006-06-13 19:01:36Z | Module: Intern ...Show All

• Windows Forms Adding data to child tables using FormView and Object DataSource

  I have a FormView that displays all data in its item template view and another formview that displays related data. I am filtering the child data using the SelectedValue of the Parent FormView. The problem is when I want to add records; Adding data to the parent work just fine. but when I want to add records to the child table I don’t want the user to enter the id of the parent record, since the parent data is already displayed above it is understood that the user add child records to that parent record.. Unlike the read-only view I am not able to get the SelectedValue of the parent View. Is there any means to get the parent id... If the above problem is not clear, let me take an example: I am displaying details of an event ...Show All

• Visual Studio Debug Menu has disappeared

  I have uninstalled & reinstalled Visual Studio 2006 Professional, and now my Debug Menu has disappeared. I need to find it in order to attach to a process. Does anyone know if it's possible to get it back If memory serves, you don't get a debug menu until you're debugging. The "show processes" option shows up under the tools menu, I think. James ...Show All

• Visual Studio Express Editions open EXE file in computer with no Visual Studio installed.

  I am currently using VS C# 2005 express edition. There is a problem for me opening the EXE file generated by VS in other computer with no Visual studio installed in the computer, it shows an error messege saying that it cannot initialize the envirnment. If I try to open it in my own computer with VS installed inside, the problem won't occurs. How can solved this problem any help and suggestion is higly appriciated!! you need to download the .NET Framework 2.0 in order to run it on the computers and install it on the other computers. Only then will your .NET Developed application work correctly. you can also use ClickOnce to distribute your component, which will automatically download/install the .NET Framework for you and continue ...Show All

• .NET Development How detect particular COM port?

  Hi, on Control Panel -> System -> Hardware -> ports (COM and LPT) I usually have several COM ports: Communication device (COM1), communication device (COM2), etc. etc. Depending from the drivers (.inf file of added card), I could also have "Special communication device (COM9)", where COMx port depends from the computer. Now, how can I detect if my "Special communication device" is installed on my PC and which COM port corresponding There is a function for this in System.IO.Ports called GetPortNames(); It returns an array of type string that you can iterate through thusly SerialPort myPort = new SerialPort(); Foreach (string s in myPort.GetPortNames()) Console.WriteLine(s); ...Show All