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

Hey,

I am building an application that will run on multiple instances of the same Mysql schema.  Same database schema, different data in each.  The goal is to keep each clients data in separate instances of the same database.  I have designed my model in MySQL Workbench and have been using the "Synchronize Model" function and that works OK, but i have to specifically push the changes to each instance of the DB.   As this grows that will become unmanageable.  

Is anyone aware of any database management tools that will allow me to push schema changes to multiple instances simultaneously?   Again, this is not replication as the data in each DB is different, i am looking for a way to push Schema changes only.

Thanks in advance.
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.

Hi Experts,

I want to restore postgres database.

I had taken backup with pg_dump.  the command which I used to take backup is

pg_dump -U postgres -h 127.0.0.1 -p 5432 ts > ts.tar
password:

it created the file ts.tar

Steps I had tried to restore is

root@ip-10-252-14-11:/home/ubuntu/workarea/sourcecode/database_backup# pg_restore --host localhost --port 5432 --username "postgres" --dbname "ts" --role "ts" --no-password --verbose "./ts.tar"
pg_restore: [archiver] input file appears to be a text format dump. Please use psql.

root@ip-10-252-14-11:/home/ubuntu/workarea/sourcecode/database_backup# pg_restore --host localhost --port 5432 --username "postgres" --dbname "ts" --role "ts" --no-password < "./ts.tar"
pg_restore: [archiver] input file appears to be a text format dump. Please use psql.

root@ip-10-252-14-11:/home/ubuntu/workarea/sourcecode/database_backup# pg_restore --host 127.0.0.1 --port 5432 --username "postgres" --dbname "ts" --role "ts" --no-password < "./ts.tar"
pg_restore: [archiver] input file appears to be a text format dump. Please use psql.

root@ip-10-252-14-11:/home/ubuntu/workarea/sourcecode/database_backup# pg_restore --host 127.0.0.1 --port 5432 --username "postgres" --dbname "ts" --role "ts"  < "./ts.tar"
pg_restore: [archiver] input file appears to be a text format dump. Please use psql.

root@ip-10-252-14-11:/home/ubuntu/workarea/sourcecode/database_backup# pg_restore --host 127.0.0.1 --port 5432 --username "ts" --dbname "ts" 

Open in new window

0
Hi,
We have a very small business working in the same office with MS access. right now all the computers are connected to the database through the local network, we all can work simultaneity. I want to be able to connect 2 or 3 computers (remote) to the database so that they could also work simultaneity. My knowledge is very poor we don't have any IT persons. What is the easiest and best solution so that the remote PC's will be able to connect to the database ? the size of the data base is around 50mb. (the file type is .accdb)

Thank you!
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
<?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 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
How do I email a report to multiple email address's from my database?
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
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
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!

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
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 three users (including myself) who have been working in a database for months with no problems.  Recently one of the users was upgraded to Windows 10/Office 365 2016 and the following message occurs.

“The Microsoft Access database engine cannot open or write to the file R:\Data\...\database_be.accdb.  It is already opened exclusively by another user, or you need permission to view and write its data.

Only one person was trying to open the database and we have had the same rights since the beginning.  I did notice that there isn’t an .laccdb file being created for the back-end database_be.accdb but the front-end database_fe.accdb has one.

The references for the object library were checked and fixed.  The 2016 user still gets the error but the 2010 users don’t.  The 2010 users do get VB code errors for Excel but at this point I don’t know if they are due to the first problem.

Any help would be appreciated.
0
I have this Xerox AltaLink C8030 that work with network address book for scanning to email. LDAP was configured to point to our Domain Controller. Then one day it stopped working. The message it first had was "LDAP Database mapping error" once I pointed the LDAP to our other domain controller the error message changed to "Cannot determin if LDAP is avaliable" There is another same model Xerox at a different location so I ensured that the two LDAP configurations are identical with the only difference is the domain controller address is different.
0
There is a question on https://www.experts-exchange.com/questions/28687829/ADO-NET-Entity-Framework-LINQ-on-Visual-2013.html about whether to use Entity Framework or ADO.net for large databases.  The accepted answer is:

Again depends on the use case and what you intend to do with retrieved data. If you intend to display it in a control such as grid then it makes sense to use SQL to pull that data. Entity framework, as the name suggests, is more useful when you are dealing with entities in your code.

What is meant by an entity?
I'm used to connecting to a database with ADO.net and doing CRUD operations using stored procedures.  When is this approach better than Entity Framework and when is Entity Framework better?
I'm using C# for Visual Studio 2017
0
Hello experts,
Ldf file size of one of the DB reached  more than 60gb and I would like to reduce file size in order to avoid disk espace saturation. I checked the recovery model option and it is set up with full option.
I was wondering if I can go ahead by changing this option by simple and then reorganize log file to reduce as much as possible this file. I want to avoid database corruption or and unwanted consequence. What is the best practice to reduce ldf file?
Thank you very much for your help.
0
Most all of my Access databases use ODBC connections to Oracle tables. Usually, I set these with a .reg file when a user needs the DB. Is there a way to set the ODBC connection with a VBA script when the database opens. Seems it would be easier than having users run the .reg file, which requires admin rights.
0
I have a Exchange 2016 DAG across 2 sites, soon to be 3. The 3rd site will be in the US and have a Exchange DB created on it to serve local users. There will be a copy of that database on  2 of my current exchange servers here for redundancy.

My question is, if I activate the US DB copy on one of the Exchange servers here, shut down that host and have it offline for 2 days while in transit will I have an issue when it is up again in the US? Will the database simply copy the changes it missed and eventually become available to be activated? Is there anything special I need to do like suspend the now copy?

Thanks!
0
Need to display a few dozen photos / cross-platform

What quick to code cross-platform solution is there to enable people in my tour to follow along with their smart phones? I have about 25 images which I want to provide them and make it easy to jump to Image #14, for example.

I want to start simple and give them just a Next and Previous button and a Jump To option.

I understand I could write this as a responsive web page, but would need a back-end service and a database of images. But I want a canned solution I can configure and get up and run with.

I hope for a generic platform which is well enough known that I could hire an outside developer to code for me in about 15-20 hours of work.

What can you suggest?

Thanks
0
Cloud Class® Course: MCSA MCSE Windows Server 2012
LVL 12
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Can anyone send me a good link to explain how I can integrate dates from MS Project into my MS Access database?
0
I am building a database in ACCESS and have created a field called "Computer ID".  I want this field to be unique.  How do I set it up so that duplicate entries cannot be added?
0
Hello All!

I have a new issue that I need to solve with automatically closing my database when idle. I was very excited to have originally gotten it to function. I created a idle timing form that triggers another form to open after 4.5 minutes. the new 'CountDown' form gives the user 30 seconds to respond before closing the database out (Total 5 Minutes). All was great up to this point. When a co-worker came in, I showed him the new feature and discovered that when I had an active query open the 'DetectIdle' form became unresponsive. So basically it only detects forms and not queries. I need to find a way to include queries in the 'DetectIdle' form coding that I have. Is this possible? Users often leave the database open on the queries when searching information and walk away preventing issues with other users when accessing the database. I appreciate any assistance you all can provide me with.
Thank you!

Private Sub Form_Timer()
Static OldControlName As String
Static OldFormName As String
Static ExpiredTime


Dim ActivecontrolName As String
Dim ActiveFormName As String
Dim ExpiredMinutes

On Error Resume Next

ActivecontrolName = Screen.ActiveControl.Name
ActiveFormName = Screen.ActiveForm.Name
Me.txtActiveForm = ActiveFormName



If (OldControlName = "") Or (OldFormName = "") _
    Or (ActiveFormName <> OldFormName) _
    Or (ActivecontrolName <> OldControlName) Then
    OldControlName = ActivecontrolName
    OldFormName = ActiveFormName
    ExpiredTime = 0

Open in new window

0
Dear EE,

We have licensed EAServer 6.3.1 software available.

Now we want to relocate our EAServer machine from one location to another. (Geographic relocation).

Please help us to confirm whether same EAServer license will work or we have to request SAP for another license.

As per our understanding EAServer license is bind with Server MAC Address.

Do we need to maintain same server name and ip address etc ?

Thanks
0
Hi Experts,
I have my Access backend database on the server and some times nobody is using it, I can go into design of each of the tables.
However the lock file does not get closed after closing all Access instances.
Is it safe to copy over the file to a different location, compact it and place it back in the original location?
0
In microsoft access is it possible to create a login screen that uses the users CAC credentials to login? Currently users access their computer network account using their CAC card cert. Rather than creating another login screen on the client-side ms access database that I am creating wondering if I could piggy-back on the user's CAC card cert to have user login. Not sure if this is possible but thought I would post here to check. Thanks!
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.