NickNotYet's Q&A profile
SQL Server Query to another server
Hi, I'm trying to do a query from ine server to another, something like this: " SELECT * FROM FILESERVER . SharePointConnectingDB . dbo . vDepartmentsNames" where FILESERVER is the other SQL server name, SharePointConnectingDB is the the DB in the other server, etc. as a return i get the following error (in spanish becuse the server is in spanish): in El proveedor OLE DB "SQLNCLI" para el servidor vinculado "FILESERVER" devolvio el mensaje "Especificacion de autorizacion no valida". Msg 7399, Level 16, State 1, Line 1 El proveedor OLE DB "SQLNCLI" para el servidor vinculado "FILESERVER" informo de un error. Error de autenticacion. ...Show All
Visual C# Dll Import Problem In Loading two C++ Assemblies with Same Name
Hi, I have a C#.net application. I have two C++ dlls with same name (but different version numbers that i see in the dll). When I use Dll Import to invoke methods on each dll separately in two different applications, all the methods in both the c++ dlls work fine. But if i tend to use dll import and invoke the functions in the two dlls, the first dll's methods are executing fine but when the second dll's methods are invoked, there is an error stating "cannot load the second dll. method not found". I wonder if it is something to do with loading two same named dlls in the same memory of an exe... Please help in identifying the cause and kindly clarify my doubt. Many Thanks. Just as s ...Show All
Internet Explorer Development How to transfer binary data from the server to a client?
May be a wrong area for the question, but... How can I send a binary data from server to a client in IE6 via XMLHTTPRequest (is there any other way ) I did that partly in IE7, using the new property 'responseBody', but was unable to get size in bytes of the received data. How can I get this size in IE7 and perform this task in IE6 Thanks What do you mean by base 64 conversion. Will it work for unicode or any other charset data too Can you give me an example, for example how will it work on "hellow world" ...Show All
SQL Server SQL Server Management Studio - Windows Auth
Hi: I am trying to figure out if there is a way to connect via SQL Server Management Studio to a server sitting on a separate domain. So here is the situation. there is Server B which sits in a domain called DomainB. If I am in DomainA, I could typically remote into that server utilizing an IP address in DomainB, and even transfer files to that server. But how do I connect via SQL Server Management Studio(basically login as a different domain user) to Server B in DomainB from DomainA. Basically when I choose Windows Authentication from the dropdown list in SQL Server Management Studio, it grays out the username field, which is where I could type something like this domainB\usernameondomainB, similar to how you would connect to a sha ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Input suggestion
Please make also event based input option for Mouse and Keyboard. For example. 1.In Mouse and Keyboard, add EventDelegate like Mouse.OnMouseEvent, Keyboard.OnKeyEvent 2.We then just do Mouse.OnMouseEvent+= new MouseEventDelegate(game.OnMouseEvent); 3. OnMouseEvent should look like OnMouseEvent(object sender,MouseState state,MouseEventArg args) { //MouseEventArg tells us what button was pressed,released, wheel moved or //just x,y change } Thanks drEKO i understand what a "game loop" is...I am not beginner, I just need this as a OPTION , for more "GUI" oriented games. Gui system is also event driven in games as object oriented programming is and XNA should not be a exception. This addi ...Show All
.NET Development ConfigurationManager don't read values
Hi!. I'm trying to work with configuration files, but ConfigurationManager never read. I have a example value configurated in Settings. This value, configurate the App.config: < xml version="1.0" encoding="utf-8" > <configuration> <configSections> <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" > <section name="MyApp.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> </section ...Show All
.NET Development Using UpdatedRowSource with a Transaction
Hi all, I my current project, I have the following situation. We have a SQL Server 2000 database where some of the tables have primary key field that is set as an Idenity columns (i.e generates it's own keys) On the client application we use and ADO.Net dataset to retrieve and store data. Whenever rows are added to one of those tables, a pseudo key is created on int the client Data and we use the UpdatedRowSource to retrieve the actual value when the data is inserted in the database. The tables are most of the time part of a multitable dataset, so the updates are done in the correct order (delete childrows, delete parent rows, update & insert parent rows, update and insert childrows) to avoid referential integrity problems. These ...Show All
Visual Studio Express Editions Reports in VB Express Edition
Hi friends i have been working over a project in vb express edition, but the problem is , in express edition i dont have crystal reports, this is what i think if there is Crystal Reports in EX. Ed. Please let me kno how to install and use them, or any other alternative. plz help... VB Express doesnt provide crystal reports. In order to get this you need to buy a version of VB / VS. Details on what is in each version is at the following URL. http://msdn2.microsoft.com/en-us/library/b4z62wxz.aspx There are also other 3rd party controls you can use for reporting but the good ones you'll also need to purchase. ...Show All
Visual Studio Lost Keys (Problem deleting chars)
I'm not sure using the right section. If there is a better one, feel free to move this topic. Now my Problem: I can't delete any chars from my Source using Visual Studio 2006 Professional. I can insert code but i can't delete it. I can't insert a line using ENTER. BSP and DEL doesn't work. Coding without this keys is very... complicated. Is there anybody who knows to fix this problem Thanks I'm having the same problem with Visual Studio 2003. I'm unable to use the backspace or delete keys in the HTML view of any pages. I've tried deleting files out of the directories listed in the above post with no success. ...Show All
SQL Server Microsoft Association mining algorithem + ASP.NET 2.0
Hi I am working on an academic medical project. I have created PATIENT table PATIENT_ID NAME | CITY DISEASE table DISEASE_ID NAME | and Relationship table[FOREIGN KEYS]PATIENT_DISEASE PATIENT_ID DISEASE_ID I am using Microsoft association algorithm [SQL Server 2005 BI Studio] to find association between PATIENT CITY --> Associated DISEASE. I will be entering dummy data into these tables as this is academic project. I like to know can i be able to find the associated Disease/s with the PATIENT City with this algorithm such a way as soon as the user enters PATIENT City, assocaited Disease will be selected from the diseases table on web interface [asp.net ...Show All
Visual Studio read off file
Hi guys, I Have a file my rootdirectory, XXXX.txt, and I would like to read the contents of it because it contains the build number, for example 784940.1. I wanna be able to get that string and create directories with it. To create directories is pretty straightforward, but to read the contents of file I need some help. Thank you in advance, cdoloriert. I tried this where BuildNumer_ is the name of directory, for example BuildNumber_60725.10, with this code it should copy the files from BuildNumber_60725.9 <CreateItem Include="$(TempLocation)\BuildNumber_@(ItemsFromFile)\XmlConfig\**\*.*"> <Output TaskParameter="Include" ItemName="XmlFiles"/> </CreateItem> I got a error with thic co ...Show All
SQL Server Mix and Match Rows
In the trading (stock market) industry there is a practice of rolling up (merging) multiple trades into a single trade in an effort to save on ticket charges. The way this is done is performing a SUM() on the quantities and calculating an average price. (Average price is the SUM(Qty * Price) / SUM(Qty). So, given : Qty Price 20 $5 20 $10 You get: 40 $7.5 -- 20 + 20 and SUM(20 * $5, 20 * $10) / SUM(20 + 20) Here is my dilema: If given a set of trades, I need to loop through them and check every combination to determine which one matches the expected ...Show All
.NET Development Processing 'text' files, fixed width, .CSV, TAB or other delim
Hi All, I'm very new to .NET but do have a resonable level of experience with VB6... I'm trying to lean some more and want to start this learnng by way of a live project.... I have a file format of 5 fields of data, that I want to be able to collate from a number of people. I know each of the people that send me files of data will incude the 5 fields I require within their files but each of their files could be --> 1) Different in format (.CSV, TXT, or other delimertered) 2) Contain the fields in a different order 3) Contain extra fields, etc..... From each individual, the file formats/contenst will remain fixed but they will not necessarily have the ability their side to reformat the files. I would like to write a ...Show All
Visual Basic Replacing forms
In my program, It will be organized into forms that you can click a button and take you to another one. However, I can figure out how to make it so that when I click the button to take me to the next form, to make the original one disappear. This will be a major part of how you get around in my program, but if anyone can help, please do! Thanks When I do the form1.show() Me.close() it starts to show the new dialog, but then the program quits. I tried using just form1.show() and the next form came up, but the other one didn't disappear. Actually, is there a way that I can make different options come up in the same window when i push a button Thanks ...Show All
Visual Studio Team System Independent builds
I have a requirements of creating independent builds. I will try to explain the scenario. Let us assume that I have a baseline build already done. Now, I have work item (WI) 1 (that contains csharp code and some DML and DDL) and WI5 that contains the same things. With these two together, I create a build. Let me call it Build1. Again I have WO2 that has some C# code and DML and DDL. I need to create a build that will contain WO2 only. Let me call this build Build2. Purpose is I need to move these builds independent of each other. So, if Build Build1, only WI1 and WI5 will get promoted to the desired environment. On the other hand if Build1 should not move further, I need option of moving Build2 to the same environment where Build1 ...Show All
