Expiring Today—Celebrate 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 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
Get your Disaster Recovery as a Service basics
LVL 1
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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
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
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
Hi to All of you,
I have a server running Linux Red Hat 7 and Nessus Professional installed . I Need to move nessus on a new server and migrate all the activities I made during the last years ( 100 of network scans )

Is there a procedure to perform the backup and restore of Nessus to a different server mantaing all the jobs and reports?
Thank you
Carlettus
0
I'm about to start working on a database to be used by our staff and County/Municipal officials.  Is there a way to consume an Access database online?  Or will I have to just place it somewhere for download?  We have Sharepoint and MS 365.  Would it be easier to create a database to share with Sharepoint?  If so, I'm not very familiar with Sharepoint tables and would love some video or tutorial resources.  Thank you!
1
We are having an issue on our SQL server where jobs that send out a lot of emails send some emails but not all of the them.  In going through the logs the emails are sending fine and report 'Mail successfully sent' and then all of a sudden the error comes up with 'The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2017-09-18T12:16:43). Exception Message: Cannot send mails to mail server. (The operation has timed out.).).  It seems to fail at different intervals.

On the failure emails, the last_mod_user in the sysmail_event_log is 'sa' and the account_id is NULL.  However, on the successfully sent emails, the last_mod_user is 'DOMAIN\Administrator' and the account_id is 1.  It almost appears as if the Administrator looses connection and then the mail starts failing thereafter.

The same activity seems to happen regardless of running the proc manually or having the agent job initiate it.

The mail settings are (we use AuthSMTP.com to send):

Server Name: mail.authsmtp.com
Port: 2525
SSL: required
Basic Authentication with our AuthSMTP credentials.

Database Mail Executable Minimum Lifetime (seconds) = 600

Does anyone know why this would occur?  

Thank you.
0
Hi,

I have been trying to work with the below code. For Norway it changes to summertime 26th March 2017 and wintertime 29th October 2017. I want the query I am running to display if the current date is summertime/wintertime so I know if I need to add 1hr or 2hrs to the GMT time in my database. It does do this, but not for the dates that I want.

Public Function IsDST(ByVal d0 As Date) As Boolean
   IsDST = d0 >= NextSun("Mar 21 " & Year(d0)) And d0 < NextSun("Nov 01 " & Year(d0))
End Function

Private Function NextSun(d1 As Date) As Date
   NextSun = d1 + 7 - Weekday(d1)
End Function


My Query text: Season: IIf(IsDST([Date])=-1;"Summer";"Winter")

Any help would be appreciated as I would like to avoid having to change the dates manually for each year. I could also go for a table with start date & end date if that is easier.

Bgrds
1
Concerto Cloud for Software Providers & ISVs
LVL 4
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

hi i have upgrade the liabrary from 6i to 11g the foolowing code work in 6i but when i compile in 11g is giving error check attachment
erro0987.jpg
tpapi1Bdy.txt
tpapi1Spec.txt
0
Hello, i am creating an application in which i need to generate invoice! i have four different tables from which data is coming to print the invoice! i am using access database! my problem is that when the report gets loaded in the details section of the report it shows same records many times!
i have two tables bill details and bill particulars! bill details stores all the details like bill id, date, time, customer name, sub total, gst, discounts and grand total! the bill particulars table saves the products to be added under the bill so it has product id, qty, total amt
so if i have only one product under a bill the report shows the product once
if i have two products under bill then in report i get the entry of both products twice
and so on...
how to fix this?
0
Hello my expert friends.  I need a favor from someone who is excellent at relational Access Databases.  As I mentioned before I am self taught with what I know so far.  I am trying to create a relational database and for some reason when I think I got the tables linked correctly one or another is not communicating with each other.   No matter how much I seem to read up on relational database for some reason I am not understanding something.  Oh also this file is in Access 2000 file format.  I would appreciate any help someone could be.  Thanks so much in advance.  
Also feel free to add data if you need to this is just a practice database I am trying to learn from
Disney-Correctional-Center.mdb
0
Hello Experts,

I have a situation as follows,
I have to investigate data mismatch between three different databases

Current process I am following,

-I am taking sample data and comparing against 3 different database, a very manual process
- I am joining across 3 databases and getting records.
-Join is being done based on customerId and date

I need to find out which database has the wrong record..
--TableA has the authoritative data and TableC is the reporting database. mismatch across TableA,B and C has to be found  

Solution I am seeking
- How do I write a better query to find out in which database the non matching or the wrong record exist?..Here I have just given an example for just few records. the database I am working on has several million records..

DatabaseA
Table A

date      CustomerId      CustomerName
1/6/2005      1      John Quan
1/6/2005      2      Megan Muir
1/6/2005      3      Pete Sampras
1/6/2005      4      Bill Gambino
1/6/2005      5      Oscar Hernandez

DatabaseB
TableB
date      CustomerId      CustomerName
1/6/2005      1      John Qan--Name is wrong
1/6/2005      2      Megan Muir
1/6/2005      3      Pete Sampras
1/6/2005      4      Bill Gambino
1/6/2005      5      Oscar Hernandez


DatabaseC
TableC
date      CustomerId      CustomerName
1/6/2005      1      John Qan--Name is wrong as it is coming to this system from upstream database B, table B
1/6/2005      2      Megan Muir
1/6/2005      3      Pete Sampras
1/6/2005      4      Bill Gambino
1/6/2005      5      Oscar Hernandez
0
one of servers which is DAG ,moved to another site . but now the status of database is unknown and other items are bad copy.
what is your solution for this problem??
0
Hello everyone!

I am running with TFS 2015.3, and SQL Server 2016 SP1, in separate servers.

Recently, I change our production TFS Database from 32 bit to 64 bit (for updating purposes), and I believe we loose some database configuration and permissions.

This week (after the change), we are having some issues with some Jobs, related to Warehouse and Coverage Analysis:

-Work Item Tracking Warehouse Sync
-Test Management Warehouse Sync
-Team Foundation Server Coverage Analysis

The error that is shown is:

Microsoft.TeamFoundation.Framework.Server.DatabaseOperationTimeoutException: TF246018: The database operation exceeded the timeout limit and has been cancelled. Verify that the parameters of the operation are correct. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)…
0
Good Afternoon

I am using an Oracle Form (10g) and I would like to return multiple records in a field rather than just returning one row.  I tried Bulk Collection but I received a client side error.
0
Hello Team,

I have a question and need help and guidance.

We have 100 Domino servers with most of the database and applications in each servers.
I would like to know what are the pre requisites and steps should be taken before the servers are retired and as a Domino admin what are the steps to be taken?
0
Hi

Looking for SQL Server Database AdventureWorks based SQL exercises needed for extensive sql queries practices

Anybody know of SQL Server  excercise sanything like this?

Thanks
0
What does it mean to be "Always On"?
LVL 4
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Hello-
I have a query that need to meet the below criteria.  Attached is sample data and expected results.

I would like to write this criteria right in the MSACESS query.


1- For the SHORT_DESC field: Just want START or REFILL  in query results, anything else should not be included. Right now I am using:   "START" or "REFILL"   this works but I am not sure how to combine with the next criteria..

2- If there are more than one REFILL returned, the one that was logged first should
be START (in the SHORT_DESC field), the rest stay refill.  The only fields I have to find the earliest date/time is the POST DATE  and POST TIME field.

Thanks
SampleData_ExpectedResults.xlsx
0
How to display the size of tblmountertrace_1 (to) 9 to text box? Please see picture:

database table
Im using this code but I dont know how to query. I put it on the Timer (timSERVERSIZE) to update every 4 Hours a day.

        Private Sub timSERVERSIZE_Tick(sender As Object, e As EventArgs) Handles timSERVERSIZE.Tick
        Dim cmd2 As New MySqlCommand
        Dim myDA2 As New MySqlDataAdapter(cmd2)
        Dim myDT2 As New DataTable
        cmd2.Connection = conn
        cmd2.CommandText = "SELECT * FROM esd_reco ?????????????????????????????????????"
        myDA2.Fill(myDT2)
        TextBox1.items.add(myDA2)  <<<<<<<<<<<<??????????????????????????


    End Sub

Open in new window


Thanks for the help
0
How do combine the attached database into a single page for the form that acts as an entry form and also displays the information needed to be seen on a single web page?

Access may not be the best tool for this but if there is any way to pull it off with Access, I would like to.
VC1.accdb
0
I have an Access database that is used for event planning.  I have the following fields:
Invitee
Spouse
RSVP (a Yes/No dropdown)

I am trying to get a
Total number of Invitees
Total number of Yes RSVP's
Total number of No RSVP's
Total number of not replied, (RSVP field is blank)

I have the total number of Invitees working using the following...
=Count([Invitee])+Sum(Abs(IsNull([Spouse])=True))

I am not sure what to add to above to obtain the Yes, No, and blank RSVP numbers.

I feel like this is pretty basic stuff but I suck at SQL and don't know the proper syntax.  Any help is greatly appreciated!
0
Hello!

I am implementing a Web page in JavaScript with Angular.JS & ionic. A page generator is one of the menu items that has a header field where the user can load a file. With the [Save] button, the result is sent to the relational database.

The page generator is saving the whole generated HTML object in the database like

	<div class="hero-image" ivm-bg-axis="y" ivm-bg-drag="" ivm-bg-disabled="disabled" ng-style="imageOptions.style" ngf-background="ngModel" style="background-image: url(&quot;blob:null/3dfb1617-e1c8-45e8-9c0e-5f772129d2cb&quot;);"></div>

Open in new window


where the image is denoted with style="background-image: url(&quot;blob:null/3dfb1617-e1c8-45e8-9c0e-5f772129d2cb&quot;);. This is probably the unique key of the cached browser object, is it? If so, I want to save this image as a BLOB object, say, in another field of the same database record.

Question: How is it possible to get this image out of the browser? Is there a difference getting out this information between different browsers?

Thank you for your reply!
0
I now have two pages. A Searchpage and a Presentation- and upload page.

Searchpage: http://kroweb.dk/gfdev/gravsten_raw/

Presentation/upload page: http://kroweb.dk/gfdev/dataupload/

Both these pages works fine as it is now. The presentation/upload page uploads the entered data in the dataform to a new record in the database, and it uploads an image to a specified folder on the server.

When entering a searchstring e.g.”Lyng” on the Searchpage, it returns a list of results, where entries in the first column (with the headline “Sogn”) links to the Presentation/upload page.

The task now, is to get these two pages to work together, and to create the right common functionality.

(From here I need help to create the right code)

Clicking the link that opens the Presentation/upload page should do two things:

1.      Grab the id of the selected record from the “id” column in the database
2.      Retrieve and insert in the headline of the updateform (where it says …. ‘Sogn’ right now), the entry in the row “Sogn” in the actual record in the db. And at the same time retrieve data, if any is present, from the rows “navn”, “tlf”, “email” and “besked” in the database and insert them in the appropriate fields in the form. Finally it should display images, if any present, tied to the specific record on the page (see also  bullet 2. Below).

Furthermore I need to use the id for:

1.      Use in an SQL update query like: $sql = "UPDATE my_table SET name='name in form', …
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.