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 having the issue migrate one of the website from dreamhost to Cpanel .In the xxxx_Options SQL database I unable to see the content because to let in work I have to change the path for public_html.I am able to search public_html and one match but can not read .I has migrate from CPanel to Cpanel befire there is no problem.Please advice.
old.PNG
new.PNG
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hello,

I've been playing around with the Always_on technology in SQL Server 2014 Enterprise.  I've got a production database and I've created a secondary database using this technology to use as a "Real Time" reporting database.  I've got the databases setup using Always_on and I am using Crystal Reports XI to try to connect to the "Synchronized" database but I am unable to connect.  In fact when I try to create an ADO connection to the database I put in the "sa" user and password and the database doesn't even show up in the database dropdown.  I've got the secondary database set to "Readable"

Any help would be greatly appreciated.
0
Installed my first Server with SSD's today.  The HP 400GB SSD's (In as RAID1 to save on costs) are for hosting a Database.

As you can imagine, its like lightening!
1
Hello,
I would like to delete a Table from a database.

Name of the Table = "customer"
Name of the Database = "Sicherung_Thomas"
SQL Server 2000

I tried this:

CString str_Tablelle;
str_Tabelle="customer.dbo.Sicherung_Thomas";
 
//-----------------------------------------------------------
sql.Format("DROP TABLE %s ",str_Tabelle);
//-----------------------------------------------------------

My Error Message is: deleting is not possible because table do not exist in  system catalog

But the table is there....what do I did wrong?
Please help.
Best regards,
Thomas
0
How to design a Hierarchy based Table Relation?


To give an example: Organizational Chart. I am actually working on a Product based database.  Lacking in the design.
0
How to design a Hierarchy based Table Relation?


To give an example: Organizational Chart. I am actually working on a Product based database.  Lacking in the design.
0
 
LVL 11

Administrative Comment

by:Andrew Leniart
Hi chokka,

What you have done is made a "Post" here. To get help from the experts, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
Hi,

I have an issue I would like someone to help me to solve it.

I was searching how can I protect my Access Database file not to be used on another PC, so I find a way to create a dummy file and to call this file the first thing in my welcome form page.

I did face 2 errors after running it attached are the screenshots for both of them.

And the VBA code you can see it below:

Application.FollowHyperlink "C:\Windows\System32\startcheck.dll"

For the Security notice I did try many solutions to turn it off, but non of them did work.

And for the run time error I have no idea from where most probably from the VBA code.

Thanks for your help,
security-notice.png
run-time-error.png
0
I have an MS SQL database that I created using Microsoft SQL Server Management Studio 17. I went ahead and uploaded it to my webhost provider and even made an aspx.net bv.net page to read back one of the tables just to be sure I had the right connection to the database. All that works but now to save me coding time I wanted to create a GridView to display, delete and update specific records to the database.

I start the process of dragging a GridView to the aspx page in Microsoft Visual Studio 2017 then it asks for me to choose a datasource so I choose SQL and the data source defaults to SqlDataSource1 which I modify to be SqlDataSource2018 because I already have another 7 year old database that uses the name SqlDataSource1

The next step is to to specify the Data Connection which is available to me on the drop down menu.
This then makes the "Next" button at the bottom of the dialog box be available for clicking.

This where I run into a brick wall with the same message everytime.
I've embedded an image that displays the error message and I've also attached the file in case you cant see the embedded file (im new at this...)
error message
From what I can decipher the computer I think is stuck in trying to find the database locally within my computer but it needs to go to the database server's i.p. address!
Any suggestions to get me and my computer out of this rut?
Thank you for your help!
0
hi everyone,

  here we have an  Delphi application, it's functionality is to receive data from Ethernet and  to store received data in database(Interbase DB) . to store or retrieve data in Interbase DB(Local DB) we are using BDE components. and here we are posting that data to Azure cloud using ADO components. when ever we deployed our application into client system it is working well for sometimes 3hr and sometimes 4hr and sometimes even 24 hr also it is working well but after that we are getting the above exception and exe getting hanged and forcibly stopped. I have searched about above exception all over the internet but didn't get an idea what to do. but crazy thing is this application has ran continuously for 4 days continuously whenever we tested it in my system.  I think it is something to do with BDE Components.
   
 forgive me if you are not able to understand my English.
Any suggestions or solutions are helpful.
0
In this blog post, we’ll look at how to deploy ProxySQL.
0
Do you have a plan for Continuity?
LVL 2
Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Hi All

( This isn't a question as much as it's a member poll, and it's more of a process question then a code question, so points will be split across any meaningful answer. )

Does anyone have a process (not necessarily code) for auditing a data warehouse?  Specifically, a process or code that does something like this..
  • Compare total sums/counts in source data to sums/counts in target DW?
  • Compare incremental load (day, hour, etc.) sums/counts in source data to sums/counts in target DW?
  • Compare by table/column blank/NULL values in source data to same in DW?
  • (Kinda dreaming here) Use of DMV's to show metrics of how much the DW tables are used?

I've inherited a DW (really a datamart, but that's another story) that users have suspect for awhile now, and I need to nail down a process to audit this DW to verify that the data accurately reflects the source data, and communicate that in a simple way with a few more details than executive red/yellow/green.   Also I have a selfish interest in being able to communicate my progress in resolving these issues clearly.

I tried Googling it myself, and all the results were either SQL Server auditing or consulting companies advertising DW projects.

Thanks in advance.
Jim
0
ONe of my Exchange 2010  Databases -say named  "SAles"  is 160gb and I moved all mailboxes out from "Sales" to Sales2" database and I ran esseutil /d sales.edb  /p on it I thought it this will significantly reduce Database "sales" size however size did n't change much from 160gb down to 145gb???

can ESEUTIL dramatically reduce DB size ?
0
I am developing an application that needs to connect to an Oracle database. I've added the required Nuget packages to connect to the database. If I have the DBA credentials to a schema, I can connect fine and expand the tables in the schema to add them to my model. However, on another schema I only have permissions to SELECT from a table. So, when I go through the wizard to set up my EF model I can get to the page to select the Tables I want to add to my model. However, I can't get the Tables node to expand in order to select the table that I have SELECT permissions on. The first screenshot show the screen I am stuck on. I Cannot click the check-box or expand the node to show the tables. The second screenshot shows the same behavior in VS2015 Server Explorer in that the node under 'Tables' can't be expanded to show that table I have select access to.

As I said before, there are other schemas where I have DBA privileges and these work fine (I can expand all the nodes) . Surely we are not restricted to users with DBA privileges when  using EF?

Any help, much appreciated
Thanks
C--Users-Thampi_m-Desktop-efo1.PNG
C--Users-Thampi_m-Desktop-efo2.PNG
0
Hi EE,

I would like to transfer all data from a prod instance DB to a UAT instance DB. However, I would like to omit tables between the two DB where the schemas are different. Is there a way to do this via the GUI if not what would be the command to check the compare the schemas before transfer?

I am using SQL server 2012.

Any assistance is appreciated.

Thank you.
0
Hello,

I want to add a csv file to database. There is a column in csv file called as merchant_id same as column in SQL database. I want to update the row in database if the "merchantid" exists in database or if it doesn't exist , we need to add that row from csv file .


Here  

"rs" contains all the columns of the CSV file and its values.

"rsAdd" contains all the columns of Database table(Merchants) and its values.

Set rs = GetRecordSet("C:\upload\new\" & TheNewFileName2)
    'Response.Write "No Errors"
    Set cn = Server.CreateObject("ADODB.Connection")
    cn.ConnectionString="DSN=REWC"
    cn.Open
    i = 0
		TheSql = "SELECT * FROM Merchants"
        Set rsAdd = Server.CreateObject("ADODB.RecordSet")
        rsAdd.CursorType=1
        rsAdd.LockType=3
        rsAdd.Open TheSql, cn
        
    While not rs.EOF
				
			rsAdd.AddNew            
            For Each col in rs.Fields				
                rsAdd(Replace(col.Name,"_","")) = col.Value
            Next		
			
        rsAdd.Update
        rsAdd.Move 0        
        rs.MoveNext
        i = i + 1
        If (i mod 100)=0 Or i=1 Then
            Response.Write i & ","
            If (i mod 2500) = 0 Then
                Response.Write "<br />"
            End If
        End If
    WEND
	
    rsAdd.Close
    Set rsAdd = Nothing	
	End If

Open in new window

0
so its a basicaly a complaint form ,if the complaint is solved it should remove the row automatically from datagridview
0
Struggling a bit with a query. Here's the details:

Table1

ID, StartDate, EndDate, Approval (Bool/bit), Hours (Decimal 5/2), FiscalYear, EMPLID


Table2

ID, EmployeeCode, FirstName, LastName, Mgr



I need to display T2.FisrtName, T2.LastName, T2.Mgr, T1.StartDate, T1.EndDate, T1.FiscalYear, And the sum of T1.Hours
WHERE T1.EMPLID = T2.EmployeeCode

So basically I'm looking to display 1 record for each record in T2 while displaying the sum of T1.Hours for each correlating T1.EMPLID/T2.EmployeeCode record(s)


Result might look something like:


Peter     Griffin     Glenn Quagmire     1/1/2000     1/6/2000     1999     84.5



How would I do this?
0
Hi
I have a simple database that contains a couple of tables, queries. macros and modules etc.. I'm trying to make it more users friendly, so I have designed a form that loads up and will give the user the option to select an option button then the macro will run and create the report. However what I want the form  to do is to remember the last option button that was selected when the form re-opens.

Thanks
0
I just installed ElasticSearch, MongoDB, GrayLog2 but getting an error and unable to access the web interface. Please, suggest any solution r

/etc/elasticsearch
# ls -lrtha
drwxr-x---.  2 root elasticsearch    6 Apr 24 16:29 scripts
-rwxr-x---.  1 root elasticsearch 2.6K Apr 24 16:04 logging.yml
-rwxr-x---.  1 root elasticsearch 3.2K Jul 20 05:05 elasticsearch.yml


/var/log/graylog-server/server.log

2017-07-20T07:50:36.694Z INFO  [CmdLineTool] Loaded plugin: Elastic Beats Input 2.2.3 [org.graylog.plugins.beats.BeatsInputPlugin]
2017-07-20T07:50:36.696Z INFO  [CmdLineTool] Loaded plugin: Collector 2.2.3 [org.graylog.plugins.collector.CollectorPlugin]
2017-07-20T07:50:36.699Z INFO  [CmdLineTool] Loaded plugin: Enterprise Integration Plugin 2.2.3 [org.graylog.plugins.enterprise_integration.EnterpriseIntegrationPlugin]
2017-07-20T07:50:36.700Z INFO  [CmdLineTool] Loaded plugin: MapWidgetPlugin 2.2.3 [org.graylog.plugins.map.MapWidgetPlugin]
2017-07-20T07:50:36.708Z INFO  [CmdLineTool] Loaded plugin: Pipeline Processor Plugin 2.2.3 [org.graylog.plugins.pipelineprocessor.ProcessorPlugin]
2017-07-20T07:50:36.709Z INFO  [CmdLineTool] Loaded plugin: Anonymous Usage Statistics 2.2.3 [org.graylog.plugins.usagestatistics.UsageStatsPlugin]
2017-07-20T07:50:36.813Z ERROR [CmdLineTool] Invalid configuration
com.github.joschi.jadconfig.ValidationException: Cannot read file elasticsearch_config_file at path /etc/elasticsearch/elasticsearch.yml. Please specify the correct …
0
Get your Conversational Ransomware Defense e‑book
LVL 1
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Hi guys,

Recently came upon the requirement for DATA Center for which I don't have any knowledge.I am in R&S, IP Telephony, Structured Cabling
Can anyone tell how I can get trained in Data center design?
what is the best way to get trained in data center designing, and what are the training courses offered by CISCO, HP, DELL.
0
I  have developed free radius management system locally.
but now in my job they asked me to make this system to be selling in a cloud
ie. every user around the world can access our management system from the cloud
he must register a new account in our system and determine his database
that means every user has a different database with same free radius server
my first problem is when a new user had registered to our system his database information will go in SQL.conf file but as we know that free radius does not take his new configuration till restart so I must restart free radius for every new user and interrupt the others work.
the other question is when there are many users with their database for example if I have 100 users and for every user, there is one database that means free radius must connect to 100 different databases  is this will make free radius working slowly or not
I hope I explained my problem clearly
0
Db: Oracle 11g

We have an etl job run via a third party scheduler that connects to oracle database via db link and fetches the data into a file.

The query is as follows:

select
<bunch of colums>
from
user.view_object@remotedb

This fails on the first run with the following error:

Error code: 8103, Error message: ORA-08103: object no longer exists.

On the re-run it runs just fine.

The object always exists on the remote database. Cannot understand why it fails on the first run?

Any thoughts? Please let me know if you need more information
0
Hi,

I am Rupesh & I am new to this forum.

I am trying to build a tool in excel which can update database maintained in access.

There will be 3 to 4 user for this excel tool which will be connected to one access database.

The excel will act as the front end tool & access as a backend tool.

I want excel VBA to perform 3 things:

1. It will update data in access based on 2 column which will act as a unique code.
2. It will add any new row if the data doesnt match with previous unique code.
3. If the user wants to delete perticular row / range then it will be deleted from database also.

Below sample of table:

Country      Product code      Sub-Brand      Mfg Base
Russia      SRU030008869020137      Syrups      Own
Russia      SRU030008869020141      Syrups      Own
Russia      SRU030008564220158      Tablets      Own
Russia      SRU030008564220258      Tablets      Own
Russia      SRU030008564220558      Tablets      Own
USA      SRU030008869020137      Syrups      Own
USA      SRU030008869020141      Syrups      Own
USA      SRU030008564220158      Tablets      Own
USA      SRU030008564220258      Tablets      Own
USA      SRU030008564220558      Tablets      Own

1st two column will act as a unique key.

We cannot use a replacement code since there will be multiple user working on different region, replacement option can change  or erase others database.

Thanks for the help in advance.

Regards,

Rupesh.
0
I need help improving the query potentially combining the query without using the UNION. And help improving the query execution

SELECT F.* 
FROM ( 
SELECT T.*,
 case WHEN T.availSeats = 1 THEN (SELECT (CONVERT(int, CONVERT(varchar, T.sessionStart, 112)) - CONVERT(int, CONVERT(varchar, U.dateOfBirth, 112)))/10000 
 FROM users U 
 inner join sessionMap SM2 on SM2.userKey = U.userKey WHERE SM2.sessionKey = T.sessionKey) 
 WHEN T.repost = 1 THEN (SELECT (CONVERT(int, CONVERT(varchar, T.sessionStart, 112)) - CONVERT(int, CONVERT(varchar, U.dateOfBirth, 112)))/10000 
 FROM users U inner join sessionMap SM3 on SM3.userKey = U.userKey 
 WHERE SM3.sessionKey = T.sessionKey and SM3.repost = 1) ELSE 0 END as age 
 FROM ( 
 SELECT S.SessionKey, S.locationKey, S.locationKeyList, S.officeStateKey, SU.sessionStart, SU.sessionEnd, L.name AS locationName, L.address1, L.address2, L.city, L.state, L.zip, I.gender,
  ( SELECT TOP 1 UIL.licenseCd FROM userInstructorLicense UIL WHERE UIL.userKey = I.instructorKey and UIL.expirationdt is not NULL )as badgeNum,
   ( SELECT COUNT(1) FROM sessionMap SM WHERE S.sessionKey = SM.sessionKey ) AS seatCount, S.Seats, 
   IsNull(SU.btwSeatsOverride, S.Seats) - ( SELECT COUNT(1) FROM sessionMap SM WHERE S.sessionKey = SM.sessionKey and sm.userKey <> 0 ) AS availSeats,
    LS.btwScheduleThreshold, LS.availStateCode, ( SELECT top 1 isNull(SM.repost,0)
	 FROM SessionMap SM 
	 WHERE SM.sessionKey = S.sessionKey
	  ORDER BY isNull(SM.repost,0) desc ) as 

Open in new window

0
I have over 45 databases that need the log files backed up. I can go through each database and manually backup the log files or prefer not to if it's an option due to time restraints. Is there a way to run transaction log backups using one command or automate the process for all databases.
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.