I need help with getting just one row of a subtable for each entry in the main table. For example, let's say I have:
Applications
============
AppID AppName
1 Open Office
2 Paint.Net
3 Firefox
Contacts
========
ConID AppID ContactName
1 1 Bill Forbes
2 1...
I have a database that has a central table called applications, joined in a many to many relationship with three other tables, contacts, vendors, and servers. I.E., an application can be installed on multiple servers, or multiple applications can be installed on one server. The same goes for...
Hi,
I screwed up the data in one field in a database, but I had just done a backup prior (ain't THAT dumb!). Anyway, I restored the backup to a RESTOREDB database on the same server, now I want to UPDATE the original table with the restored values for that field, linked by the identity ID...
Hi,
I'm using VB.net 2008 and SQL 2008. I've got a SQL data source that works fine, but I need to get the column names from it so that I can fill a drop down. But there's no "table" element in the data source, and nothing else that I can see that would give me the column names. The data...
All,
In VS 2008 I have a gridview attached to a SQL 2008 datasource. It works perfectly, of course. I have an area on the form to let the user select the columns that are shown. I've tried updating the select statement, but when the user removes columns they don't want, the gridview throws...
Hello,
We've got a parent and several child domains running Windows 2003 native mode. We have a 2003 enteprise root certificate authority in the parent, is it possible for me to create a subordinate enterprise certificate authority in one of the child domains?
We have a Windows 2003 SP1 server that has been operational for a couple of years. We recently installed Windows Updates on the server, and after it rebooted, it cannot connect on the network.
Pinging anything from the server, you get "destination host unreachable". I've verified the IP...
I have Vista home premium running as my primary DVR at home. I also have digital cable with a cable box with a cable card. I want to marry the two of them together, so I can watch my digital cable on my Vista hi-def system.
Does anyone know of a cable-card compatible tuner for Vista...
Hey,
I just installed SUSE linux 10.1 on a Dell GX270. THe install went sweetly, but when it came up, the X window system is overscanning the monitor. That is, it is using too high of a resolution and refresh rate, so the monitor can't display it.
I can boot to the Failsafe mode and login as...
Hi,
I've got the following code, designed to query, stop and start a remote Windows service. It comiles happily, and runs nicely, with the status label changing dutifully as you hit stop or start.
The problem is, it doesn't actually touch the remote machine - the status label doesn't reflect...
I've got a form, which has a ton of fields. I am NOT using data binding. I programmatically create a data adapter and load the values into a table, then populate the fields on load.
When the user clicks save, I gather the data from the fields and generate an UPDATE command and use a...
Hi,
I've got a PC with Media Center 2005. I'm trying to map a drive to C$ on the PC, but I can't. What happens is I get prompted for a password, even if I use "connect with another user name" and supply a valid local username and password on the media center PC.
Obviously I can resolve the...
I have the following code, which is part of a project where I need to move the mouse to a specific location when the user performs an action. When I run it, I get:
PInvokeStackImbalance was detected
A call to PInvoke function 'TestApp1!TestApp1.Form1::mouse_event' has unbalanced the stack...
Hi, I need help! I'm working on learning VB.net and ADO.net, but I'm getting an error when I compile and run the following code. I THINK it's on the Dim Row as Datarow line, because one time when I tried to compile the code, I got a compile error on that line. But every other time I compile...
We have hundreds of servers, and we started looking at one due to reported performance problems. We found a high number of TCP connection failures. But we checked about a dozen other servers with no reported performance issues, and they too have high TCP connection failures - at least some of...
Hey,
I want to be able to back up three Windows XP Pro machines to a DVD burner on one of the machines. Is there any backup program that will let me do all of the following?
1) Backup files across a network to a DVD+-R drive on the remote computer
2) Bare metal restore the XP system using...
Hey,
I'm looking for recommendations for the best software to back up to DVD with. Specifically, I want to back up about 80GB onto multiple DVD+R's, and be able to bare-metal restore it (restore it with a boot CD, without first installing an operating system).
Having access to individual...
Hi,
I have Access 2003, and I've got two data access pages. I'm trying to add a filter criteria for a hyperlink, so the value of a drop-down will be passed to the second page.
I've tried putting the following in there:
lbxServer
lbxServer.Value
lbxServer.Innertext
<%=lbxServer.Value%>...
Hi,
I'm creating an Access 2003 "page" (web page) in an ADP attached to SQL Server 2000. I have a form with rows on it, and I need to do two things:
First, I need to call a number of stored procedures I have in SQL - how can I do that via an Access page?
Second, I need to pass the value of a...
Hi,
We've got a Compaq DL380 G2, with a built-in Smart Array 5i controller, operating fine. We want to put a SmartArray 3200 into the server, and connect the existing drives to that. I THINK it should be OK, and should recognize the array fine. Anybody have any experience with this?
Thanks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.