Databases

54K

Solutions

38K

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 had a disk error that was fixed, however, it caused my Exchange 2016 EDB file to now show 0 Bytes. The database cannot be mounted. I have tried all eseutil commands, but they all give jet error -1206, and state the file is corrupt. There is no backup, as the disk error was not allowing a proper backup to be generated. Is there any way to recover? If not, how do you create a new "first container" database for administration and system files?
0
Microsoft Certification Exam 74-409
LVL 1
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Hi Experts,

I would like to transfer over a DB to someone.
1-What is the command to execute to make a bak of that file to a given destination?
2- Will that person be able to restore that db without having my login/pwd?
3- In order to create that backup I had to run the following (as all views were converted by the import utility as tables with the view's names..)
select 'sp_rename ''['+name+']'', '''+replace(name,'view_','')+''';'+ char(10)+CHAR(13)+ 'go' + char(13) from sys.tables where type='U';

Open in new window

However the I had to go to every single line and click enter before the GO, how can I avoid that?

Thanks in advance
0
Hello Experts

I have a collection of SubReports inside a MasterReport. I'm having a small problem where SubReport number 9 (for instance) doesn't show up if there are no records. Instead there is just a blank section in the MasterReport, and then it shows the next SubReport. Its worth noting that SubReport number 9 does show up in Report View and Layout View, but does NOT show up in Print Preview or during an actual Print.

Ideally, we'd like it to display the headers for this SubReport and no records underneath them - instead of just all white space because this MasterReport is structured with numbers in the Titles, etc. (Check Number 1 - Expenses; Check Number 2 - Overdrafts, where 1 is SubReport 1 and 2 is SubReport 2). The numbers are important, and the order is also important.

For what its worth, I am using Office 365 Access.

Thanks for your ideas and thoughts!
-IT_Crowd
0
I have a database query that I want to export or convert to a json file.

The query result is something like this

path                         | name          
parameter.name.menu.myname | mike miller

Open in new window


Finaly I need a json structure like

"parameter": {
        "name": {
              "menu": {
                    "myname": " mike miller"
              }
         }
 }

Open in new window


How this is possible?
I work with mysql 10.1.x and php
0
I have a program that uses sql server database.  When I try to log in the first time it gives me a Login timeout expired window.   I click ok and then try to login again and it works.  Any ideas how to fix this??
0
Hi,

We're in the process of refactoring a large PowerBuilder application with the goal of keeping our business logic in PB and exposing it as an API for .NET developers by using the .NET assembly target in PowerBuilder 12.6 Classic.

The environments we need to support include multi-threaded environments like IIS and xUnit.  In using xUnit (which defaults to running tests in parallel), we've encountered an issue where database connections made on separate threads are interfering with each other.  We've also reproduced this issue from a multi-threaded .NET console application.

We've created a very simple .NET assembly that just exposes a connection nvo that wraps a native PB transaction stored as an instance variable in the class.  We are not using SQLCA or any global variables.  The connection object just has connect and disconnect methods.  We import this assembly into a .NET xUnit project, create three separate test classes where each runs a test that instantiates a local connection instance and loops ten times, just connecting and disconnecting with each iteration.

If we force xUnit to run tests serially (see how below), we can repeatedly run all tests without issue.  If we let xUnit parallelize the execution of the three test classes, we get random errors.  Sometimes after connecting we'll get a "transaction not connected" exception when immediately trying to disconnect or when attempting to connect we'll get a "transaction already connected" exception.  …
0
I need to remove a bank account from the database, but every time I try, I get the message "cannot delete...transactions have been made", which is true, but not since 1999 or so.  I need it off my bank account listing and out of the way....is there a way to do this?  I have tried every way I know.
0
Hi experts,
Could you please help. How to identify table row inserted or updated date & time using oracle way. E.g system column etc. and without using archive log or flash back files

Since this is a custom table and we don't maintain created or last updated column defined. So could you pls help

Oracle Database 11g
0
my current database is MS-Access.

I used primary key in my table.

Also, First i am deleting record and then followed by inserting.

But, while inserting i am getting Error : Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.

I am unable to find out the exact problem for this.

See my complete code.

string connectionstring1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbname + ";";
OleDbCommand command = new OleDbCommand();
OleDbTransaction transaction = null;
OleDbConnection cn1 = new OleDbConnection(connectionstring1);
cn1.Open();

// Start a local transaction
transaction = cn1.BeginTransaction();

// Assign transaction object for a pending local transaction.
command.Connection = cn1;
command.Transaction = transaction;

// Execute the commands.
string sqlTrunc = "DELETE FROM [" + tableName + "]";
OleDbCommand cmd = new OleDbCommand(sqlTrunc, cn);

cmd.ExecuteNonQuery();

transaction.Commit();
string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbname + ";";
//using (OleDbConnection cn = new OleDbConnection(connectionstring))
using (OleDbConnection connection = new OleDbConnection(ConStr))
{
connection.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand("SELECT * FROM [" + TABLENAME + "]", connection);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);

adapter.Fill(newdt);

adapter.Update(newdt);

}

What is the …
0
IN THE BLOCK PROPERTIES, DML Returning Value - I changed from NO to YES. I disabled the audit triggers in the database. Bit still when I delete a record,I get this error. What can be the reason?  I thought the database trigger is inserting a value. That is the reason I disabled the trigger. Help appreciated.
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!

Hi, I am a generalist software developer whining at a telecommuters site and I have assigned a project involving MS Azure.
I've done others project involving it, but this is the first time I need to consolidate data from many databases and other flat file resources to a dwh in Azure. I want to start with what seems easy, which is to update from a MySql/Posgre database to Azure (SQL Azure, I guess)? After importing data initially from Mysql to Azure I need to have it updated daily.

Looking forwards to any path to follow so I can jump to documentation and take a good dive for implementing my project.

Thank you dear experts! Much respect!

Sergej
0
I Created a WebGrid using MVC but when i try to run I am getting this Error Message "SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.", I Checked SQL Server Logs but it is not even Connecting the Database, It is timing out after 1 minute, I Included these Timeouts but it is not working, Please help.
binding name="basicHttpBinding"  				 
closeTimeout="00:10:00" openTimeout="00:10:00" receiveTimeout="00:10:00" 
sendTimeout="00:10:00"

Open in new window

2
I have the webmethod below and it works fine.
Now, I need to add database bind  because I have gridview inside of this page. In this case, what can i do?

 [WebMethod]
        public static string RemoveXMLData(int messageID)
        {
            string result = "";
            try
            {
                string templatePath = HttpContext.Current.Request.PhysicalApplicationPath + "UserMessages.xml";
                XmlDocument xmlDoc = new XmlDocument();
                xmlDoc.Load(templatePath);
                try
                {
                    XmlNodeList nodeList = xmlDoc.SelectNodes("Users/User[MessageID = " + messageID + "]");

                    foreach (XmlNode xn in nodeList)
                    {
                        xn.ParentNode.RemoveChild(xn);
                    }                   
                    result = "Data deleted";                    
                }
                catch { result = "Some error in node deletion"; }
                finally
                {
                    xmlDoc.Save(templatePath);
                }
            }
            catch { result = "Eror in xml file loading"; }
            return result;
        }

     html = html + "<ul class='list-unstyled'>" +
                                          "<li class='left clearfix'>" +
                                          "<span class='chat-img1 pull-left' style='vertical-align: text-top;'>" +
                                          "<i class='fa 

Open in new window

0
I want to store HTML code in database.
is it possible? If yes then how?
0
I have an existing Access 2010 database with a lot of VBA code.  I'd like to be able to add a couple very simple webforms so that users can submit data to the database but I am not sure how to accomplish this.  I know a hybrid access database can be built but I guess I'm concerned that I would have to start with a "web database" and I dont want to recreate this whole thing. Is there a way for me to add a simple web form for use through my company intranet without recreating the whole database?
0
We have a server 2008 R2 server with SQL server 2008 R2, running 16 GB of memory, 64 bit OS, Xeon X340 @ 2.4Ghz.

All resources are funnelled towards the SQL application, we seem to have intermittent slow down and performance issues where the Disk queue jumps up to 2.95, IO is 10 MB/Sec

System PID 0 is using the most total Bytes per second of: 8,720,200

Heaviest disk IO is the SQL application itself.

This only seems to happen sporadically two or three times a day, and I haven't been able to correlate it to any specific task or backup job running during that period of time.


This SQL server services multiple sites with users directly accessing the database (no terminal server or replication to local SQL). And all users are affected by the performance issues.

The disk speed is 7200 RPM and the server hosting them is from 2010.

Any ideas?
0
We have 2 Citrix servers and both have Access on them.  The users use accde to open the frontend.  For some reason today on one of the servers we are getting the message "The database is in an unrecognized format"  
I tested the users frontend directly from the database server it is stored on and it opens fine.
I also tested it from the Citrix server and it gets the error.
The accdb open fine, just not the accde

I did a Compile and created a new accde and placed it in the users folder.  I did a repair of Office on the server.

The server is 2016 and the database is 2013 Professional

What could be the cause
0
Dears, I am working on a code which reads some alarms from network and decide to take some action, the alarms are sent to my server using SNMP, currently i am using Kiwi syslog server to listen to SNMP traps at port 162 and import them into database, but the problem is this software is 32 bit and i am receiving about 100K MPH so kiwi stocks in not responding mode and miss some alarms (doesn't import to database), so i am looking for a software which works on windows server and receives SNMP traps and inserts them into database, any suggestion?
0
I am installing Oracle 11g R2 64bit on Windows Server 2008 R2 64 bit but when I get to database creation screen, the installation hangs at 2%. I have tried the installation without database creation and installation was sucessful but when I try creating database with Database Configuration Assistsnt, it still hangs at 2%. I did that and left the server overnight but I still the max it went was 12%.
I need urgent help on this please.
0
Free Tool: ZipGrep
LVL 9
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

I have a legacy app that I am converting to ASP.NET. The current application uses Oracle logins and roles for authentication and authorization. The dedicated DBA thinks using a single service account (stored encrypted in the web.config) with read / write / edit / delete table access is a bigger security risk than hundreds of users with direct database logins / access. The Oracle logins / roles are used to control access to sections on the UI AND the related database objects (i.e. access rules are generally duplicated on the front end and the back-end). I'm looking for ideas / sources to support the service account method for database access, as far as security risks go. Thanks in advance!
0
Hey everyone, I'm looking for suggestions and/or different points of view.

My company is collaborating with an external vendor (different domain than mine), and in that effort we need to keep a updated copy of the vendor's database internally.  Currently, we are simply having the vendor take a full backup every night of their database, we transfer it electronically and then we are restoring that database internally.  We'd like to have our internal database refreshed more frequently than once a day however.  Our internal users need to have full control over the internal copy of this database.

We're using Microsoft SQL 2014 on all instances involved.

What is the best way of going about this with the following (perceived) limitations:
          1. Log Shipping - The database cannot be in "read-only" mode during business hours
          2. Backup and restore - This means we can only have a daily restore, as the database needs to be live all day
          3. Availability Groups - The instances involved are in different domains
          4. Replication - This functionality seems to have many deprecated features

In advance, thanks for any help,
Corey
0
Hi,

I have a requirement where I need to search a particular email in lotus notes through .NET code. Post to this, I would be sending text message if in case search finds the email.
Currently I am working on the first part where I am facing problem to connect with lotus notes through .net code. I am using below code -

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            Domino.NotesSession session = new Domino.NotesSession();
            session.Initialize("available.1607");
            Domino.NotesDatabase NotesDb = session.GetDatabase(session.ServerName, @"C:\notes\data\as_Sneha.nsf", false); //Open Notes Database
            //Domino.NotesView mailView = null;
           // mailView = NotesDb.GetView("($Inbox)");
            Domino.NotesDateTime _dateTime = session.CreateDateTime(DateTime.Now.ToString());

            // Domino.NotesDateTime _dateTime = session.CreateDateTime(String.Empty);
            Domino.NotesDocumentCollection collection = null;
            collection = NotesDb.Search("@Contains(Subject;'IBM')", _dateTime, 5000000);
           // collection.ReplaceItemValue("CALENDARDATETIME", _datetime.LSLocalTime); //maybe GetLSLocalTime...

            _lblNo.Text = "Total Number of Bounced Email(s)…
0
I have lost access to the Distributor and Subscriber servers, and need to delete the publication.
I managed to delete the (pull) subscription database, locally only, so the subscription still shows as orphaned, on the publisher server.

I am trying to simply delete all replication related components.

I am trying to remove the publication, but I get an error that it cannot be removed due to a connected subscription.

I then try to remove the subscription, usign the script below - but I get a message that the subscription does not exist?

Can anyone help with why?

(Remove Subscription Command)

--Select your publication database

USE NeXus

GO

DECLARE @publication AS sysname;

DECLARE @subscriber AS sysname;

--enter your publication name

SET @publication = N'NxPub';

--enter subscriber name

SET @subscriber = N'NxSub';

USE [NeX]

EXEC sp_dropsubscription

@publication = @publication,

@article = N'all',

@subscriber = @subscriber

,@ignore_distributor=1;

GO
0
I have created a HTML form which allows customers to upload documents and fill in a HTML form which collects (Title, Forename, Email address, Account number, type of document (which is a dropdown and the options are pulled from the database) and the file).

I want the input information to be put into two of my tables 'Customers' and 'Uploads' this website is hosted on GoDaddy.

If the customer has used the site before then their customer record will already be in the Customers table and therefore I do not want to re-add the data as there will be duplicate of data.

So I am trying to search the database for the customer record in the Customer table - if it exists then to carry on and take their Customer_ID to create a record in the Uploads table with the remaining information (Type of document, file location, and linked to the customer_id).

Below is the code I have so far and it seems to always add a new record even if it exists in the database and doesn't upload to the Uploads table.

If anyone could help it would be much appreciated.

<?php
$host = "";
$root = "";
$pw = "";
$db ="";
$mysqli = new mysqli($host, $root, $pw, $db);

if($mysqli === false) {
die("erorr: could not connect." .$mysqli->connect_error);
}

$title = $mysqli->real_escape_string($_POST['Title']);
$forename = $mysqli->real_escape_string($_POST['Forename']);
$surname = $mysqli->real_escape_string($_POST['Surname']);
$email = $mysqli->real_escape_string($_POST['Email']);
0
Hello Experts.

A while back, I received some awesome assistance with learning how to fetch data from an Excel range, and place it directly into a DataGridView container using the following code:
    Private Sub RefreshData()
        'Create the connection string to connect to the Microsoft Excel Workbook
        Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" _
                                    & XL & ";Extended Properties = ""Excel 12.0 Xml;HDR=YES"""
        'Create a standard SELECT SQL statement
        Dim selectStatement As String = _
            "SELECT Player_No, Player_Name, SL, Team_ID, Team_No, Team_Name FROM [Roster$]"
        Dim adapter As New OleDbDataAdapter(selectStatement, connectionString)
        Dim excelData As New DataTable
        'Create a DataAdapter that will be used to populate a DataTable with data
        Try
            'The code to open a connection and execute a statement 
            adapter.Fill(excelData)
        Catch ex As InvalidOperationException
            MessageBox.Show(ex.Message)
        Catch ex As OleDbException
            MessageBox.Show(ex.Message)
        Finally
            'Any tidy up code here to release resources
        End Try
        'Display the data in the excelDataGridView
        PlayerDataGrid.DataSource = excelData
    End Sub

Open in new window

Since then, my project has transitioned to using all bound data tables which originate from Access. One offshoot is that I no longer use just the one datagridview, but have separated the data into a more relational database format (Roster data in one table, Team data in another, etc.).
I thought for sure I could do this easily enough, but I'm stuck scratching my head. Perhaps someone could point me in the right direction?
Also, I would like to at the very least allow users who have older versions of Excel (.XLS) and even those with no Excel (for example, they could format it as a .CSV) to accomplish the same result.
If you want the scheme for the Roster and Teams data files, it looks something like this:
Roster and Teams Schema
0

Databases

54K

Solutions

38K

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.