Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Databases

55K

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 unable to back up database in a particular DAG server.it is through commvault.

reason: Failure Reason: The job is pending because: The destination encountered an error while processing the data from the source.  
 Number of restarts has exceeded the maximum number allowed [10].

Error Code: [82:156]
Description: The job is pending because: The destination encountered an error while processing the data from the source.
0
Keep up with what's happening at Experts Exchange!
LVL 11
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Hi

I am looking for a Microsoft Access accounting template for use by a small business.
I want a raw Access file that can be fully customized if needs be.
Does Microsoft have anything like this?
I want something that does more than just simple journal entries. I would like to have tables for invoicing etc.
I am already aware of the Northwind database so looking for something else.

Thanks
0
This is the last question regarding this webpage. I have records from a database for the last 2 months being displayed on a webpage. It shows the older month on top. I tried to put tables side by side which worked but only 1 header would display for some reason. I am ok with the tables being display 1 on top of the other I would like the most recent month on top. Any time i try and change the display the code has an error and displays nothing. I am not sure if I have to break the data out when displaying. I have attached code and screenshot. I would like Jan on top and then December as there will be a lot of records so will probably have to scroll. Help is always appreciated.
Before.jpg
index.php
0
Hi. I know this is a simple question.
But when I try it out, my database keeps not responding and I have been reopening it a couple of times.
Would like to just check if my code is okay

I'm just using a For loop to number 1,2,3 in the WeekNo Column.
The 123 will keep on repeating.

Function seq()

 Dim i As Integer
 Dim db As DAO.Database
 Set db = CurrentDb()
 Set rs = db.OpenRecordset("NewTypes", dbOpenDynaset)
 
While rs.EOF = False

    rs.Edit
    For i = 1 To 3
 
        rs("WeekNo") = i
       
     Next i
Wend
rs.Close
End Function


Thank you!
0
I am trying to pull data from a access database.  I then want to take this data and send it out in a mail merged email.  I am using a table that has the following:

Name                  address                           class
Bugs bunny        BBunny@me.com           Rabbit
Bugs bunny        BBunny@me.com           carrot eater
Bugs bunny        BBunny@me.com            Hole digger
Bugs bunny        BBunny@me.com           Varmit
Daffy Duck         DDuck@me.com             Duck
Daffy Duck         DDuck@me.com             Space Duck


what I'd like it sto be able to combine all of the class flield into one so that each character has only one line.  Like this:


Name                  address                           class
Bugs bunny        BBunny@me.com           Rabbit, carrot eater, Hole digger, Varmit
Daffy Duck         DDuck@me.com             Duck, Space Duck

This would allow me to send only 1 email per name, not the 4 for bugs bunny and 2 for daffy duck.  (all the names and email address have been changed....)

Appricate any help I can get.
0
Hello All,

I want to prevent users opening the same access database twice,
to open different databases is okay.
Thanks
Have a nice weekend, All
0
Hello,

I am creating a form which pulls information from my SQL database. Initially my form had two fields, 'language' and 'prefecture' . Thanks to Julian Hansen on this forum, I managed to get the form to work, so that when no values were returned the form processed correctly. My code to do this is below:

  <?php
  
  $language = $_POST['language'];
  $prefecture = $_POST['prefecture'];
  
  $sql = "SELECT * FROM teacher_table WHERE language = '".$language."' AND prefecture = '".$prefecture."' ";
  $result =mysqli_query($db_connection, $sql);
  
  if (count(mysqli_fetch_array($result)) > 0)  
 		{
 
 ...displays output
 
 else{
      // No Results
      redirect_to ('no_results.php');
      db_disconnect($db_connection);
      exit;
      }

Open in new window


However, I am now trying to add a checkbox to the form which has the function of basically   'only show values where photo field entry =1'. So that only entries with photo field = 1 are returned if it is checked and if it is not checked all entries (photo field = 1 or 0) are returned.

 I therefore tried to amend the statement to:
 $sql = "SELECT * FROM teacher_table WHERE language = '".$language."' AND prefecture = '".$prefecture."'  AND   photo = '".$photo."  ";

Open in new window

 
However, the problem with this is (I think?) relates to this line:

if (count(mysqli_fetch_array($result)) > 0)

Open in new window


 If no results are returned from language and prefecture, a result is always returned from photo (either checked or unchecked -1 or 0) so results is always greater than 0? I think that's what's happening from when I run the code. And also, when this box is not checked, it only returns values which are 'not-checked' i.e. 0. It should returns '1 'and '0' values.  

So I'm kind off stuck. I guess I'm looking for a way to use a checkbox in a form where if it is not checked, all values corresponding to that checkbox are returned, and if it is checked, values corresponding to that checkbox which are 'checked' or '1' are returned only.

And I want to do this in a way which doesn't interfere with my  if (count(mysqli_fetch_array($result)) > 0
0
Hi,

Currently, we use a template on VFP and we get our data from a Visual FoxPro database. So, we have fields on this template directly from the database. Then, we convert this template to PDF.
Our clients use our invoicing system - what we now want is to link these invoices to a statement. So, we want to create a new field on the database and use that field on our template to store the path of the invoice linked to the statement.
When we convert this template to PDF, we want to be able to access the path as a hyperlink. So if we click on that invoice, it opens up the invoice wherever the path is pointed to.

Please assist or alternately advise on a better method. You can also email me - shamina@oficinagroup.com

Many thanks,
Shamina
0
Queries that use a join always baffle me so I could use some expert advice. Thanks in advance...

How to I write a ColdFusion query where:

I have one database called "Visitors"

I have 2 tables in that database:
"Users" is a table with my entire membership listing
"EmailSent" is a table listing every newsletter sent to each member

The common field is "UserID"

Within EmailSent is a field called "TemplateUsed" which is a different template for each version of the newsletter.

I need a query that will output the UserID's of those members who did not yet receive a particular template called "ImportedCareerCoach5.cfm"

But they may have received other newsletters.

Hope that makes sense.

 I'm running CF 10 and MS SQL
0
I have a Microsoft Access 2002 database.

I would like to set up "Security" where:

User #1:  Can change the data and design of the database (i.e., the Administrator).

User #2:  Can only update data, view and print reports.

User #3:  Cannot update data, but can "View" the data from the "Forms" screen and "Print" reports.

I use Visual Basic to program command buttons on the Form, which enables users to "find" client records, and "Print" client records.

Thanks for your help!
0
Windows Server 2016: All you need to know
LVL 1
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

I have been going through a fairly large tutorial on MVC with Entity Framework.  All the lessons contained within have been working fine as have other tutorials.  But the same problem has occurred once I try to change the data source from the VS2017 app_data mdf file to a connection to a local SQL instance.    The code fails, either cannot locate the server or that the database is in uses.

I do not have an SQL Server installed locally, and so I assume that the external to the VS environment server is SQLExpress.  I have tried from the package manager console Add-Migration SomeName  followed by Update-Database.  The Update-Database fails sometimes and the initial pull of a set of rows for the start of the application fails other times telling me that either the table isn't there or that it cannot be dropped etc.  A nightmare of problems created the moment I try to use a connection string in my web.config.

I will include the contents of the web.config here and hopefully someone will have some ideas as to how to fix this.

<?xml version="1.0" encoding="utf-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  https://go.microsoft.com/fwlink/?LinkId=301880
  -->
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, 

Open in new window

0
Hi all,
I've created a basic search form with 2 inputs from drop down menus which will return results to a results page. My two input fields in the search form are 'language' and 'prefecture'.

My code php below  displays the correct results when there are results in the database. However, when there are no results in the database which match the search criteria,  the code doesn't do what I hoped it would do (i.e. redirect and disconnect). All that happens is that no results are displayed in my results page.  

Any idea what I am doing wrong? Many thanks for reading.

Regards,
Adam

<?php

$language = $_POST['language'];
$prefecture = $_POST['prefecture'];

$sql = "SELECT * FROM teacher_table WHERE language = '".$language."' AND prefecture = '".$prefecture."'";
$result =mysqli_query($db_connection, $sql);

 if($result) { 
    // Results
	While ($rows = mysqli_fetch_array($result)){
	echo $rows['firstname'];
	echo $rows['language'];
	echo $rows['prefecture'];
	}

	
    }
	else {
    // No Results
    redirect_to ('no_results.php');
    db_disconnect($db_connection);
    exit;
    }

?>

Open in new window

0
Hi,

Is there a way to set up a variable that is stored and used again and again in the database (Oracle).  I want to set the financial Year to 2017.  It's used over and over again in stored procedures and views etc...  When it's changed, it should be changed in everything.

Like a global variable but where do you declare it etc...


Kind regards,
Caoimhe
0
<?php
include_once("database-config.php");
      session_start();
      

      $strDateNew=date("d-m-Y H:i:s");
       if ($_SESSION['userid']){

      $queryString = "update admin set outtime=NOW()  WHERE  userid = '$_SESSION[userid]' and intime='$strDateNew' ";
        $result1=mysql_query($queryString)OR die("Error:".mysql_error());
        echo "$queryString";
        }
        if(session_destroy())
   {
    header('Location: index.php');
}
   
      
?>here  userid passes 0 to database ,i want userid so that in every month i dispay userlogin and logout time  so kindly help me
here is also my authentic.php
<?php ini_set('display_errors', '1'); ?>  
<?php
include_once("database-config.php");
 
  session_start();
 $username=$_POST['username'];
 $password=$_POST['password'];
 $userid=$_POST['userid'];
 $username=stripcslashes($username);
 $username=mysql_real_escape_string($username);
 $username=htmlspecialchars($username);
 
 $password=stripcslashes($password);
 $password=mysql_real_escape_string($password);
 $password=htmlspecialchars($password);
 $sql="SELECT * FROM userregister  WHERE username='$username' and password='$password'";
$result=mysql_query($sql)OR die("Error:".mysql_error());

 $row=mysql_num_rows($result);
$userinfo=mysql_fetch_assoc($result);
$_SESSION['userid']=$userid;
 $role=$userinfo['role'];
 
 if($row==1){

  $_SESSION['login_user']=$username;
  $_SESSION['role']=$role;
  $_SESSION['userid']=$id;
  $_SESSION['username']=$username;
  …
0
Would like to brainstorm: out there what are the controls/measures organizations put in place
when transferring/processing data (within same company) but across countries (which has
different laws & regulations) ?

So far, thought of the following:  pls add on or comment.  Certainly remove if there are
irrelevant ones.

Endpoint
-      Endpoint Encryption (if data flows to endpoint): what about data at rest??
-      USB lockdown

Gateway
-      Web Scanning
-      Email screening

Servers / DB
-      Database Activity Monitoring?  Is built-in DB audit trail sufficient or need
        DB activity monitoring tools like Imperva ?
-       Data masking of card# (for PCI-DSS)
-       Need DB encryption?

Transmission
-      Encryption of files (what are the standards?)
-      VPN / secure file transfers (is SSL/TLSV1.2 enough) ?

Non-disclosure agreement
-       Is there a need to sign NDA (for intra-company or this applies only to inter-company)

Is this treated as 'Outsourcing' if it's intra-company ?
0
Hi experts I have read so many confusing things about this issue so I decided to post it here.    The file size of my user mailbox database is 153 Gig.     That seemed very high to me so I ran a report.    the total size of all my users mailboxes is 72 Gig.    So where is all that space and how do I recover this?

thanks in advance
0
This is related to earlier question on "How-to-get-output-displaying-as-rows-to-columns".

The query below is using pivot function to display out columns and performing a SUM on interval data.

The pivot function works alright, but the SUMing appears to not work as the values are not adding up correctly.

Query:
WITH opdays as
       ( --
         select opday as opdaystart,                           -- opday is derived from the inner Select query
                (opday + 1) - (1 / 86400) as opdaystop,       -- opdaystop is derived by adding a day and subtract a second from that day
                trunc(to_date('1/1/2010 00:00:00', 'mm/dd/yyyy hh24:mi:ss')) as FirstDayStarttime,    -- gv_firstdaystarttime = TRUNC(p_firstday) where firstday will be parameter passed in from appworx
                trunc(to_date('1/1/2010 00:00:00', 'mm/dd/yyyy hh24:mi:ss')) + 1 - (1 / 86400) as FirstDayStoptime,      -- gv_firstDaystoptime = TRUNC(p_firstday) + 1 - (1 / 86400), add a day and subtract a second from firstday
                trunc(to_date('1/3/2010 00:00:00', 'mm/dd/yyyy hh24:mi:ss')) as LastDayStarttime,      -- gv_lastdaystarttime = TRUNC(p_lastday) where lastday will be parameter passed in from appworx
                trunc(to_date('1/3/2010 00:00:00', 'mm/dd/yyyy hh24:mi:ss')) + 1 - (1 / 86400) as LastDayStoptime         -- gv_lastdaystoptime = TRUNC(p_lastday) + 1 - (1 / 86400), add a day and subtract a second from lastday
         from (--  
                 

Open in new window

0
hello experts ,

currently i am trying to migrate my database(SQL server 2008R2 standard edition ) from test environment to dev(SQL server 2014 standard edition) .my BD size is 535 GB and my disk size is 2.49 TB ,every time i am trying to restore my DB getting error :

Msg 3257, Level 16, State 1, Line 2 There is insufficient free space on disk volume 'K:\' to create the database. The database requires 3106808856576 additional free bytes, while only 2670337888256 bytes are available. Msg 3119, Level 16, State 4, Line 2 Problems were identified while planning for the RESTORE statement. Previous messages provide details. Msg 3013, Level 16, State 1, Line 2 RESTORE DATABASE is terminating abnormally.

why i am getting this error since i have enough space on my drive .i am not trying to restore in C drive . how could i solve this ? thanks
0
I want it so that when the user types into the textarea/input and clicks save changes, the information they input has been added and saved into the database. Below is my code:
$name = $_SESSION['u_name'];
$uid = $_SESSION['u_uid'];
$id = $_SESSION['u_id'];

$con = mysqli_connect("localhost", "root", "pass123", "db_name");

if ($con->connect_error) {
    die("Connection failed: " . $conn->connect_error);
	echo "<script type='text/javascript'>alert('connection failed. try again');</script>";
}

$remind1 = $_POST['remind1'];
$remind2 = $_POST['remind2'];
$remind3 = $_POST['remind3'];
$remind4 = $_POST['remind4'];
$remind5 = $_POST['remind5'];

if (isset($_POST['updBtn'])){
	$sql = "UPDATE reminders SET remindone='$remind1' WHERE username='$uid'";
	
	if ($con->query($sql) === TRUE) {
		echo "<script type='text/javascript'>alert('Updated successfully');</script>";
	}else{
		echo "<script type='text/javascript'>alert('error while updating. try again');</script>";
	}
}

Open in new window


HTML:
<form action="body.php" method="post"> 
 <input type="submit" class="sideBtn" value="Save Changes" name="updBtn"></input><br>
<div class="displayTask">
           <input type="checkbox" class="check">
           <span class="checkmark"></span>
           <input type="text" id="event" placeholder="remember..." name="remind1"></input>
</div>
<div class="displayTask">
           <input type="checkbox" class="check">
           <span class="checkmark"></span>
           <input id="event" name="remind2"></input>
</div>
<div class="displayTask">
           <input type="checkbox" class="check">
           <span class="checkmark"></span>
           <input id="event" name="remind3"></input>
</div>
           <div class="displayTask">
           <input type="checkbox" class="check">
           <span class="checkmark"></span>
           <textarea id="event" name="remind4"></textarea >
</div>
<div class="displayTask">
           <input type="checkbox" class="check">
           <span class="checkmark"></span>
            <textarea id="event" name="remind5"></textarea >
           </div>
 </div>
</form>

Open in new window


After many trials and errors, I have been able to pinpoint that my problem is somewhere along the $_POST variables in my php as, if I were to substitute the aforementioned variable with a string, it works perfectly. I am not exactly sure what I did wrong, but I feel so close that I know I must be (hopefully) getting somewhere. How can I fix this mistake of mine and make it so that the user is able to POST text into the database.
0
Upgrade your Question Security!
LVL 11
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Hi EE.

I have a database which has some tables and on one of the table call vvx and I have two fields named CoreUser and another one is named refer now what I do is that when a user logs in the system checks on the refer to see if this person has introduced any user to the system and if s/he does that firstly count how many users s/he had introduced then after that I want to check for each user s/he had introduced how many people each introduced, and also for those as well check how many they had introduced.

The table is like this

---------------------------------------|-------------------------------------------------
CoreUser                                | refer
----------------------------------------|--------------------------------------------------
ja                                              |  zzz
--------------------------------------------------------------------------------------------
fgg                                            | ja
---------------------------------------------------------------------------------------------
jhb                                            |zzz
----------------------------------------------------------------------------------------------
trr                                             | fgg
-----------------------------------------------------------------------------------------------

Now you can see that 'zzz' introduced 2 users named 'ja' and 'jhb' and that one of the users …
0
I want to try to optimize some code by placing combining a call to a stored procedure with a SQL select statement.
The stored procedure is called taSopLineIvcInsert.  I have a temporary dataset stored in SOPLINES and SOPHEADR. I am passing down the order number to another stored procedure and I want to select all the lines that belong to this order. As each line is found I then want to call the stored procedure taSopLineIvcInsert that will insert each record into the final production database. I want to do this without using a cursor. How can I restructure the attached stored procedure to accomplish this?
SQL_Loop.sql
0
Hello experts,
we have a small database in mysql,
its usually performs really fast
but  sometimes when requesting a very simple query
 it will take too long to respond... like 30 secs o more... and its a very simple query.
and the table is too small....
I have noticed that maybe there are other connections still open and i think not operating.
Could this be the cause and if so what tools do i have to control this ?
Regards
0
I am using exchange 2013. There are two mailbox servers which are in DAG. Database is mounted and healthy. All seems good. To configure a DR Site, I created an exchange 2013 on azure cloud and synced one database. When I started second database sync, it got failed saying below error. When I check database status, It shows me "Bad copy count" status is 1. While database is mounted and healthy.

error

The seeding operation failed. Error: An error occurred while performing the seed operation. Error: An error occurred while communicating with server 'TTAEXCH2013C1'. Error: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. [Database: MailboxDB_Users3, Server: Exchange2013-DR.TTA.MUMBAI.COM]
DB-Error.jpg
0
Never mind it works
0
Looking for a variety of clip art or illustration to use with Power Point presentations.  Primarily interested in database connectivity, network, disk/storage arrays art work for database presentations to management.  Exhausted attempting to make my own art work for meetings, and willing to pay some for access to good quality images/clip art, and illustrations. What is my best bet to acquire?
0

Databases

55K

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.