Databases

57K

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

I have  Grid   dgvDetailsTable  that  has already being populated by data from

the database (see attached)

Grid  Showing data already retrieved from the database
I now need to add a new row  with the statement  int n = dgvDetailsTable.Rows.Add() under the AddRow Button
 and have the error below

Error Screen on Clicking the AddRow Button
Technically what the  error is , is that i can not add enter directly  when the field are attached to a datasource.

I have searched the web for a possible solution and obtained what looked like a solution ( see script below  )

 if (textBox1.Text == "" | textBox3.Text == "" | textBox4.Text == "" | comboBox1.SelectedIndex == 0 | textBox5.Text == "" | textBox6.Text == "" | textBox7.Text == "" | textBox8.Text == "" | textBox9.Text == "" | textBox10.Text == "" | textBox11.Text == "" | textBox12.Text == "")
            {
                MessageBox.Show("Values Should not Be empty!");
                textBox3.Focus();
            }
            else
            {
                dgvDetailsTable.Rows.Add(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, richTextBox1.Text, comboBox1.Text, textBox5.Text, comboBox2.Text, textBox6.Text, textBox7.Text, textBox8.Text, textBox9.Text, textBox10.Text, textBox11.Text, textBox12.Text);
            }

I have 2 problems

1. What is text1.Text refering to   ( is it the   field name as in the database or the name given the field on the Grid)

For instance   while my database field name is  staff_no  the equivalent Grid name…
0
CompTIA Cloud+
LVL 13
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Hi,
I am importing data from a CSV file into SQL Server Express and one of the columns contains data format  £5,420 or  €5,420
Can the SQL table column be modified to accommodate data ? I would prefer it to be converted to format  5420 or  5420 if possible.
How can I go about it.
Thanks
Ian
0
I am using ASP.NET with an MVC 5 project and entity framework. I want to remove the required attribute that is created implicitly based on the SQL database field. I keep getting entity validation errors on the EMailAddress2 field in the form. I tried these two things among others.

1)  I added @{ Html.EnableClientValidation(false);} to the code in the create view for that div, but that did not resolve the issue.
2) I added DataAnnotationsModelValidatorProvider.AddImplicitRequiredAttributeForValueTypes = false; to the global.asax.

Create view code:

<h2>Create</h2>

@{ Html.EnableClientValidation(false);}
@using (Html.BeginForm())
{
    @Html.AntiForgeryToken()

    <div class="form-horizontal">
        <h4>user</h4>
        <hr />
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })
        <div class="form-group">
            @Html.LabelFor(model => model.CustomerName, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.CustomerName, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.CustomerName, "", new { @class = "text-danger" })
            </div>
        </div>

        <div class="form-group">
            @Html.LabelFor(model => model.AccountNumber, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model 

Open in new window

0
I've recovery my windows OS then i found mysql folder in Windows.old folder.  and MySQL unistalled or windows restored to previous version before MySQL Installed.
I try to make Solution as follows:
1- I've used New PC with Mysql .
2- stop Mysql Services.
3- replace Data folder.
4- When try to start MySQL again error 1067 is appear.

how can i recovery data from ibdata1 file and *.frm
0
We have a clean install of Windows Server 2008 Standard R2 and SQL Server 2014.    One of the *.bak files was restored from our damaged RAID 5 drives.    I've found instructions on how to restore with SQL 2005, but nothing for 2014.    I have very little knowledge of SQL, so I'm unsure whether I need to create a new database prior to the restore or whether it will recognize that it's not there and create it during the restore process.  The developer who installed and configure our database a couple of years ago is out of the country and not near a computer.  Can someone walk me thru it, or point me to instructions?  

Thanking you in advance.
0
We have an inactive mailbox server (Exchange 2010 SP1) that shows as one of the Generation Servers for the Default Offline Address List.  The server is NARSCEXMB01.  Can I simply move this to another server or do I even have to since there is another Default Offline Address List (Ex2013) that is enabled as the default? The other question to this is that the targeted Default Offline Address list is set for Web-Based distribution, so would I have to disable this or will the move take over this distribution job?  This Exchange server had mb's hosting local archives but all users/archives have been migrated to EXO so there is no mailboxes/archives that reside on the databases and the databases have been removed.  OAB.PNG
0
For my own learning I need to build a Glossary API.

My idea is to have a similar structure in the database:

TERMS table
ID      ACRONYM      DESCRIPTION      CATEGORY  

CATEGORY table
ID      NAME      DESCRIPTION

A glossary is basically a dictionary that works for different knowledge domains.

For example it will contain the acronym DVD and it will explain that in IT category it means Digital Versatile Disk.
It could also be, clearly, that DVD means something different in a different domain.

My question is...

What kind of relationship should I create between the two tables in order to have a clean, quick and efficient database?

My idea was to build a Many-to-Many relationship in a third table like this:

TERMS_CATEGORIES
ID      TERM_ID      CATEGORY_ID

Would this solution be a good one?

Thanks for your kind help.
0
Issue in Brief: Unable to add node back to the cluster.

Details of the issue: We noticed that one of the nodes in the two node cluster(node & disk majority) is 'down' in FCM.  However, we're able to ping it from another node and also RDP into it.

Troubleshooting Performed:
-Tried to evict and re-add the problematic node to the cluster, but unsuccessful in doing so - both via. PowerShell and via. GUI.
-Also rebooted the node, and performed the above operation.  Still no luck.
  Error: Unable to successfully cleanup.
-Applied "Clear-ClusterNode" and it was successful.
-Then, tried to re-add the node but received the same error, but through GUI & PowerShell.
-Rebooted the problematic node; still getting the same error.
-Upon further investigation, we noticed that  the "CLUSDB" was missing in the registry of the problematic node.
-Copied the database to the problematic node (from the other node), and tried to load it in the registry, without success.
-Then copied the "CLUSDB.blf" file to the location, renamed it to "CLUSDB" and tried to add the node again.  Still getting the same error.

-Looked into AD, and found the appropriate CNO for the cluster, and VCOs of its corresponding nodes.

-Noticed below error in the cluster logs as part of our investigation.

"New join with n2: stage: 'Authenticate Initial Connection' status HrError(0x80090301) reason: '[SV] Authentication failed'"

-Did a "portquery" on the other node, from the problematic node and it …
0
Hi all - I know this may sound like a simple/stupid question but I'm having issues printing an entire database diagram I created in SQL Server Express 2017.  I'm able to change the page setup so that I can get it all to print on a reasonable number of legal sized pages but when I send the diagram to print it only prints the first page of the diagram even though 'All Pages' is selected in the print dialog.  What in the world am I missing - seems so simple and I know I've done it before.  Any insights or suggestions for a different means by which to print this diagram would be greatly appreciated.
0
Does anyone have some thought on "the preferred sorting collation" for (unicode) data in a MSSQL database, for Chinese and also some other languages.
In other words: which collation would most people in these countries expect and consider to be "normal"?`

I am thinking about the following selected collations. Any input/experience on this?
All sorting should be case insensitive.

cn/China mainland: Chinese_Simplified_Stroke_Order_100_CI_AS_SC
ru/Russia: Cyrillic_General_CI_AS
ee/Estonia: Estonian_CI_AS
sk/Slovakia: Slovak_CI_AS
it/Italy: Latin1_General_CI_AS
fi/Finland: Finnish_Swedish_CI_AS
se/Sweden: Finnish_Swedish_CI_AS
en/USA: Latin1_General_CI_AS
no/Norway: Danish_Norwegian_CI_AS
fr/France: French_CI_AS
es/Spain: Modern_Spanish_CI_AS
de/Germany: Latin1_General_CI_AS
dk/Denmark: Danish_Norwegian_CI_AS
pl/Poland: Polish_CI_AS
none: Latin1_General_BIN2
0
Ensure Business Longevity with As-A-Service
Ensure Business Longevity with As-A-Service

Using the as-a-service approach for your business model allows you to grow your revenue stream with new practice areas, without forcing you to part ways with existing clients just because they don’t fit the mold of your new service offerings.

I would like to deploy an old asmx web service to azure from visual studio 2017.  Need to deploy the database as well. I can create the database using sql and populate it using sql if that is easier.  Please advise best recommendation.  Thanks in advance.
0
I am looking for a SQL server script that would do the following:

1) Uncheck the "Enforce password policy"  for ALL the Logins(sql server authentication) that have the
   "Enforce password policy" enabled
2) and logins that are mapped to one specific database
3) and is not a system login (like ''sa'')
0
HI,

I have Exchange 2016 DAG in co-existence with Exchange 2010. We are migrating the users from Exchange 2010 to Exchange 2016.  

I would like to know the logs and data migrated from 2010 to 2016, replicated first on which server in 2016 DAG. Is it replicated/migrated first on the server where 2016 mailbox database is mounted?
0
Hi Experts,

I am receiving complaints from users from time to time that they are getting an error on a linked SQL view that could not be updated (see attached).

However the strange thing is that when I try doing that same change on my pc it works, moreover after a while (sometimes next day) the error doesn't occur on theirs either...

Any idea how to troubleshoot this?

Below is the SQL of the view in question.

SELECT     dbo.Skilled_Nursing_Visit_Note.ID, dbo.SNV_Printed_History.VendorsID, dbo.SNV_Printed_History.SNV_ID, dbo.Skilled_Nursing_Visit_Note.Client_Last_Name, 
                      dbo.Skilled_Nursing_Visit_Note.Nurse_Signature_Last_Name, dbo.Skilled_Nursing_Visit_Note.Visit_Date, dbo.Skilled_Nursing_Visit_Note.Shift_From_Hour, 
                      dbo.Skilled_Nursing_Visit_Note.Shift_To_Hour, dbo.Skilled_Nursing_Visit_Note.Date_Signed, dbo.Skilled_Nursing_Visit_Note.Nurse_Name_Stamp_SNV, 
                      dbo.Skilled_Nursing_Visit_Note.Nurse_User_ID_num_SNV, dbo.SNV_Printed_History.ReviewedBy, dbo.SNV_Printed_History.ReviewedDate, dbo.SNV_Printed_History.PrintedDate, 
                      dbo.SNV_Printed_History.PrintedBy, dbo.Skilled_Nursing_Visit_Note.Client_First_Name, dbo.Skilled_Nursing_Visit_Note.Nurse_Signature_First_Name, 
                      dbo.Skilled_Nursing_Visit_Note.Date_Of_Birth, dbo.Skilled_Nursing_Visit_Note.Shift_From_Minute, dbo.Skilled_Nursing_Visit_Note.Shift_To_Minute, 
                      

Open in new window

0
In Postgres how to track DML changes on a table like insert/update /delete for each row through RULE efficiently . we have tried like below but it seems on the same table if we have multiple rules somehow it is not working.  We have to use RULE only, triggers are not supported in our database. we use Greenplum.
please  suggest with the updated scripts with any other better solutions.

--Update rule
need to log updated records along with other columns which did not change

DROP RULE IF EXISTS vc_rule_upd ON CORE.VC_TEST_RULE CASCADE;

CREATE OR REPLACE RULE vc_rule_upd AS ON UPDATE TO public.VC_TEST_RULE
    WHERE NEW.AUDIT_TO_TS <> OLD.AUDIT_TO_TS
    DO INSERT INTO public.vc_rule_log_table VALUES (
                                    OLD.customer_id,
                                                      OLD.customer_name,
                                                      OLD.sal,
                                                      NEW.audit_to_ts,
                                                      OLD.audit_user_id,
                                                      OLD.job_id,
                                    current_user,
                                    current_timestamp
                                );
      
                                                
--Insert/update rule

if inserting row is new row we need we need log the new row,
if that row already existed then update ( not sure how to add insert/update on the same rule)                                                  

DROP RULE IF EXISTS vc_rule_ins ON public.VC_TEST_RULE CASCADE;

CREATE OR REPLACE RULE vc_rule_ins AS ON INSERT TO public.VC_TEST_RULE
      WHERE NEW.customer_id <> OLD.customer_id
       DO INSERT INTO …
0
i have directory websites with about 50+ rental owners. We basically store all of the their information in the MS SQL database included name and email.
Recently, we want to expand billing option on the website and allow potential customer to pay online e.g. john smiths(consumer) may purchase 1 day pass to access mary chan's house (rental owners).

My website works as middle man. so I hope to allow rental owner to submit their paypal email and some account infor of Paypal so I can send their information to Paypal API to complete the transaction.

My questions.

1. In my case, above plan makes senses? and Can paypal actually do that? If yes, can you drop me some good information.
2. Except Paypal, do you see any other vendors can do the same thing?

Thanks
0
Good morning,

A strange one, but I have a question regarding a problem to which I already have a working solution!! The issue is that the solution I have just seems a little "over complex" for the simple problem it aims to solve!! I am sure that there must be a simpler solution to the problem that I am just not seeing. I will have to describe the situation in generic terms as I have been advised not to give too much "information" away. Say no more.

The system we have is manufacturing widgets, and the manufacturing planner assigns "jobs" to the manufacturing machines throughout the day. The planning for jobs can change constantly throughout the day as priorities change, the only constant being that once a job is being actively made, it cannot be interrupted so stays as the "active" job on the machine until complete.

The screen on the machine shows the operators a list of planned jobs, displaying a maximum of ten jobs including the active job at the top of the list. The displayed list indicates the jobs where planning has changed (based on the planning state as at the commencement of the current job). Due to the nature of the planning and its ever changing state, the operators need to be kept updated of planning changes - so the software interrogates the planned jobs list for the machine on a regular basis (currently every 5 minutes - this is currently deemed sufficient and manufacturing jobs run for an hour or more depending on quantities). Due to the database …
0
I am getting a VBScript runtime type missmatch when adding date to string to update record in MS SQL 98 database using ASP classic.. old tech i know but need use of this code, it worked when i last accessed it 4 years ago,
0
I have two tables in a MySQL database with almost identical structure.

I want to copy the "from" table to the "to table" without having to mention every column by name.

The "to table", purposely, has one more column at the end that is auto increment.

Is there a way to "copy corresponding", so to speak? Either in phpMysql or in php code.

Thanks
0
OWASP Proactive Controls
LVL 13
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

In my shop we continue to be in "database performance hell"; albeit highly suspect our J2EE application code's poor design.  It is well known our application has problems, but at the end of the day everything culminates with the database.  Our application developers use Hibernate, and JPA to interface with our 3-Node Oracle 12c RAC database.

We are generating all of the usually reports ( AWR, ADDM, ASH ) in an attempt to nail down where the problems are.  And, yes the reports have identified 8 or so really bad queries, in some cases with either no recommendation, or recommendations to re-write.  Should have mentioned earlier, the database team does write or generate any of the SQL-queries for the application, these are all originated from the application developers.

We now realize performance should be monitored over a period of time. These reports are not easy to understand and as you know have a huge amounts of information.  Hugely suspect some information is more relevant than others.

 Big question:  if my team needs to focus in on 3-4 items in the AWR, ADDM, ASH reports --which/what items should we set our attention to?
1
Hi All,

I try to restore MS SQL database using SSMS.

Saya I want to restore from ERV_GL to KKP_GL.
What I do :

1. Create database KKP_GL
2. Restore from ERV_GL.BAK at database KKP_GL

The problem is ERV_GL also get restore.

What is the problem?
How to solve this problem?

Thank you.
0
Hi,
I have a situation to rebuild the log file for attaching the database. I have this Stored Procedure. I want to add this line so that I can do automation for attaching multiple data files.

I want to add this line FOR ATTACH_FORCE_REBUILD_LOG in the following SP

USE [master]
GO

/****** Object:  StoredProcedure [dbo].[usp_MultiAttachSingleMDFFiles]    Script Date: 4/11/2019 8:17:58 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

 
ALTER PROCEDURE [dbo].[usp_MultiAttachSingleMDFFiles] ( @mdfTempDir nvarchar(500) )
AS
BEGIN 
DECLARE @dirstmt nvarchar(1000)
DECLARE @currFile nvarchar(160)
DECLARE @db_name nvarchar(256)
DECLARE @phys_name nvarchar(520)
DECLARE @dbccstmt nvarchar(1000)
DECLARE @db2attch_ver INT
DECLARE @curr_srv_ver INT 
DECLARE @mdfFileNames TABLE (mdfFile nvarchar(260))
DECLARE @mdfFileATTR TABLE (attrName sql_variant, attrValue sql_variant)
 
DECLARE cf CURSOR FOR SELECT mdfFile FROM @mdfFileNames
SET NOCOUNT ON
-- get all mdf file names only , in bare format.
SET @dirstmt = 'dir /b "' + @mdfTempDir + '"\*.mdf'
INSERT into @mdfFileNames 
EXEC xp_cmdshell @dirstmt
 
DELETE from @mdfFileNames where mdfFile IS NULL or mdfFile = 'File Not Found'
-- if file is already attached skip it
DELETE FROM @mdfFileNames 
WHERE mdfFile IN (SELECT mdfFile FROM @mdfFileNames a INNER JOIN sys.master_files b ON lower(@mdfTempDir + '\' + a.mdfFile) = lower(b.physical_name) )
-- if no files exist then exit process
IF not exists (SELECT TOP 1 * FROM 

Open in new window

0
I am trying to split a MS Access 2016 database on a sharepoint server. When i try re-linking the tables in he FE to the BE in the Share point it keeps saying file not found. Please Help!
0
Should I install memcache on a server which has MongoDB ?

What benefits will it bring ? Performance ?

Thanks
0
hi,

what kind of database management tools you guys can suggest for mariaDB ?

we are migrating from Oracle to MariaDB and because of the tools limitation, we can see that some tools, like mySQL workbench can't see all index migrated but some of the index can be seen from Toad for MySQL. but not all information like constraint can be seen from Toad for MySQL.

please suggest,
0

Databases

57K

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.