Databases

56K

Solutions

40K

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

Hi Team,

I need to understand the below topics in Oracle 12c.

1.   What are the different data files present in the CDB database.
2.    What is the significance of seed database , how to login into it and install a pdb database?
0
The Ultimate Tool Kit for Technolgy Solution Provi
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Hello experts,

I am looking for a free or paid software in order to build database/table/api schema among my various production, testing environments.
I tried yEd but it is not very practical for me.
Could you please advice on this.
Thank you very much in advance for your feedback.

Regards,
0
I am trying to build a Visual Studio VB WindowsForm project that uses DAO to access a 2016 .accdb database file.

I have added the reference Microsoft.Office.Interop.Access.Dao from the Access.16 Office dll.

My code:

Option Explicit On
Imports DAO = Microsoft.Office.Interop.Access.Dao
Module Module1LoopThroughStandard
    Public Sub LoopThrough()
        Dim de As New DAO.DBEngine
        Dim db As DAO.Database
        Dim rs As DAO.Recordset
        Dim strSQL As String

        db = de.OpenDatabase("c:\Project\database.accdb")

        strSQL = "SELECT * " & _
                   "FROM Table1"

        rs = db.OpenRecordset(strSQL)
        With rs
            If .BOF Then
                MsgBox("Oops, not working")
            Else
                .MoveFirst()
                MsgBox(.Fields("Name"))
            End If
            .Close()
        End With

        rs = Nothing
        db.Close()
        db = Nothing
        de = Nothing

    End Sub
End Module

Open in new window


I get the following COM Exception:

System.Runtime.InteropServices.COMException was unhandled
  ErrorCode=-2147221164
  HResult=-2147221164
  Message=Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
  Source=mscorlib
  StackTrace:
       at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, …
0
Hello Experts,

I have created 1 Instances with 9 Databases using SQL Server 2008 R2 Express.

Problem:

I keep losing connection to one or more databases. (My front end APP fails because it loses connection to said databases and SSMS loses connection as well).

As a note - I have put up to four instances (One database per instance and never had a problem like this...

I understand there is a memory limitation of 1 Gb in SQL server Express.

Does anyone know what is happening here and how I can get around it?


Thanks!
0
<?php


if(!empty($_FILES)){
    
    //database configuration
    $company = $_GET['company'];
    $dbHost = 'localhost';
    $dbUsername = 'root';
    $dbPassword = 'billadmin2006';
    $dbName = 'inventas';
    //connect with the database
    $conn = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
    if($mysqli->connect_errno){
        echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
    }
    
    $targetDir = "uploads/";
    $fileName = $_FILES['file']['name'];
    $fileSize = $_FILES['file']['size'];
    $targetFile = $targetDir.$fileName;
    
    if(move_uploaded_file($_FILES['file']['tmp_name'],$targetFile)){
        //insert file information into db table
        $conn->query("INSERT INTO documents (companyName, f_name, d_date, f_size) VALUES('".$company."','".$fileName."','".date("Y-m-d H:i:s")."','".$fileSize."')");
    }
    
}
?>

Open in new window


The $company = $_GET['company']; is just not getting added to my database. The url is fine - the GET value is correct. If I set the $company = 'test'; it works. I am only using GET to test - I would usually use POST
Could I use a session variable - if so how do I set a session variable that can be used in multiple pages as a variable for database input
0
I'm trying to recreate a Rates page for a client in WordPress.

The rates page can be viewed here https://old.consolidatedutilities.com/rates/

The admin to the rates page can be viewed here https://old.consolidatedutilities.com/admin/

Use the username /password expertsexchange : expertsexchange

Once you login click on Manage Rates Page.


I want to tie this into the WordPress backend but I've only been working with WordPress for a little while.

Is the consensus that I should use my database and this old site to update the rates page? Or can I tie it into the WP admin and use that?
0
Exchange EDB to PST Converter
Use SysTools Exchange EDB to PST Converter to safely converts Dismounted, Offline or Orphan EDB file of Exchange 2019, 2016, 2013, 2010, 2007 Environment easily in PST file format. Now Converts Exchange mailboxes items such as emails, contacts, calendar details into .pst format without PowerShell.
0
I'm having issue with this SQL statement.
$sql_statement = "SELECT once.id, message, audio, audio_desc, accepted, postdate, tag, broadcast, once.mobile, once.username1, state, users.username, users.firstname, users.lastname, users.fullname, users.avatar, users.alias, useroptions.aliascheck, content_provider.content_type, comment.comment_date as c1 FROM once LEFT OUTER JOIN users ON once.username1 = users.username INNER JOIN useroptions ON once.username1 = useroptions.username LEFT OUTER JOIN content_provider ON once.username1 = content_provider.provider LEFT JOIN comment ON once.id = comment.post_id AND once.tag = comment.post_tag WHERE once.username1='logusername' OR once.username1='myusername' GROUP BY once.id
UNION ALL
SELECT daily.id, message, audio, audio_desc, accepted, postdate, tag, broadcast, daily.mobile, daily.username1, state, users.username, users.firstname, users.lastname, users.fullname, users.avatar, users.alias, useroptions.aliascheck, content_provider.content_type, comment.comment_date as c1 FROM daily LEFT OUTER JOIN users ON daily.username1 = users.username INNER JOIN useroptions ON daily.username1 = useroptions.username LEFT OUTER JOIN content_provider ON daily.username1 = content_provider.provider LEFT JOIN comment ON daily.id = comment.post_id AND daily.tag = comment.post_tag WHERE daily.username1='logusername' OR daily.username1='myusername' GROUP BY daily.id
UNION ALL
SELECT weekly.id, message, audio, audio_desc, accepted, postdate, tag, 

Open in new window

0
Dear Experts,

I am currently experiencing data loss issues on magento table (name  catalog_product_entity_group_price) .
After the insert and check with the count command, the record is still sufficient. But after a while, especially when running price index script, I check the that table again, some record rows are disappeared.

Please help me, why Mysql DB Table Rows Disappearing, other reason can cause row loss in mysql ?

Thanks!
0
How do I email a report to multiple email address's from my database?
0
Introducing the "443 Security Simplified" Podcast
LVL 1
Introducing the "443 Security Simplified" Podcast

This new podcast puts you inside the minds of leading white-hat hackers and security researchers. Hosts Marc Laliberte and Corey Nachreiner turn complex security concepts into easily understood and actionable insights on the latest cyber security headlines and trends.

We need to rename XenApp SQL database server's hostname (Just the server hostname and not the SQL Database names).

Xenapp : Windows server 2008 R2/ XenApp 6.5 with Rollup pack 7
DB server: windows Server 2008 R2/ SQL server 2008 R2

Please  provide steps if anyone have done this activity. Also, what is the level of risk exists with this task ?

Thanks.
0
This is a T-SQL problem I have been chasing for 3 months and haven't found a fix for... I think I am close, but other problems keep undermining my progress... darn it...

I have a stored procedure that is used to match incoming customers with existing customers on the database. I know, it is a pig from the word go, but for the first 2 years, it has run like a Swiss watch.

Back in May, this step has gone sideways and is taking upwards of 4 hours to complete... here is the rub, 90% of the time, it happens on a Monday morning... processing data from Sunday, the lowest volume day of the week.

The rest of the time, the match takes about 30 minutes. Today, for example, it took 5.6 hours to process 3400 records... that's 6 seconds per record!!! I have a problem with that. Something is hitting this hard... and yes, I know today is not Monday, but the last time it freaked out on a non-Monday, was also a Thursday. I am sensing a pattern... and I don't like it!

How it works:

1. A VB App calls the proc, passing name, address, email and phone data

2. The proc then compares combinations, looking for matches. The matches are in order of importance, name/address, name/email, etc

3. A match is only performed if the record has not yet been matched, meaning, if it matches by name/address, the name/phone is ignored

4. If a new record exists, it is then inserted into the database... that includes the name, address, phone and email tables.

5. The next record is then …
0
I had this question after viewing After SQL 2016 Upgrade SA Account Keeps Getting Locked by Backup Jobs.

I am getting the exact same error... except there is no message in the logs about a failed login attempt  by the SA account. And what is even more interesting, the SA password was never changed...

I am administering an isolated SQL Server database, managing a specific task for my company. This database takes data from other sources and consolidates it for marketing.

Two years ago, we updated the server and migrated the database, using SQL 2012 Standard. The server is a Dell

Last month, with the assistance my our corporate DBA, we upgraded from 2012 to 2016 Standard SP1.

Since then, I have been getting these messages about the SA account being locked out... well, why would that do that when the SA account password has never been changed? I can log into SSMS using that password... I can run jobs using that password, as soon as the SQL Server agent tries to run it, the errors fly.

This morning, I have updated the maintenance jobs to use a direct connection to the server vs the "local connection" default. I will test that shortly.

This is one of two problems... the other is different and will be under a different title.

Thank you all in advance!

Andy
0
I know there's a ton of questions around date/time storage and formatting, but I'm struggling to get the right approach. My app is a Node.js app with Express using mongoose with a MongoDB backend. I'm using moment.js to format my date/times.

The schema in question looks like:

const stateSchema = new mongoose.Schema({
  changed: {
    type: Date,
    default: new Date()
  }
});

Open in new window

Based on the docs, I was expecting the date to be stored in UTC by default, but instead I see this:
changed: 2018-08-15 17:26:14.499

Open in new window

I'm displaying the date/time with something like (pug):

p= `Changed: ${moment(state.changed).format('MMMM Do YYYY, h:mm:ss a')}`

Open in new window

On localhost, the app shows "August 15th 2018, 5:26:14 pm" but on the hosted Heroku app I get "August 15th 2018, 10:26:14 pm." I am expecting "August 15th 2018, 5:26:14 pm" because I'm opening the Heroku app in the same timezone, but it looks like it's giving me the server timezone.

What should I do to make sure the date/time shows up in the client's local timezone?
0
I need to transfer a 500GB Table(single) from one oracle database to another database using a 500Gb network. What can be the most efficient way?
0
Hi,

I have created a basic Website in WordPress using a number of plugins to include company information, images etc.

Does anyone know of a WordPress plugin that will connect to and query an MS SQL database? We have a SQL 2008 server on site and I would love to be able to retrieve and present information from the various tables/views onto an Intranet page / potentially including a search too.

I've seen a few plugins which allow you to access the mySql database behind Wordpress but nothing that allows you to connect to a separate database.

I look forward to your replies & thanks in advance!
0
Hello,

I'm having some issue with my database.
I'm trying to use a listbox to allow multi selections to filter a subform. I also would also like to add a filter date FROM and TO.
I've read multiple topics on it, but I can't seem to figure out how to do it.

Thank you.
Database11.accdb
0
How do i enter array value into database.


My Sql

$stmt = new Database();
					//Inserting check state.
					$query = "INSERT INTO a_test (charityID, contactID, chk_name) VALUES (:clientId, :contactId, :chkName) ";
					$stmt->query( $query );
					$stmt->bind( ':clientId', $clientId );
					$stmt->bind( ':contactId', $contactId );
					$stmt->bind( ':chkName', $_POST['chkStateCollection'] );
					$stmt->execute();
					

					$result = "Record added";

Open in new window


Result -

SQL result
The Array -

The Array, Normal Array
the field chk_name needs to equal that of the array
0
Exchange 2013, 3 Server DAG with 4 Databases. We are having an issue with being unable to move DB copies to certain servers. I have troubleshot the issue for months and cant seem to come up with a solution. I get the error below when attempting to move databases. The odd part is the issue goes away after a few days. I can get it to go away occasionally by moving the databases to Exchange3 then rebooting 2 and moving them to 1, but if I try to move them back to 2 at that point I get the RPC error. It hits all 3 servers occasionally and I have to either reboot all of them or just wait a few days and it goes away. I cant find anything in the event viewer related and I have verified the RPC services are functioning normally.  

error
EXCHANGE1
An Active Manager operation failed. Error: The database action failed. Error: An error occurred while trying to validate the specified database copy for possible activation. Error: EXCHANGE1:
A server-side administrative operation has failed. The Microsoft Exchange Replication service may not be running on server (MYDOMAIN). Specific RPC error message: Error 0x6ba (The RPC server is unavailable) from cli_RpcsGetCopyStatusWithHealthState
[Database: DBNAME, Server: EXCHANGE2]
0
Powerful Yet Easy-to-Use Network Monitoring
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Hello,

I have a serious situation with Access 2016. We have a database here at work that will not allow a form to be opened. The first message received upon the main form opening is that the database is in read-only mode, which it should not be. So when trying to open the main data entry form, the message displays that the OpenForm action was canceled. This is our Inventory database and is vital to our daily operations, so I could really use some help here. This happened spontaneously and no modifications have been made to any part of the database. Also, for some reason, this has affected ALL backup copies of the database, some going back to last year. Can someone please offer some advice as to how this can be fixed, and possibly an explanation as to how this could have happened in the first place??? Thank you.
0
After I installed several updates on my SBS 2008 R2 server the companyweb started to stop working once a day for like 20 minutes not everyday but most of the days and then it just started to work again, this what I have tried:

-checked and cancel tasks that I saw ran by that time: antivirus scan, backup

-Recreated the sbs Monitoring database as it was getting full and I thought this may some how create this issue: https://blogs.technet.microsoft.com/sbs/2011/08/22/how-to-recreate-the-sbsmonitoring-database/

-Recreated the access to the companyweb deleting from the IIS and adding it again: https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-essentials-sbs/dd548330(v=ws.10)

-I checked the event viewer and I cannot see any error directly related with this: apart from:

*MSSQL$SBSMONITORING 17137

*MSSQL$MICROSOFT##SSEE 17137

*MSSQL$MICROSOFT##SSEE 2803 I can see few of this error

and a WAS 5186 error

also on top of this when I go to the Web Sites on the Windows SBS console the internal website shows status as "Unknown", description  as "The Web site dues not exist" and it doesn't give any option to run or stop it; and funny enough now when I go to the IIS Manager console and check if the website is running now it only works when it shows as stopped in here.

Any ideas of what could be causing the issue or what else I could try?
0
Was working on my access databse when I lost power on my laptop. The Database was sitting on a network server. Now when I try to open the database again after logging back into the network I get "Your network access was interrupted. To continue, close the database and continue". But when I look at the database size it says 'zero' now. OMG! See attachment. screenshotDoes this mean it's GONE! I hope there is a way to retrieve it.
0
Hello

I'm having some trouble following this Microsoft document:

https://docs.microsoft.com/en-us/system-center/scom/upgrade-sqlserver-2017-opsmgr-1807?view=sc-om-1807

I have successfully upgraded my SCOM instance to 1807. I have also successfully upgraded the SQL database instance from 2016 to 2017, as that is now supported. However, I am unable to upgrade reporting services successfully. According to the release notes of SCOM 1807, upgrading from SQL 2016 to SQL 2017 is supported, but not for fresh installations. I find it curious then, that this upgrade guide instructs a removal of Operations Manager Reporting Services, and after upgrading SSRS, to install Operations Manager Reporting Services again. So, either I’m not reading this document correctly, or nobody has tried to follow it yet, including its creators.

How does one reinstall Operations Manager Reporting Services when using SQL 2017 Reporting Services? There is no 1807 fresh installation media as far as I am aware, so naturally, the 1801 installation media gives me this error when trying to reinstall:

The installed version of SQL Server could not be verified or is not supported. Verify that the computer and the installed version of SQL Server meet the minimum requirements for installation, and that the firewall settings are correct. See the Supported Configurations document for further information.

Would anyone have a workaround for this at all, or should I just go back to SQL 2016 SSRS?
0
Here is the ajax call

function showCustomProps(){
    
    $('#subaction').val("getCustomProperties");
    var data = $('#subaction') ;
  
  
    $.ajax({
        type: "POST",
        url: 'controllers/contacts.ajax.php',
        data: data,
    }).success(function (response) {
      
        
        
        console.log(response);
        
    }).error(function (data) {
        console.log("erro customProps");
    });
    
} //showCustomProps

Open in new window


this is triggered on load.

to run this code -

$stmt = new Database();

				$query = "SELECT cp.id, cp.name, cp.field_type 
							FROM custom_properties cp
							WHERE cp.client_id = :clientID AND cp.viewable='1' AND cp.type = '1'
							ORDER BY cp.id DESC";
				$stmt->query( $query );
				$stmt->bind( ':clientID', $clientId);
		     	$stmt->execute();
				$demo1 = $stmt->fetchAll();

				foreach($demo1 as $customResult){
					$cusData['propertyId'] = $customResult['id'];
					$cusData['propertyName'] = $customResult['name'];
					$cusData['propertyType'] = $customResult['field_type'];
				

			

				}//customresult

						$response = array(
							'subresult' => 'customProps success',
							'data' => $cusData
						
							
						);

		break;

Open in new window



Now the issue is that it is returning null.  but if i change fetchAll to all it returns a row from the database, i need this foreach to fetch all records not just the first one. if i return demo1 instead of customResult i can see there is two records, Please note i can only see this data if i use all() and when i use fetchAll it returns null.
0
I have a table named dbo.logSearch in an MS SQL database.  The table keeps track of all searches performed on my data.  The problem is that the spiders find the database and make numerous searches which results in the table getting extremely large.

I've written a query (with help from somone who knows what he as doing!) that groups all of the table rows grouping those with the same IP (remote_host).  This query lists each IP along with how many searches were made:

SELECT remote_host, count(*) AS count
FROM dbo.logsearch
GROUP BY remote_host
order by count desc

I would like to modify this query to delete all records made any IP in which more than 1000 searches were made, thereby deleting the search made by spiders.
Can you help?
0

Databases

56K

Solutions

40K

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.