Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Databases

54K

Solutions

39K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am trying to reinstall WSUS 3.0 SP2 on a 2008 R2 server.  This server originally had WSUS 3.0 on in and had been uninstalled including logs, database, etc  If fails when I try to install it either from Add Roles in Server Manager or from a Downloaded WSUS 3.0 SP2 .exe (WSUS30-KB972455-x64.exe).  Following the progress of the install, is gets to the Configuring the Database step and fails with "There is a problem with this Windows Installer Package.  A program run as part the the setup did not finish as expected.

Any help will be greatly appreciated.  I am out of ideas and don't understand the setup logs (attached).

Thanks in advance
ajw
WSUSSetup.log
WSUSSetupmsi_170921_0906.log
0
Free Tool: Site Down Detector
LVL 10
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

We are running MS CRM 2016 on a single server utilising ADFS (installed on the CRM server) and Claims Based Authentication. We would like to add a second Company using a copy of the live database for testing purposes, using the concept within this link (not worried about the Resco side of things as we do not use it):

https://blog.resco.net/2017/05/24/how-to-create-a-copy-of-your-production-crm-database-for-testing-resco-mobile-crm/

Does anyone know if this will cause any issues with the ADFS or Claims Based Authentication or anything else?
0
I've encountered a rather strange problem that I could really use some help with. In a database that I've created, I've created some code that if an edit is made to one of the tables, it will send out an e-mail that will inform people of the change. The code itself has worked great in most of the databases, except for one. With that database, it causes an error upon reaching the specific line :

Set oApp = CreateObject("Outlook.application")

The error caused is Automation Error Library Not Registered 2147319779.
What really confuses me about this error is that the code is exactly the same as the other databases other than a few name changes for the queries it uses. Yet this one just doesn't work. I ran Office Diagnostics and it came up with no errors, and both Outlook and Access are the 2007 versions.

If anyone has any ideas about how to fix this problem, I would be really grateful.
0
Shift are of four types.: A,B,C,G
After 6 days Off.
How to make this database so that at the end of the month we check there attendance. Shift changes aftet every 2 days.
0
Hi Experts,

I moved from a mailboxdatabase in a dag group all users to a new database as we had a problem with backup VSS errors.
Now backup is running fine again and i want to remove the database from exchange , I did remove the replcation from that database in ECP.
Trying to remove the database now but it comes up with that there are still arbitration boxes left .
Boxes that ae left are :

[PS] C:\Windows\system32>Get-Mailbox -Arbitration |ft Name, Servername

Name                                                        ServerName
----                                                        ----------
FederatedEmail.4c1f4d8b-8179-4148-93bf-00a95fa1e042         Servername
SystemMailbox{1f05a927-6d22-4469-8071-9dc0930d1efe}       Servername
SystemMailbox{e0dc1c29-89c3-4034-b678-e6c29d823ed9}      Servername
SystemMailbox{bb558c35-97f1-4cb9-8ff7-d53741dc928c}        Servername
Migration.8f3e7716-2011-43e4-96b1-aba62d229136                 Servername
Can i remove these mailboxes? i dont know if they are also used for other databases that are still left in our exchange envoirment?
Thanks.
0
Hi,

We are migrating from Exchange 2013 to 2016 but when uninstalling 2013 receive this error:
This computer is a member of a database availability group (DAG). It must be removed from the DAG before you can uninstall Exchange

No DAG exists, if i go into ADSIedit.msc within CN=Database Availability Groups nothing exists either...?

Any ideas?

Thanks!
0
Hello,

I have a HTML "Contact" page.
When you click Submit it uses a contact.php file to write to a database.
Currently I am getting this error. It relates to adding the next ID automatically but I can't seem to get it working.
Is anyone able to assist please?

Here is the error:

Capture.JPG
My PHP file is below.

<!DOCTYPE HTML>
<html>
<head>
<title>Contact</title>
<meta charset="utf-8">

</head>
<body>

<?php 
error_reporting(E_ALL);
ini_set('display_errors', 1);
?>


<?php 

  /* Set oracle user login and password info */
  $dbuser = ;  
  $dbpass = ;  
  $db = ; 
  $connect = oci_connect($dbuser, $dbpass, $db); 

   /* Display connection error if fails */
  if (!$connect)  {
    echo "An error occurred connecting to the database"; 
    exit; 
  }
  
  

  //Extract CGI variables
  $firstname=$_POST['firstname'];
  $lastname=$_POST['lastname'];
  $address=$_POST['address'];
  $phone=$_POST['phone'];
  $email=$_POST['email'];
  $subject=$_POST['subject'];
  $comment3=$_POST['comment3'];
 
  

   /* check the sql statement for errors and if errors report them */
  $stmt = oci_parse($connect, $query_count); 

  if(!$stmt)  {
    echo "An error occurred in parsing the sql string.\n"; 
    exit; 
  }

  oci_execute($stmt);
  if (oci_fetch_array($stmt))  {
	
	$count = oci_result($stmt,1);//returns the data for column 1 
	echo "<strong><font color=red>* * The below SQL INSERT INTO Statement is displayed for the purpose of Assignment 2-2 to verify 

Open in new window

0
Hi i've got a database table (user_group_join) with the following tables:

    user_group_join_id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
    user_join_id int(11) NOT NULL,
    group_join_id int(11) NOT NULL,
    FOREIGN KEY (user_join_id) REFERENCES users (user_id),
    FOREIGN KEY (group_join_id) REFERENCES user_group (group_id)

They are populated as follows:

user_join_id = 75
group_join_id = 12
user_join_id = 75
group_join_id = 13
user_join_id = 75
group_join_id = 14

What i need to do is when performing a insert query if for example I change the value 12 from group_join_id to 13 i should only have:

user_join_id = 75
group_join_id = 13
user_join_id = 75
group_join_id = 14

This is my php code, i'm deleting the value first and then add the new one if it is not already stored in the database:

$delete_join_group = mysqli_prepare($conn, "DELETE FROM user_group_join WHERE user_join_id=? AND group_join_id=?");
mysqli_stmt_bind_param($delete_join_group, 'ii', $client_id, $old_group_id);
mysqli_stmt_execute($delete_join_group);
mysqli_stmt_close($delete_join_group);

$new_join_group = mysqli_prepare($conn, "
INSERT INTO user_group_join (user_join_id, group_join_id) 
SELECT ?, ? FROM user_group_join 
WHERE NOT EXISTS (SELECT user_join_id, group_join_id FROM user_group_join 
      WHERE user_join_id=? AND group_join_id=?) 
LIMIT 1 ");
mysqli_stmt_bind_param($new_join_group, 'iiii', $client_id, $new_group_id, $client_id, $old_group_id);

Open in new window

0
Is there any way to see what the roughy 10 million Bitcoin transactions per month are being used for? And how much of that is being used commercially in normal business transactions?

And what about micro-transactions?

Thanks
0
I have an Access database written to keep track of events.  I am trying to combine the following two queries and have the results added together.  Both of these work independently, just trying to find the easiest way to combine their numeric results.  In the second example, the "Spouse" field is blank.  Any help is appreciated.

SELECT Count([Invitee])+Sum(Abs(IsNull([Spouse])=False)) AS RSVPYESCount
FROM Invitations
WHERE (((Invitations.EventID)=[Forms]![Events]![Invitations_Subform]![EventID]) AND ((Invitations.RSVP)="Yes"));

SELECT Count([Invitee]) AS RSVPSpouseOnly
FROM Invitations
WHERE (((Invitations.EventID)=Forms!Events!Invitations_Subform!EventID) And ((Invitations.RSVP)="Spouse Only"));
0
NFR key for Veeam Agent for Linux
LVL 1
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

KB2463332 simply fails to install.  What am I missing here?
0
I am creating an inventory database to keep track of hosts in the company building. If a host is scrapped, I can tick the tick box in the 'Scrapped?' field for the host in question and it will appear in the scrapped hosts query. How would I go about automatically populating the field 'Date Scrapped' with today's date, so for future reference I don't need to input the date myself.

Thanks in advance if you can help
0
Hi

I have inherited an old database which uses a MS Access Frontend to Import data into a SQL Backend via SSIS package .
It appears the connections to SSIS in the following Access DB Vb script fails as it only complies with TLS1.0 and not TLS1.2 as desired when using web based access.
Code:
cnn.ConnectionString = "Provider=SQLOLEDB;Data Source=MySQLData;Initial Catalog= MyProject;User ID=MySSISImport; Password= XXXXX;"
    cnn.Open

To resolve this to be TLS1.2 compliant should I be looking for
1- A security patch for SSIS
2- Re-write connection string an alternative way

Thanks
0
Please help folks.

How to club this two logics together for a single field. Field name is description.

1.) case when right(rtrim(Description),1) = ',' then substring(rtrim(Description),1,len(rtrim(Description))-1)
2.) replace (replace (Description, char(10), ''), char(13), '') Description,

Please help.

Thanks in advance
0
Hi
I have a theoretical question around a database that I am building.

I have modelled what I am trying to do on a white board.

In summary, I have three tables which allow for the recording of accidents on site.
The tables are Staff, Visitor and Pupil.

Now, I would like to have one master table which will chronologically list each 'event' and bring in the primary key from each of the Staff, Visitor and Pupil as a foreign key in three separate columns.

What I don't know is, am I going about this the right way and also are there any pitfalls that I have not thought of with what I am trying to do.

So, I guess what I would like if it can - or should - be done, is to have each 'event' create a new row in Master as it saves with the PK as a foreign key in master.

What I can see straight away, is that I am likely to have issues around the timeline in master.

I will be building the front end with PHP Runner.

I do hope this makes some sense

Also, if anyone knows of an affordable beginners course in MySQL that is online, I would be eternally grateful.

Thanks for reading,

Martin


Whiteboard model
0
I was told on EE that until the transaction has been finalized, there was some odd code returned. It contain "0/" if I recall and perhaps the word 'unfinalized" or something similar.

Please give me ALL the possible return codes that Bitcoin can send. And explain what you are supposed to do with that information, when you are in the middle of making a sale.

I still to not understand how people can be buying products and services with Bitcoin when I see the finalization time can be long, like over an hour.

Of the transactions people are making with Bitcoin, what kinds of products are they selling? And do you think the sellers might be accidentally giving the goods prematurely, but this goes un-noticed since the money's nearly always there?

It sounds like for a crook to fabricate a "double-spend theft," it would be rather tricky anyways. So, are sellers just grateful to get the sale and giving out the product pre-maturely? Or, in the case of in-line ordering, are they just waiting until the finalization comes through before sending our the product?

Thanks.
0
Good afternoon,
I would like to add a date and time when saving to my database (like a date time stamp) but I don't know  how to set the a default date (date.now) and then pass it to my controller when I submit. As I stated in my previous post I'm new to MVC  so I appreciate your patience.

model
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;

namespace BiciPublica.Models
{
    public class Usuario
    {
        public int Id { get; set; }
        
        [Required]
        [StringLength(80)]
        public string Nombres { get; set; }

        [Required]
        [StringLength(40)]
        [Display(Name ="Primer apellido")]
        public string PrimerApellido { get; set; }

        [Required]
        [StringLength(40)]
        [Display(Name = "Segundo apellido")]
        public string SegundoApellido { get; set; }

        [Required]
        [StringLength(30)]
        public string Cedula { get; set; }

        [Required]
        [Display(Name = "Fecha nacimiento ")]
        public DateTime FechaNacimiento { get; set; }

        [Required]
        [StringLength(5)]
        public string Rh { get; set; }

        [Required]
        [StringLength(10)]
        public char Genero { get; set; } 

        [Required]
        [StringLength(200)]
        [Display(Name = "Dirección")]
        public string Direccion { get; set; }

        [Required]
        [StringLength(200)]
        

Open in new window

0
I had this question after viewing Show details of selected record at top of the datasheet.

How can I accomplish this https://www.screencast.com/t/HZNWrukfn ?
0
I had this question after viewing Make this access database run in protected mode from a file share.

How do I show the details of this selected record at the top of the datasheet?

https://www.screencast.com/t/GiMJscb5V
0
On Demand Webinar - Networking for the Cloud Era
LVL 10
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

All this database has thus far is a table but also needs an entry form that is unlikely to corrupt the database if opened and edited by several users at once from a file share.
IDCom.accdb
0
DB2 10.5 on Windows

My database is about 300-400 GB.  My full once a week backup is 370 GB.  It is growing at a moderate pace (maybe 10% per month).  Yet when I do daily Delta backups, the file sizes are huge.  Here is what I am seeing.

Sat          Full Backup     371 GB
Sun        Delta                118 GB
Mon       Delta               120 GB
Tues       Delta               122 GB

There is no way my database is growing by 100+ GB per day.  The only other thing I can think of is that there might be a process that is updating a single field on multiple tables over and over again.  Maybe a timestamp or something.

So my question is, is there something about deltas that I don't understand?  Is a delta always 20% of database + actual data changed or some such?  Nothing I have read indicates that but I can't reconcile what I am seeing with what I know so far.  Any suggestions for find the root cause?  

Thank you!

Jim
0
I have 4 tables: Distributors, States, Counties, DistibutorsCountiesLookup

I am associating distributors with counties within a state. A state may be divided between many distributors. A distributor in linked to a state/county via the stateID and CountyID. So the lookup table has DistributorID, StateID, CountyID. When I switch states using a combobox, I want to return the counties in that state that are assigned to the selected distributor or have not yet been assigned. Here are the tables.

tbl_States
StateID (PK)
State
StateAbbreviation

tbl_Counties
CountyID (PK)
StateID (FK)
County

tbl_Distibutors
DistributorID (PK)
Distributor

tbl_DistributorCountyLookup
DistributorID (FK)
StateID (FK)
CountyID (FK)


Thank You,
Randy
0
What we learned in Webroot's webinar on multi-vector protection.
4
Hi,

  I need to grant the 'SELECT' privileges to a user for a View that belongs to another database, but i do not want to grant 'SELECT' to any table of that database to the user, or even any of the tables that belongs to that view.    What happens is that I only want that user to be able to 'SELECT' to that view, for specific fields that belongs to that view.

  For example.., if the views is built using TABLE A  that has 8 fields, but in the view the display is only viewing  3 fields of that table, the user must be able to SELECT  the view for only to see the fields that belong to the view, but can not see the others fields of the table, or any other table of the database.
 
  Can i do it in MS SQL Server ?

Regards,
0
I have a query, when I try to run it commenting a logic defined below, it runs fine.

But I need to include this logic and run the query, the query is taking hell lot of time. 2 hours for 1 lakh record.

PLEASE HELP ME CHAMPIONS.


SELECT
--CASE WHEN (select distinct  1
--from TBL c            
--where EXISTS (SELECT 1 FROM TBL1 leave            
--               WHERE convert(date,c1.DT) = leave.DT
--                 ))
--IS NOT NULL THEN 1 ELSE 0 END AS LEAVE

FROM (select *,
case when test= 'A' then DATEADD(hour,8,Date)  
     when test=  'B' then DATEADD(hour,2,Date)  
     when  test= 'C' then DATEADD(hour,-4,Date)
     else Date end as DT

 from STAGING c
 ) c1
0

Databases

54K

Solutions

39K

Contributors

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.