Go Premium for a chance to win a PS4. Enter to Win

x

Databases

55K

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

Hi All

I apologise now for the naïve question which probably has immediate flaws.

There are many databases at work and I am partially IT technical but approaching this from an end user point of view.

We currently use Qlikview to output data to dashboards which to me are essentially web pages secured down for internal access only access via the Intranet.

However, it turns out that most applications like Qlikview although specifically designed for this job and I assume good to use for development cost a lot of money.  Are there not alternatives around that are cheaper?  

Surely if someone has more knowledge can't they build a database lookup via a WordPress or other website technology frontend and then integrate with AD to control the access?

This is a very open question I know but any responses will be appreciated.
0
Free Tool: Port Scanner
LVL 11
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hello
Could someone please help me to read and edit the text file through DB2 stored procedure
0
I would like to know what is the best online email campaign tool today?  I know the question is vague and subjective, but i would like to have the opinion of E-E Techs based on what we need:

  • We have a private database where we can extract emails/names/etc and produce an Excel or CSV file from it
  • We would like to manage groups from this campaign tool (Newsletters, VIP, Security Updates, etc)
  • We need to update this online tool database regularly, and it should preserve the groups already assigned to people
  • Each database update should list new entries so we don't have to go thru the whole list to know which entry is new
  • Emails should be sent thru our Gmail businness account, so possibly have the possibility to set a maximum of emails to send per day

Of course, it has to manage unsubscribe status and other usual stuff.

Thanks for the information, your opinion count!
0
Hi Guys,
We are using SAP Version 9.2 PL7
we have setup transactional replication in MSsql 2016 server & works well.
but when we upload all existing crystal reports (After Modified), SAP Rollback the Crystal Report Upload. but it is possible to upload new reports. please see attached error image.
any ideas are greatly welcomed.

thanks.
Untitled.png
0
I have a client that does not want to embed a password in their data source. Instead, they'd like me to popup an input box asking for the password at run-time. My VB.Net based software works with a variety of data sources so I was wondering if there's a standard way of asking the odbc /oledb system to prompt the user for the password if a password is not specified in the configured data source.

Thanks.
0
dear team,
I am using office 2016.
i have developed a database using office 2016.
after deploying my end users (uses office 2013 ) facing issues with application.
1. on opening database . It is popup with  " searching for referenced file EXCEL.exe ".
2. HERE IS THE CODE FOR YOUR REFERENCE.
********************************************************************************************************************************
Option Compare Database
Private Sub cmdchemicalsearchexport_Click()
 Dim saveloc As String, strWorksheetPath As String, xl As Object, wb As Object
    Dim exportsheet As Object, Header As Variant, OIHeader As Variant
    'Dim db As DAO.Database, ExportRecordSet As DAO.Recordset
Dim db As Database
Set db = CurrentDb
Dim rs As Recordset
    saveloc = Environ("USERPROFILE") & "\Desktop\"
    saveloc = strWorksheetPath & "ChemicalSearchReport.xlsx"
    Set xl = CreateObject("Excel.Application")
    Set wb = xl.Workbooks.Add
    Set exportsheet = wb.Worksheets(1)
    exportsheet.Name = "Chemical Search"
    xl.Application.Visible = True
   Set rs = db.OpenRecordset(Me.RecordSource)
        exportsheet.Cells(1, 1).Value = "Trade Name"
        exportsheet.Cells(2, 1).Value = "Supplier"
        exportsheet.Cells(3, 1).Value = "Category"
        exportsheet.Cells(4, 1).Value = "Physical Appearance"
        exportsheet.Cells(5, 1).Value = "Active Ingredient"
        exportsheet.Cells(6, 1).Value = "Regional Availability"
        …
0
Private Sub cmdchemicalsearchexport_Click()
   
    Dim x1 As Excel.Application
    Set x1 = New Excel.Application
    x1worksheetpath = "D:\test\"
    x1worksheetpath = x1worksheetpath & "ReportChemicalSearch.xlsx"
   
    x1.Visible = True
    x1.workbooks.Open ("D:\ReportChemicalSearch.xlsx")
    x1.sheets("sheet1").Select
    Dim db As Database
    Set db = CurrentDb
    Dim rs As Recordset
   Set rs = db.OpenRecordset(Me.RecordSource)

   

        x1.sheets("sheet1").Cells(1, 1).Value = "Trade Name"
        x1.sheets("sheet1").Cells(2, 1).Value = "Supplier"
        x1.sheets("sheet1").Cells(3, 1).Value = "Category"
        x1.sheets("sheet1").Cells(4, 1).Value = "Physical Appearance"
        x1.sheets("sheet1").Cells(5, 1).Value = "Active Ingredient"
        x1.sheets("sheet1").Cells(6, 1).Value = "Regional Availability"
        x1.sheets("sheet1").Cells(7, 1).Value = "EPA#"
        x1.sheets("sheet1").Cells(8, 1).Value = "Comment"
        x1.sheets("sheet1").Range("A1:A8").Font.Bold = True
       

    Dim rownum As Long, colnum As Long
    Dim i As Long
    i = 0
    rownum = 1
    colnum = 2
    rs.MoveFirst

    For Index = 1 To rs.Fields.Count
    If rs.Fields(i).Name <> "SDS" And rs.Fields(i).Name <> "CID" Then
        Do While Not rs.EOF
        x1.sheets("sheet1").Cells(rownum, colnum).Value = rs.Fields(i).Value
        rs.MoveNext
        colnum = colnum + 1
   
   
   
        Loop
        rownum = rownum + 1
0
  <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#333333"  CellPadding="3" ForeColor="Black" GridLines="Vertical" OnRowCreated="GridView1_RowCreated" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">

<asp:TemplateField HeaderText="Attach Invitee list">
    <ItemTemplate>
                        <asp:LinkButton ID="lnkbtnViewExcelSheet" runat="server" 
                             HeaderText="Attach Invitee list" SortExpression="Attach Invitee list" Text="View" OnClick="lnkbtnViewExcelSheet_Click">
                        </asp:LinkButton>
                    
</ItemTemplate>
</asp:TemplateField>
             <asp:HyperLinkField HeaderText="Attach Company Logo" Text="View" Target="_blank" />

 </asp:GridView>

      <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:constring %>" SelectCommand="Select Exhibitor_Details.Acount_Long_Name as [Company name], Exhibitor_Details.Stand_no as [Stand no], Exhibitor_Details.Hall as [Hall], Exhibitor_Details.Stan_Sub_Allocation_Name as [Sub Allocation], Exhibitor_Details.First_Name as [Contact name], Exhibitor_Details.PO_BOX as [Address1], Exhibitor_Details.Street as [Address2], Exhibitor_Details.Other_Address as [Address3], Exhibitor_Details.Country as [Country], Exhibitor_Details.Post_code as [Postcode], Exhibitor_Details.Tel as [Telephone], Exhibitor_Details.Fax as [Fax no], Exhibitor_Details.Mobile as [Mobile], Exhibitor_Details.Email as [Email], 

Open in new window

0
Hi I have a database that's been working fine in Access 2013 but since the upgrade to Access 2016 I am getting an error in the VBA code that exports to excel.

The error is:
Unexpected error occurred: Type mismatch - Number: 13

Below is a snippet of the VBA code, I trapped the error to the specific line noted:

Sub MonthlyReport(xlWs As Excel.Worksheet, xlRng As Excel.Range)

    Dim db As DAO.Database
    Dim iRow As Integer
   
    Set db = Access.CurrentDb()
   
    iRow = 1
   
    Set xlRng = xlWs.Cells(iRow, 1) '**THIS LINE CAUSES THE ERROR
    With xlRng
        .Value = "Supplier"
        .Font.Bold = True
        .Font.Color = vbBlack
        .Font.Size = 10
        .Font.Underline = True
    End With


Can anybody explain why this is happening.
Thanks
0
Hi,
I want to insert custom columns which is not available under csv using control file.

how to pass that custom values to control file and insert into database when control file triggers with csv data.

we have 10 columns in table but csv have only 8 columns rest of the two columns are created based on the file(csv) data or name of csv.

Please guide me.
Thanks,
0
Free Tool: SSL Checker
LVL 11
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Recently my search function stopped working on my Share Point 2013 environment further how to fix this issue please find following error message.

error
The administration component for application Search Service Application failed with exception System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Search_Service_Application_DB_3831518a2de44da4b704d12b184bac35" requested by the login. The login failed.
Login failed for user 'xxx\SharePortalAdmin'.
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at …
0
I have 2 subforms on a Main form.  subFormX and subFormY.  they both share the same QuestionID number.

So I want to be able to click on the subFormX QuestionID texbox then --- it moves the focus to the record in subFormY that shares the same QuestionID.

Any suggestion on the best way to do this?  I played around with docmd.findrecord but had not luck.

Thanks for your help.
0
I currently have a Module that does this perfectly:

Option Compare Database
Private Sub Command424_Click()
Command424.HyperlinkAddress = "https://google.com/"
End Sub

I'm not schooled with Modules/VBA code hardly at all, so if you can... school me up! :D

My Form name is "Grab_Data"
Field Name I'd like to copy is "WebSearchTXT"
And it'd be a bonus if it would first Filter By Selection on the field "ITEMNO", open the web browser and paste the copied info!

It would be for just the current record or one record at a time that has the focus that I'd be working on (if that helps anything?)

Thanks!  Kevin
0
I'm trying to do something super simple...or seems it should be. I have a script that truncates and updates a table...it creates unique combinations across three other tables for a dimension build. I was hoping to create a function/procedure that I could call from an application in a single line, rather than trying to store the sql in my application.

We are using postgresql and sqlworkbench/j. My code to create the table includes a view creation, distinct, union, and in insert into using select.

I was trying:

    CREATE OR REPLACE FUNCTION update_table()
    RETURNS void AS $$
    BEGIN
      CREATE OR REPLACE VIEW ...

     ...;
    END;
    $$ LANGUAGE plpgsql
    IMMUTABLE;

I get the error that "Create Function is not supported".

I'm admittedly a sql rookie and everything I have tried has failed, giving me one error after another. Is there a simpler way to do this? Nothing changes in my create statement...no parameters passed in, nada. It's simply that the underlying transactional data is changing and we're only keeping valid combos, so we trunc and reload the table.

Thanks in advance!
0
I have a pagination that load more when I click on the load more button, which I got from the below URL http://makitweb.com/load-more-results-with-jqueryajax-and-php/

Whenever I add RAND() it always duplicates the value.

index.php

<?php

$rowperpage = 10;

$allcount_query = "SELECT count(*) as allcount FROM users order by id";
$allcount_result = mysql_query($allcount_query);
$allcount_fetch = mysql_fetch_array($allcount_result);
 $allcount = $allcount_fetch['allcount'];

$query = "select * from users order by RAND(" . date("Ymd") . ") asc limit 0,$rowperpage ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
?>

<div><h1><?php echo $row['id']; ?></div>

<?php
}
?>

<h1 class="load-more">Load More</h1>
<input type="hidden" id="row" value="0">
<input type="hidden" id="all" value="<?php echo $allcount; ?>">

Open in new window


getData.php

<?php
$row = $_POST['row'];
$rowperpage = 10;


$query = 'SELECT * FROM users ORDER BY id limit '.$row.','.$rowperpage;
$result = mysql_query($query);

$html = '';
while($row = mysql_fetch_array($result)){

$html .= '<div><h1>'.$id.'</h1></div>';

}
?>

Open in new window

0
This seemed to me a very easy thing to do at the beginning, but it got complicated and very challenging. I am pretty new to MS Access, so -after struggling for many days- I hope to find the solution here.

Say we have a simple table like this:

Student Table
Now, I need to track changes on this table on the record level and Log the changes in another table (Say Log table) like this:

Track/Log Table
Where track_type:

1 for add(insert)
2 for edit(update)
3 for delete

The changes(add/edit/delete) should be logged when the record on the Student Form is changed.

My Problem is that I am not able to generate the changes correctly.

My form has to refresh a lot which make excessive entries in the log table like this one:


bad logging example
As you can see, instead of one log for the insert, it takes two logs to insert a record.

I searched the net thoroughly, but I cannot find this kind of logging. I found information about logging on the field level, but this is not what I want. I know it may be better in most cases, but not for my case.

So, I will appreciate any guiding information/code.

a minimized database that focuses on the problem is posted Here and you can download it and see what I have tried and where I am stuck.

Notes:

1- Changes should be logged only when the user: - Move from the current record on the form. - Exit …
0
Thanks to Rick_2CA - https://gallery.technet.microsoft.com/office/Mailbox-Pre-Archive-347f9162/view/Discussions

I have been able to Modify this script to include: TotalDeleteditemSize and TotalDeleteditemCount

This outputs the below and works exactly how I want:

ItemsCount      
ArchiveItemsCount      
ItemsSizeBytes      
ArchiveItemsSizeBytes      
TotalDeletedItemSize            
DeletedItemCount


The part I am having trouble with, and where I would like a push in the right direction is how to obtain the ArchiveTotalDeleteditemSize & ArchiveTotalDeleteditemCount (The count and size of data that CAN be archived, same as what is output from "ArchiveItemsSizeBytes")

Below is the script, that I have manipulated to include the

TotalDeleteditemSize & TotalDeleteditemCount......

I have attempted to match what was already in the script, by copying the code, and changing the values (Via Powershell ISE), However, I just end up with nothing being returned or getting the identical results as the ArchiveItemsizebytes

Essentially I am after the Archivable size & Count for recoverable deleted items

Any assistance would be greatly appreciated!!!

If I have worded anything wrongly, or something does not make sense, please let me know, and I will be happy to clarify...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


# Exchange 2010 Mailbox PreArchive Statistics
# Purpose:  Query mailboxes for mail older than X days in order …
0
Hi everyone!
I've encountered a problem of combining different databases together in a single query. I'm searching for the way to get a desired result, but no success so far..". Possibly someone could point me to a right solution.

Description:
  1. There are 2 databases (DB): DB1 - Visual FoxPro database and DB2 - MS Access database
  2. Quering databases is organized with ADO
  3. In DB1 I have all the necessary information except a list of sold items. Sold Items list is located in DB2
  4. I need to query DB1 and list all the models, which have not been sold yet
  5. All the queries must be performed from inside Excel and returned to excel as well

A sample of simplified SQL query:
[VEHICLES] - Table from DB1 (Visual FoxPro)
[SOLD] - Table from DB2 (MS Access)
"	SELECT [VEHICLES].VEH_MODELS FROM [VEHICLES] " & _
"	LEFT JOIN [SOLD].VEH_MODELS FROM [SOLD] " & _
"		ON [SOLD].CODE=[VEHICLES].CODE " & _
"	WHERE [SOLD].VEH_MODELS IS NULL"

Open in new window

Problem: How can I make ADO understand which table is in each DB?

Initially ADODB Connection.string is set to use Visual FoxPro driver and DB1 location
(Example: ADOcon.ConnectionString="Provider=vfpoledb;Data Source=" & DB_Path & ";Collating Sequence=machine;")

Possibly anyone has faced such problems previously and could suggest smth?
P.S. Please don't ask why data is in separate databases =))
0
Hi,

Is there any way in SQL Server to know which SQL Select statements are not using indexes and running full table scans?

I am asking as I want to know which reports needs creation of new indexes .
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.

I have been working on a SQL routine that pulls POs from a legacy application and inserts them into a modern ERP solution. In our data center the process pulls in all 20,000 POs in less than 20 minutes. We just tried to deploy this routine in the customer's environment and the process took over 10 hours. This routine deals with about 10 tables in two databases that are housed in the same instance of MS-SQL 2012. What tools can I run on both ends to identify what is causing the bottleneck on their system?
0
Hi,

I am trying to import these Apache logs into an SQL Database but am unable to do so.

When I run the code below I get the following Error:

Msg 4860, Level 16, State 1, Line 4
Cannot bulk load. The file "C:\LOGS\access.2017.11.16.log" does not exist or you don't have file access rights.

Can I I Import all Files without checking for a date? 


(1 row affected)

Open in new window

     
/*****This is the share location of the log file in a variable*****/
DECLARE @FileLocation varchar(max)
SET @FileLocation = 'C:\LOGS\'

/*****This is the name of the start the file name in a variable********/
DECLARE @FileName varchar(max)
SET @FileName = 'access.'

/********This is the extention of the log file in a variable*******/
DECLARE @FileEXT varchar(4)
SET @FileEXT = '.log'

/*************This gets todays date in a variable*************/
Declare @date varchar(max)
set @date = (SELECT convert(varchar, getdate()-4, 102))

/********This puts all of the file share and info in one variable name************/
DECLARE @FilePath varchar(max)
Set @FilePath = @FileLocation + @FileName + @Date + @FileEXT

/*********** This is the SQL to insert and its written into a variable and executed************/
DECLARE @SQL nvarchar(max)

SET @SQL = N' use Downloads 
		   BULK 
		   INSERT BulkInsert 
		   FROM "' + @FilePath + 
		   '" WITH 
		   ( 
		   FIELDTERMINATOR = '','', 
		   ROWTERMINATOR = ''\n'')'
EXEC  sp_executesql @SQL


END

Open in new window

0
The solution that Will gave me to auto start our Leads database so that employees won't have to do a File:OpenRemote, takes a long time after we upgraded from FM15 to 16.  I even recreated the database and created the table, fields, layout, and script from scratch and didn't save time.  The problem is that it takes so long to open (15 seconds?) that people click again and that hangs up FM.  It then never opens.
Start-FMNew.JPG
Start_Script.JPG
0
I have a database server that is about 4 years old.  we have a bunch of users that point their applications to this server.

the name of the server is    Alpha

We want to upgrade the sql server version from 2012 to 2016.   I think i would like to create a new server and do a clean install of sql server instead of doing an in-place upgrade.

So the new server would be bravo......  (if we do not do an in-place upgrade)
isn't it true that if i get the permissions right on bravo and restore all the databases on bravo.  that i could thereotically change the name of Alpha to lets say Alpha1 and then rename Bravo to Alpha that the users would not need any configuration changes.

Can someone please verify or send me to a document that outlines the best way to do this.
0
Hi All,
I am building an API in PHP which will take an email address and then turn it into a hash and then store that in a database.

However, the email address is called by other peoples servers using an API. Whats the best way too securely transfer the email address?

Sufficient to have the api use SSL?
0
I am looking for a script (PowerShell or JS) that will create multiple Calendar overlays for a SharePoint online Calendar. I found some for SharePoint 2013, but it does not work for SharePoint online. When creating a SharePoint site template, Calendar Overlays are stripped. Unless anyone can think of another way of automatically creating them, Scripting seems the way to go.

Any help will be great. Thank you.
0

Databases

55K

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.