Databases

58K

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.

I've read Microsoft's explanation on joining a database to an availability group using the "join only" and "skip initial data synchronization" options, but I don't get it. Both appear to be the same. I'm restoring the database in no recovery mode and both appear to join the secondary database to the group in the same way. So what's the difference?
0
I had to create a new CD.mdb database due to errors in the index.
I imported all tables, forms, queries, etc. successfully.  No index error found while compacting database.

I replicated the database to three other users, while keeping the design master on my computer.

When the other users open their replica, as error appears:   Missing or broken reference to OWC10.DLL.

How can I fix this problem?

Here are 2 images:

 Image 1
Image 2
I hope to resolve this before the users return to work on Monday.

Thank you for your help!
0
In Access I have created a customer database and an invoice for my customers.  When a new customer comes in I input their info in the customer database and then in the invoice I us a combo box to find the customer and populate the info in the invoice. The problem I am running into is that when I enter a new customer and then go to the invoice it cannot find the customer info..  I have to click on refresh, refresh all, before it will see the new customer even though I have created a saved button and click on "save".   Is there a way to get Access to save the customer record so that I can go directly to the invoice and pull up the customer info without going through so many steps?
0
I have  two fields I want to update using CASE WHEN Syntax.
The fields are PipUPC and TUPC. I don't know how to set the fields with the ELSE END syntax using the CASE WHEN.
Essentially what I need is:
1) check the PipUPC and if it is null, update  update with the List_UPC  value  from ActionList2020  table ELSE keep the  current value in the cell.
2)Check the TUPC and if null, update with the List_UPC  value  from ActionList2020  table ELSE current value of the in the cell.



Update
.[dbo].[UpdateProcessSales] 

Set PipUPC=
(

CASE WHEN PipUPC is NULL then t2.List_UPC,
 WHEN TUPC is NULL then UPC=t2.List_UPC
ELSE END,
)
from
[dbo].[UpdateProcessSales] t1
inner join
[dbo].[ActionLIst2020] t2
on t1.PNumber=t2.Price_Code

Open in new window

0
We have around 6 billion rows in a single table
We are running some scripts to clear out old data
However the size of the database does not seem to be reducing by much (i know the MDF file will stay same size and i've looked at space available inside this file)
Do we have to somehow defrag the table?
I've looked into index rebuilds are they are highly fragmented, and wondering if this is what we have to do to release the space

Any feedback appreciated
(Sql server 2017 enterprise)
0
imported an excel file (csv) into a database. IS there any way to cancel the data import. Someone accidentally imported a batch file into a mysql database. They imported client ids and choose the wrong client on the drop down when importing. The tables are modified as well. I am not familar with the setup of the tables as this is not my area. Would I have to go into the backups and take earlier copy ? In addition, the database was updated throughout the day so a backup would override updates. . I can view the front end of mysql how can I view the backend and get to the workbench if I need to query the database for these records? Thanks in advance Any ideas on how to resolve this erroneous excel import?
0
How can I move objects (tables and queries) from assigned to unassigned objects in access database.

Thank you
0
What is wring with this?
select
[MembersDetails].[Forename], [MembersDetails].[Surname]
From [InstantCRM]

The database is called InstantCRM and the table names are correct

I have selected the InstantCRM database in the ribbon
0
Hello, I'm trying to up an Oracle Database for a customer, and i have a few issues with it.

When i'm on a DOS and type "lsnrctl status <service_name>
i got an answer "Instance <name>, status BLOCKED, comport 1 handler(s) for this service..."
Command Success. (Could be not 100% accurate as I trad myself from french)

In a other hand, when i'm trying to connect with SQLPlus on the DB,  i got the following :
"ORA-01033: ORACLE initialization or shutdown in progress"

All services linked to Oracle are running exept OracleRemExecServiceV2.

As my lsnrctl start, stop and status gives answers, I dont know if problem comes from my listener.ora/tnsnames.ora (that was the previous problem I got and think have pass through).

Also SQLDeveloper send back the ORA-01033 error too.

The oracle DB version is 12c 12.1.0.2.0.
OS is Windows Server 2016 64 bits

Blocked Message afterr lsnrctl status

ORA 01033 at login attempt
I've tried to shutdown then startup DB, reload services.
The only thing I got is tnsping answer well.

If you need anything more for precision feel free to ask.

Thank by advance if you have an answer, I digged in many sites but no one give a clear answer that applied well for me.
0
Hi Experts,

We have a report based on Nurses table.

Then we have a table named Skilled_nursing_Visit_Notes (Nurse_Table.Nurse_UserName = Skilled_Nursing_Visit_note.Nurse_User_ID_num_SNV) where nurses enter visits and notes for patients.

Under each visit note there is a column named Browser which auto saves the browser version used for that entry.
We also have a calculated field (formula) in the Skilled_nursing_Visit_Notes  table named OutdatedBrowser set as follows.
case when ([@field:Browser] like 'Chrome%' and [@field:Browser]>='Chrome 78.0') or ([@field:Browser] like 'Safari%' and CAST((Right([@field:Browser],(Len([@field:Browser])-Charindex(' ', [@field:Browser], 0)))) as FLOAT) >= 13) or ([@field:Browser] like 'Firefox%' and [@field:Browser]>='Firefox 71.0') or ([@field:Browser] like 'InternetExplorer%' and [@field:Browser]>='InternetExplorer 11.0') then 'No' Else 'Yes' end

Open in new window


Now we would like to add to the nurses report the following.

1- Ability to filter for nurses with Outdated browser (According to latest entry in Skilled_Nursing_Visit_Notes table determined by Date_Signed field which is a timestamp field).
2- View on the report the browser field.

Thanks
0
Hi Experts,

Recently I upgraded to Windows 10 and Access 2016 Plus.  All of my software is totally up-to-date.

I have an Event that is is used to relink the FE to the BE Databases.  This code has been working for years both on a local PC and to network locations including Dropbox.  It still works on the local PC however it no longer works on Dropbox.

I have attaching a copy of the messgae and code for your reference although it is quite long and complex.

I checked Google and found numerous references to this error, none of which I was comfortable with as it is an area I am not well educated in so I have decided to come to you for a specific answer.

Thanks,
Bob C.Windows-10-Access-2016-Plus-Error-3.docx
0
Hi Team,

Iam running Oracle 11g r2 database , Iam getting the below error when I try to login into the database. Iam new to Oracle DBA .

I tried logging in as below and run the below command

sqlplus / as sysdba

sql> alter database orcl open;

I get the below error

rror starting at line 1 in command:
alter database orcl open
Error report:
SQL Error: ORA-00355: change numbers out of order
ORA-00353: log corruption near block 9972 change 57969482 time 01/28/2020 17:08:22
ORA-00312: online log 1 thread 1: 'E:\APP\oracomp\ORADATA\ORCL\REDO01.LOG'
00355. 00000 -  "change numbers out of order"
*Cause:    A change number found in the redo log is lower than a previously
           encountered change number. The log is corrupted in some way. The
           corruption may be at the earlier change or at this one.
*Action:   Do recovery with a good version of the log or do time based
           recovery up to the indicated time.


Kindly let me know what is the solution for this error and cause of the error. Any help is really appreciated
0
Hi!

I'm creating a Maria DB project (MySQL) using C#, and I have a need to get the primary key Id from a row I just insert into a table.

I've looked at several solutions on the internet and I'm not having any success.  They are either unreliable (documented errors) or do not work with MySql/Maria.

This is my last effort:


 MySqlCommand cmd = new MySqlCommand("INSERT INTO bbb.traveldocuments (CustomerID,TDNumber,TDDateCreated,TDMoveStart,TDMoveEnd,TDJobNumber,TDPermitType,TDNotes)" + "VALUES(@CustomerID,@TDNumber,@TDDateCreated,@TDMoveStart,@TDMoveEnd,@TDJobNumber,@TDPermitType,@TDNotes); SELECT SCOPE_IDENTITY() ", con);

.
.
.
cmd.Parameters.AddWithValue("@TDNotes", txtBox_TD_Notes.Text);

cmd.ExecuteNonQuery();
int insertedID = Convert.ToInt32(cmd.ExecuteScalar());


When I run the above code I get:

MySql.Data.MySqlClient.MySqlException: 'FUNCTION SCOPE_IDENTITY does not exist'

Are there any suggestions I can try?

Thank you in advance.

G
0
I have an Sql Server 2016 Database with tables TB_Cable,   TB_Item, TB_Connection

Samples data below  ( There are more fileds on each table)
TB_Cable
Cable_ID     Cable_Num    CableLoc
  C1                Cable1             123,St
  C2                 Cable2             345,St
  C3                 Cable3             456,St


TB_Items
 Item_ID            ItemName
    I1                        Item1
    I2                        Item2
    I3                        Item3

TB_Connection
  Cable_ID    Item_ID
    C1                  I1
    C2                  I3

I am looking for the query to give result as follows
Result of query   ( Has all cable . Lists Items when Cable is connected.  For other cables just "Vacant" is displayed for Item
Cable&Connection
-----------------------
   CableNum    CableLoc   ItemName
      Cable1          123,St       Item1
      Cable2          345,st        Item2
      Cable3           456,St       Vacant
0
Hi everyone,
I have a word template that merges data from a sql DB.  I did not write it.  The server crashed and a new server was installed.  I am having a connection problem.  It is a template that was written prior to 2005.

This is part of the code concerning the connection

Public drive As New ADODB.Connection
Public cmd As New ADODB.Command
Public DOTainCntFlag As String

in addition:

Public Sub GetLPMain()
On Error GoTo Err_GetLDriving
Dim sqlstring As String
Dim lpmrs As New ADODB.Recordset
'
' Connects to database and gets Driversrecord
'

Customer_num = [custNumber]

' Set ADO connection
drive.Open "DSN=myserver-new-year\Drivers;uid=workers;pwd=checking;database=Driving"
Set cmd.ActiveConnection = drive

I'm getting the following error.  I've googled it and still the same

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
0
I went to run a SQL script today that I have run for years and received this message.
Database ID 11, page (1:10932), slot 0, link number 1028 is invalid. Run DBCC CHECKTABLE.

I have run  DBCC CHECKTABLE on the 5 tables involved in the script and none come back reporting any issues.
I also ran DBCC CHECKDB(database) and that returned nothing either.

Any other DBCC UTILITIES or parameters i can run to find the problem?
0
I have an application in VB.Net using a connection via ADODB.connection.  We are in the process of moving our "stuff to the cloud".  The new server is Server 2016 and the database is SQL Server 2008 Express.  I have enabled the protocols in SQL Server for Named Pipes, TCPIP.  It appears that I have the Server/Database/User/Pwd info correct, but the connection object is not supported?

The connection string is similar to this:
"Driver={SQL Server};Server=SQL1\SQLEXPRESS;Database=Orders;UID=sa;pwd=Adg991!; providerName=System.Data.SqlClient"

Thanks for you help!
0
I have been following several sources to set up an Oracle DBlink to select from a SQL Server database.

Oracle Version is 12.1.0.2.0 Standard Edition in Windows 2012 Datacenter R2 64-bit

SQL Server version is:  SQL Server 2016 (SP2-GDR) (KB4505220) - 13.0.5101.9 (X64)   Jun 15 2019 23:15:58   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 <X64>

The ODBC set up Tests successfully.  I've named it "mysqlServer"

My Oracle Server's name is:  MyOraServer

Here's what I've done:

Step 1:  Added the following entries in the %Grid_Home%\network\admin\listener.ora

SID_LIST_LISTENER=
  (SID_LIST=
      (SID_DESC=
         (SID_NAME=mySqlServer)  <-- the name of the ODBC connection
         (ORACLE_HOME = D:\app\oracle\product\12.1.0\dbhome_1)
         (PROGRAM=hsodbc)
       )
      )


Step 2:  Created an init file in the %ORACLE_DBHOME%\hs\admin folder called "inithsMySqlServer.ora" with the following content:

HS_FDS_CONNECT_INFO = mySqlServer    <-- the name of the ODBC connection
HS_FDS_TRACE_LEVEL = off



Step 3:   Made the following entry in the %ORACLE_DBHOME%\network\admin\tnsnames.ora file:

SQLServerDB  =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=MyOraServer)(PORT=1521))
    (CONNECT_DATA=(SID=mySqlServer))  <-- the name of the ODBC connection
    (HS=OK)
  )


Step 4:  Created a DBLink in Oracle:

CREATE PUBLIC DATABASE LINK SQLServerDB CONNECT TO "myusername" …
0
We have a piece of third party software that was recently updated, including updates to the SQL database.  We also have a Crystal Report that makes a call to a stored procedure in this DB and now the report fails because something with the sproc has changed and I don't know what.  

To start with, here is the piece of code that execs in the Crystal Report:

DECLARE @SDATE DATETIME = NULL
DECLARE @EDATE DATETIME = NULL
SET @SDATE = dateadd(day, -(datepart(dw, getdate()) + 7), CONVERT(date,getdate()))
SET @EDATE = dateadd(day, -(datepart(dw, getdate()) + 1), CONVERT(date,getdate()))

exec software.dbo.sp_test @StartDate = @SDATE, 
	@EndDate = @EDATE, 
	@LocationCSVList='398EMD5F-B4D0-4AD7-88D8-4RTC721875C9,DE50439F-42CA-4158-BB94-8D172F442D89,B669534F-C021-4D2B-8F0F-E54842C94D27,B40AE910-BD62-40CC-99A3-F065MM8C80B3'

Open in new window


When this executes against the sproc now, we receive an error that it's unable to convert the varchar value to data type int.

Here is the sproc as it stands now:

USE [software]
GO

DECLARE @RC int
DECLARE @StartDate datetime
DECLARE @EndDate datetime
DECLARE @LocationCSVList varchar(1000)

-- TODO: Set parameter values here.

EXECUTE @RC = [dbo].[sp_test] 
   @StartDate
  ,@EndDate
  ,@LocationCSVList
GO

Open in new window


I can't change the code for a sproc in a third party app DB, so how do I change the code I'm using in Crystal to still get the results I need and convert that data type?
0
Hi Team,

I need to below information in MYSQL database , Iam new to this . I know how to drop an constraint in oracle and the data dictionary views , but  I need to know the commands
1. Drop check constraint , primary key constraint , NOT NULL , foreign key constraint in  MYSQL
2. data dictioanry view to get the constraints defined on a table .
0
I'm creating a table in Laravel. I created both my Model and my Migration using:

php artisan make:model Video -m

That resulted in a new Migration file called, "2020_02_13_023156_create_videos_table.php" which looks like this:

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateVideosTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('videos', function (Blueprint $table) {
            $table->bigIncrements('id');
			$table->string('title');
			$table->binary('code');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('videos');
    }
}

Open in new window


Perfect!

Now, I want to add that table to the database, so I run this:

$ php artisan migrate --path=database/migrations/2020_02_13_023156_create_videos_table

...and I get an error that says, "Nothing to migrate."

So, I'm looking at what appears to be a sound approach, but there's no "videos" table in the databsae.

What am I missing?
0
Hi,

I have a small method that pulls the largest number out of a Column that is in a table.  It then displays it in a couple of text boxes.

The code works good, but in testing I want a decimal number (xx.x) but only getting an integer right now.

Here is the complete Method:


using (MySqlCommand cmd = new MySqlCommand("SELECT MAX(TDNumber) FROM bbb.traveldocuments", con1))
            {

                con1.Open();

                object result = cmd.ExecuteScalar();
                result = (result == DBNull.Value) ? null : result;
                decimal blah = Convert.ToDecimal(result);
                MessageBox.Show(blah.ToString());   // something to show me what the value of blah is at this point
                txtBox_TD_MAX_NUMBER.Text = blah.ToString();
               
                con1.Close();

                decimal newtd = blah + 1;
                txtBox_TD_nextTDNumber.Text = newtd.ToString();


            }

It's a little complex since my original code was crashing if the value was null (empty database).  Now I get a zero, which isn't bad, just wondering if it's because my Database is empty and the 0 is actually a null?

The format of the Column is 10.1 decimal unsigned.

Thanks!

G
0
Hello,
We have recently upgraded to php 7.4 for our intranet on windows 10 and we are getting a database not found error. All the files for the database are there and should be in working order. Everything worked fine on 7.3 with Windows 7.The log files do not give any hints as to why the database isn't being found. Does anyone know of anything that would have changed between versions?

Thanks
0
I am using an access database to handle scanning orders into folders as a PDF.  

The scan function works great.  It drops the image into a local file as a jpg, no problem.  
I open the jpg(s) in a report, which works.
I close the report, using acSaveYes, and this seems to be working correctly.
Where I run into issues (at least on the AccessRuntime side of things) is in this line

DoCmd.OutputTo acOutputReport, "rptScan", acFormatPDF, "C:\TempScan\Report.pdf"

In the Runtime environment, I frequently get a 2046 error, and it stops.

If we rerun the process (sometimes multiple times) it goes through with the exact same results.

I added in a statement to try to get around this, by having it loop back to the portion of the code above in the Handle_err

    Select Case Err.Number
        Case 2046
            GoTo StartPDFConversion:  {the line above}
    End Select

Rather than loop, its still coming up with the 2046 error.    

I am using RT2013 as I was seeing too many bugs with RT2016.  

Is there a better way to force a retry of the PDF outputting code so that it just retries again?

Any help would be greatly appreciated.

Jeff
0
I'm looking at database monitoring and seeing that nearly all of our SQL databases report a high degree of fragmentation in their indexes. 99.8-99.9% fragmented is not uncommon. Can this play significantly into poorer performance for database interactions from .NET web servers which integrate with SQL?
0

Databases

58K

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.