ozhonetech's Q&A profile

• SQL Server How do I create a Relationship in DB Diagrammer ?

  Hi Folks, When I try to create a Relationship between two Tables I find the Relationship is always created from the Table I start with to itself. I seem to have to select a Table to enable the Create Relationship option, and then when I 'Add' it creates a recursive Relationship to that Table. I guess it must be possible to do what I am trying to do I'd appreciate any advice. Thanks. Barry You need to add at least 2 tables (relationFrom/To). When you have your tables on diagram surface click and drag the key column on to foreign key column of other table. ie: If you have 2 tables: Customers: CustomerID primary key Orders: CustomerID foreign key Click and drag Cust ...Show All

• .NET Development ASP.net C#, sending email error-the client was not authenticated.

  Hi, everyone: Hope I can get some help here. I've been working on this problem for two days and checked all the resources, but no luck. I'm a beginner of ASP.net C#. and recently working on an application try to send out emails. Below is my code and error message I got: (I used system.net .mail) ///////// code in web.config < add key = " MailServer " value = " 68.142.198.11 " /> < add key = " EnableErrorLogEmail " value = " false " /> < add key = " ErrorLogEmail " value = " XXX@sbcglobal.com " / > < add key = " ProductsPerPage " value = " 6 " //////code in utilities.cs public static void SendMail( stri ...Show All

• Microsoft ISV Community Center Forums Advanced VBA (on Excel) calculation using GPU

  Hi. I'm chemichal engineer and I work with VBA on Excel. I need to do a large amount of calculus (obtaining between 500 thousand til 16 million, not counting iterations) so I’m searchin' the way to use GPU as a second processor (I'm not working with gaphics) to accelerate my work. Is this possible Thanx. Hi, For your application, VBA is not your choice. I would suggest you to write your program in C/C++, make it a DLL , and then use VBA to build up the interface between Excel and the DLL . Finally, you can call those VBA wrapper functions in Excel as worksheet functions. A more fancy way to do is create a Excel Addin in XLL . (DLL using the Excel C-API interface). If you use Excel 2002 or above, and you have Visual Studio ...Show All

• SQL Server Suspect mode ... cant even attach mdf file using sp_attach_db

  Hi, In sql server 2005... I am trying to take a backup, When i was trying one of my database is marked as suspect, I tried lot of ways finall i tried stopping the service , and copy mdf,ldf files of that database ...and again started the service ... pasted it in other server and tired to attach using sp_attach_db it shows database cannot open, I/O error occured..i also tried sp_singlefile_attach_db Can any one tell me how to bring suspect mode database to normal mode... also how to solve the I/O error when attaching mdl , ldf files. i am sorry , i am using this syntax only... Exec sp_attach_db @dbname = N'TfsworkitemTracking', @filename1 = N'C:\Programfiles\mssqlserver\mssql\data\TfsWorkitemTracking.mdf', @fil ...Show All

• Visual C# Problems with Generic Collection class.

  Hi I’m working on a system that has 4 different types of client they have mostly the same attributes so I decided to create an interface IClient for them to implement and then just add the differing attributes as needed to each client class. Now I get the Client information from a DB and Load them into a Generic dictionary The class looks like so class Class1 <T> : Dictionary < int , T> where T: IClient { private IndemnityScheme scheme; public Class1( IndemnityScheme scheme) { this .scheme = scheme; } public int Load() { ...Show All

• Visual Studio There is no source code available for the source location in Visual Basic.net

  I worked on an a VB app at my college lab and it debugged perfectly. But, for some reason my home copy of Visual Studio Pro won't let me debug the app! I get a message saying VSHOST error, and that there is no source code available. How in the world do I fix this thing! Please advise!!!! Try the following: Go to the project properties for your VB project, go to the debugging tab and switch off the "use vshost" option. Rebuild your application clean and try. John ...Show All

• Visual Studio How to get the total of pages of the reportviewer?

  Hi! My customer didn't like the reportviewer toolbar, so I'm making one with the print option and the page navigation option as well. i know hot to navigate throu pages, but I don't know how to get the total number of pages... Is there any way to know the total page numbers of the report in reportviewer Thanks for your help. Bernardo Piano wrote: Hi! My customer didn't like the reportviewer toolbar, so I'm making one with the print option and the page navigation option as well. i know hot to navigate throu pages, but I don't know how to get the total number of pages... Is there any way to know the total page numbers of the report in reportviewer Thanks for your help. HI, Can You tell ...Show All

• SQL Server Database creation using VB.NET Code

  Hello. I think its silly question but i expect some solution . Is there any way to create sql sever database by using VB.NET code I have to create database,tables,sps and also transfer the data from one database to newly created database. Please, if somebody have some solution then guide me in detail. Thanks in adv. I found where the mistake was. Instead of using WITH MOVE 'myDatabase' I wrote it as WITH MOVE 'myDatabaseNew'. This was the reason for the error. Its working well now. Thanks ! ...Show All

• SQL Server Not able to receive the mails

  Hi, I have an application which has to send mails based on some conditions using sql server notification services. The problem i am facing is that i am not receiving the mails even though the delivery status description is Delivery Succeeded. Could you tell me where exactly the problem lies. Thanks in advance. Are you using the local SMTP service on the box Or are you using an Exchange Server somewhere else on the network If the former, check the c:\inetpub\mailroot folders to see if your messages are stuck in there. If they are, check to ensure that the SMTP service is running on the local box. Are you using 2000 or 2005 HTH... Joe ...Show All

• Software Development for Windows Vista The UAC Nightmare

  I'm beginning to reach the conclusion that the current implementation of the UAC in Vista is, IMO, a nightmare that creates more problems than it solves. If Microsoft wants developers - and users - to embrace the UAC (instead of just turning it off altogether) then it better come forward with a LOT MORE information and support than it is currently providing! If it doesn't, I will begin to suspect Microsoft only added the UAC so it can tell Windows users 'well, we added the option to secure Windows - you're the ones turning it off' and therefore wash its corporate hands. I would really hate to see this happening. To name just a few of the problems the UAC brings to us developers: 1 - Applications that require Admin privileges are bloc ...Show All

• Visual Studio 2008 (Pre-release) WIC required?

  So is a seperate WIC download going to be required for all .NET 3.0 apps that use imaging I have an app that wouldn't run without WIC on RC1 does the RTM include these components Windows Imaging Components (WIC) is part of the .NET Framework 3.0 redist. You do not need to download and install it separately. So yes, the RTM version of .NET 3.0 also includes WIC. ...Show All

• SQL Server HOW TO DELETE OLD BACK UP FILES AND TRANSACTION LOGS IN SQL 2005

  SQL 2005 DOES NOT HAVE THE SAME FEATURE THAT WAS IN 2000 TO DELETE OLDER FILES OLDER THAN CERTAIN DAYS. I DO HAVE A JOB THAT CREATES A FULL DAILY BACKUPS BUT SINCE I DON'T HAVE ENOUGH SPACE, I WOULD LIKE TO FIND A WAY TO DELETE ALL OLD BACKUP FILES OLDER THAN X AMOUNT OF DAYS AND ALSO DELETE TRANSACTION FILES OLDER THAN X AMOUNT OF DAYS. IS THERE A TOOL TO DO THIS. CAN ANYONE HELP PLEASE. EMADKB This is exactly what was happening to me- our plan had "*.bak" as the extension, which caused the maintenance plan to do nothing. When I changed it to "bak", it began working perfectly. It would be nice if MS added some validation logic to the maintenance plan designer to check for things li ...Show All

• Visual C++ Connection timed out - socket error crashes my program

  Hello forum, I'm desperate. I made a class in a client application, which has a function that loops through a series of hosts. However, when it finds a "connection timed out" error, it simply crashes with "std::out_of_range memory location" - when I just want it to go on without connecting to that server. It only breaks after the 2nd iteration - the first goes by smoothly, the 2nd crashes. What can I do [code] void Escalonador::Conecta(char* endereco){ MAQUINA temp; // variaveis de socket. WSADATA ws; int err; // verifica erros hostent *host; // dados do servidor SOCKET s; // descritor de socket SOCKADDR_IN addr; // endereco IP do host // testa a DLL associada a socket (WS2_32.DLL) cout << "Inicializando DLL... ...Show All

• Silverlight (formerly WPF/E) Is it possible to change the storyboard.targetname's value by Javascript?

  I've tried to use Javascript to change the value of storyboard.targetname and storyboard.targetproperty, but it is not work. If it is supported in the future, that will be very wonderful. we can create a canvas.triggers at first, and use js to change the storyboard's value in the canvas and begin it. At now, in my UI project which is used in wpf/e , i only can create all the storyboard where i will be used at first, and start them one by one. The XAML code is very long ... I used the method of adding a new Canvas with a new StoryBoard and DoubleAnimation affecting (Canvas.Top). When I run storyBoard.begin(), the Target immediately changes positions with no animation in between. I found that if I added a ...Show All

• Visual Studio Express Editions The name 'txtPlayerMove' does not exist in the current context

  Hi, I'm very new to C# and I'm trying to insert a text string into a text box that sits on a form in the same project. The class that is trying to send the string to the text box is in a different file than the form code. I get this error: "The name 'txtPlayerMove' does not exist in the current context" from this code: public bool throwSnow(int range) { //calculates likeliness of a hit at a given range //returns true if snowball hit bool hit = false; int myRoll; Random roller = new Random(); if (snowballs <= 0) { txtPlayerMove.Text = Convert.ToString(name + " is out of snowballs!"); } ... (i didn't include the rest of the code) I'm ...Show All