Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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,
is there a documented process to do replication with log shipping where the only thing available to the destination database is the log files?  If not I will have to setup an SSIS package to do restores of the log files to the destination database, which seems problematic?

thanks,
john.
0
Microsoft Certification Exam 74-409
LVL 1
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Hi Experts,
I have a hard coded dropdown on my page, but I would like to populate it from a database table instead.
This is my code, and the table name from where I would like to populate it is QueueEnvironment and the two column names are Name, and QueueEnvironmentId. How can I make the option value QueueEnvironmentId correspond to Name in the dropdown?

<select name="Name">
<%
Dim rsName
set rsName=Server.CreateObject("ADODB.recordset")
sql="SELECT distinct(Name) FROM QueueEnvironment order by Name"
Set rsName = AdoCon.Execute(sql)
%>
<option></option>
<%
Do While Not rsName.EOF
Response.Write "<option value=''>"& rsName("Name") &"</option>"
rsName.MoveNext
Loop
Response.Write "</select>"
%>
0
Hello Experts, I would like to set up remote access to our database as remote.xyz.com, have it point to our internal Sesame Database Server at 192.168.X.X, but only allow traffic through port 20030, and only with the db.exe. sesame db server has its own web server and capable to act as web server and has sample builtin html webpage as well, so how can i achieve this ?
Thanks.
0
Hey there, i have files saved on database using this script

     <form method="post" enctype="multipart/form-data" >
     <input type="file" name="myfile"/>
     <button name="btns"> Incarca Schita </button>
     </form>
     <?php
     $dbh = new PDO("mysql:host=localhost;dbname=highmob_comenzi", "highmob", "PW");
     if(isset($_POST['btns'])){
         $name = $_FILES['myfile']['name'];
         $type = $_FILES['myfile']['type'];
         $data = file_get_contents($_FILES['myfile']['tmp_name']);
         $stmt = $dbh->prepare("UPDATE players SET data='$myfile', name='$name', mime='$type' WHERE id='$id'");
         $stmt->bindParam(1,$name);
         $stmt->bindParam(2,$type);
         $stmt->bindParam(3,$data);
	     $stmt->execute();
     }
     ?>
  <?php
$stat = $dbh->prepare("select * from players where id='$id'");
$stat->execute();
while($row = $stat->fetch()){
	echo "<a href='viewschita.php?id=".$row['id']."'>".$row['name']."</a>
	";
}
?>

Open in new window


this is the viewschita.php

<?php
$db = mysqli_connect("localhost","highmob","PW","highmob_comenzi"); //keep your db name
$sql = "SELECT * FROM players WHERE id = $id";
$sth = $db->query($sql);
$result=mysqli_fetch_array($sth);
header('Content-Type:'.$row['mime']);
echo  $row['data'];

?>

Open in new window


The problem is that I'm unable to see the file
0
Hi There -
I have a code snippet that is not working when I try to use CurrentProject.Path from MsAccess to point to a pre made
Excel Workbook and place data in it using CopyFromRecordset. It has to be something simple I'm missing here.
Thanks in advance,
GeneBat
 (see code below) Cap if you're out there I need help. :)
 
Public Function ExcelfromAccess()
    
    On Error Resume Next

If MsgBox("Are You Sure You Want to Export This data to Excel?", 289, "Export to Excel") = vbCancel Then
        
        Exit Function
   
    Else
    'open excel
        Dim AppExcel As Excel.Application
        Set AppExcel = New Excel.Application
        'Dim strFileName As String
        
    'open new workbook
        Dim oWB As Excel.Workbook
        Dim sFullPath As String
        
        sFullPath = CurrentProject.Path & "\UcaasTemplate.xlsx"

'        Set oWB = AppExcel.Workbooks.Add("UcaasTemplate.xlsx") 'you can specify a template here
'        strFileName = Application.CurrentProject.Path & "\UcaasTemplate.xlsx"
'        Set oWB = AppExcel.Workbooks.Add(Template:="C:\Users\xtek109\Documents\Ucaas Project\UcaasTemplate.xlsx") 'template name goes here + this works
        AppExcel.Visible = True
        AppExcel.Workbooks.Open (sFullPath)
    'copy data to Excel
        oWB.Worksheets(1).Range("A5").CopyFromRecordset CurrentDb.OpenRecordset("LdapCutsheetFormat", dbOpenDynaset)
        
    'turn excel over to user control
        AppExcel.Visible = True
        

Open in new window

0
Hi,
I have a script that uses a product called PHPDocX, I'm trying to insert an image name from a database based on a $POST value:

?php
$servername = "localhost";
$username = "antony";
$password = "*******";
$dbname = "templatemadness";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
$sql = 'SELECT
id,
letter_logo_image
FROM
template_header
WHERE
[b]id = ******************';//this will need to be a $POST value from index.php[/b]
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        
        echo  $row["letter_logo_image"];//to prove it works!
    }
} else {
    echo "0 results";
}

?>
<?php  echo  $row["letter_logo_image"]; ?>
<?php
require_once 'Classes/Phpdocx/Create/CreateDocx.inc';
require_once 'Classes/Phpdocx/Elements/WordFragment.inc';


$docx = new Phpdocx\Create\CreateDocx();
$docx->modifyPageLayout('A4', array('numberCols' => '1','marginRight' => '400','marginLeft' => '400', 'sectionNumbers' => array(2) ));
//create a Word fragment with an image to be inserted in the header of the document
$imageOptions = array(
	[b]'src' => 'images/***imagename from database***', //this needs to pull the image name from 'letter_logo_image'[/b]
	'dpi' => 600,
);

$headerImage = new Phpdocx\Elements\WordFragment($docx, 'defaultHeader');

Open in new window

0
i want to develop a mvc project with database sql server 2014

i want to make a registration form with fields Id,fullname,email,mobile,age,gender,photo path and photo binary data in database.

user should be able to see his details once registered and could be able to update his details as well as the photo he uploaded

please help me with this as i am new in mvc
0
Hi ,
  I have an Sql Server database with table Documents
  There are many duplicates rows with same Document_No  . But I need to get only one row from each document no

From the following sample data , I am looking for a query

   Doc1 Proj1 Path1 ......
   Doc1 Proj1 Path2
   Doc2 Proj1 Path2
   Doc3 Proj1 Path3

Query Should return rows with  Doc2 and Doc3 and one of the Doc1 row (it does not matter which one)
0
i have to connect data from two Databases to get the report as the database is huge i cant go with load option so i need a solution to connect two different Databases using direct Query method  (live data)  in PowerBI

thanks in advance
0
I have gone through many sites but not getting any idea regarding how to build the database and how to start working on it in core php. Any help would be great because I need to complete it as a part of my task
0
Industry Leaders: We Want Your Opinion!
Industry Leaders: 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!

Hi All,

Is it possible to check committed and not yet committed data 1-hours intervals before and after the designated timestamp “2017-12-19 06:35:18.0" in SQL Server DB 2014?

I want to fetch committed and not yet committed data of only main 5 tables not all tables in DB. The below command shows only current active details. I want to fetch designated timestamp.

SELECT * FROM sys.dm_tran_active_transactions
0
I am working on EF6 with MVC5.
The solution is a job manager application.
Here are the data classes

Job class
      Description
      AddressLine1..3
      City
      State
      Zip
      ContractId
      Contract

Contract class
      ContractDescription
      RecruiterID
      RecruitingCompanyID
      RecruitingCompany
      Job


RecruitingCompany class
      CompanyName
      AddressLine1..3
      City
      State
      Zip
      Phone
      ICollection<RecruiterContact>RecruiterContact
      ICollection<Contract>Contracts

RecruiterContact class
      FirstName
      LastName
      RecruitingCompanyID
      RecruitingCompany


The relations need to be as follows:
Job to Contract is 1 to 1
Contract to RecruitingCompany is 1 to 1
RecruitingCompany to Contract is 1 to Many
RecruitingCompany to RecruiterContact is 1 to Many

So,  I will speak to a reqruiter, potentially add the recruiter to the recruiter company or just add to an existing in the DB recruiter company.  The reqruiter gets the contract and the contract is tied to the job.  I think this models the process, but how to build the classes such that EF will build the database/tables/keys/foreign keys and then bootstrapping with some test data is my challenge.

Any suggestions for the data/entity classes and the subsequent bootstrap data would be appreciated.
0
hi,

i downloaded microsoft sql server 2012 express executable with work tool version from


when i try to run by clicking on that getting error as attached

please advise
sqlServer2012Express.png
0
Hi experts,

I'm using sql server 2008.

I'm using the Employees table from the Northwind sample database.

Query 1A

Filter by EmployeeID

I have a query that works fine, it looks like this:

DECLARE @EmployeeID INT
SET @EmployeeID = -3
SELECT [EmployeeID],[LastName],[FirstName] FROM [Northwind].[dbo].[Employees]
WHERE ( (@EmployeeID = -3) OR ([EmployeeID] = @EmployeeID) )

Open in new window


I'm using -3 to display all records.
When I set the @EmployeeID parameter to -3 the query returns all records like this:

p1.PNG
When I set the @EmployeeID parameter to 3 the query returns all records for EmployeeID of 3 like this:

p2.PNG
Query 1B

Filter by EmployeeID

I'm practicing writing dynamic sql queries.
So then I wrote this query. It works just fine. It gives the same results as Query 1A.

DECLARE @EmployeeID INT
SET @EmployeeID = -3

DECLARE @mSQL as varchar(5000)

---------------- Select ----------------

Select @mSQL = 'SELECT [EmployeeID],[LastName],[FirstName] FROM [Northwind].[dbo].[Employees]' 

Select @mSQL = @mSQL + ' Where ( ([EmployeeID] = ' + RTrim(@EmployeeID) + ') Or (' + RTrim(@EmployeeID) + ' =  -3) )' 

---------------- Select ----------------

Exec(@mSQL)

Open in new window



Query 2A

Filter By LastName

So now I want to do the same query as Query 1A but filter by LastName.
I wrote this query and it works fine.

DECLARE @LastName VARCHAR(30)
SET @LastName = 'ALL'
SELECT [EmployeeID],[LastName],[FirstName] FROM [Northwind].[dbo].[Employees]
WHERE ( (@LastName = 'ALL') OR ([LastName] = @LastName) )

Open in new window


I'm using the string 'ALL'  to display all records.
When I set the @LastName parameter to 'ALL' the query returns all records.
When I set the @LastName parameter to 'Leverling' the query returns all records with LastName 'Leverling.


Query 2B

Filter By LastName

So now I have the query that looks like this.
The results of this query should be the same as the results of Query 2A. But I'm getting an error.  
In my where clause where i set ALL i'm not sure of the syntax to use for a string.


Open in new window

0
Im using web service, where the data in project B has to be updated in project A,

Heres how i did for the DAL class in project B
 public DataSet UpdateBook(String baddress, String bpostalcode, String bcountry, String saddress, String spostalcode, String scountry, String bcompany, String bcity, String scompany, String scity)
        {
            int result = 0;
            DataSet updateAdd;
            SqlDataAdapter da;
            string queryStr = "UPDATE CompanyAddress"
                + "SET BillingAddress=@billingaddress, BillingPostalCode=@billingpostalcode, BillingCountry=@billingcountry, ShippingAddress=@shippingaddress, ShippingPostalCode=@shippingpostalcode, ShippingCountry=@scountry, BillingCompany=@billingcompany, BillingCity=@billingcity, ShippingCompany=@shippingcompany, ShippingCity=@shippingcity"
                + "WHERE CompAddressId=@compAddressId";
            SqlConnection conn = new SqlConnection(_connStr);
            updateAdd = new DataSet();
            SqlCommand cmd = new SqlCommand(queryStr, conn);
            try
            {
                da = new SqlDataAdapter(queryStr.ToString(), conn);
                da.Fill(updateAdd);
                cmd.Parameters.AddWithValue("@billingaddress", baddress);
                cmd.Parameters.AddWithValue("@billingpostalcode", bpostalcode);
                cmd.Parameters.AddWithValue("@billingcountry", bcountry);
                cmd.Parameters.AddWithValue("@shippingaddress", saddress);
         

Open in new window

0
Hello All,

This is an extension of a question here - https://www.experts-exchange.com/questions/29071843/Display-Query-Results-in-Message-Box.html

I'm trying to "cache" the results of the input box and re-use it on reload of the script.

My thought is this:

Is it possible to send the result of objRecordSet("ID") to a spreadsheet, then put that result from the spreadsheet as the default data in the input box?

So, the below code works fine. It populates the fields as it should but I want to send the objRecordSet("ID") to the
spreadsheet and retrieve it from the spreadsheet at reload of the script to be input box default value - see bold font I added that's not part of the original script.

So, in effect each ID the user enters in the input box will be the default value when they re-run the script.

If there's another way to do what I'm asking, I'm all ears! I hope this makes sense, thanks!


strKey = InputBox("Enter Person ID","Search", MyDefaultValue)
If strKey = "" then
Field1 = ""
Field2 = ""
on error resume next
Else
strConnection = "Provider=SQLOLEDB;Server=;Database=;User ID=;Password="
strSQL = "SELECT * FROM Table1 where ID LIKE '%" & strKey & "%' or User_Name LIKE '%" & strKey & "%'"
Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open strConnection
Set objRecordSet = CreateObject("ADODB.Recordset")
objRecordSet.Open strSQL, objConnection, adLockReadOnly
do while objRecordSet.EOF = false
Field1 = …
0
Hello Experts,

I have run a hql called samplehive.hql, see attached. However, the script fails with the following error:

FAILED: ParseException line 1:2 cannot recognize input near 'D' 'R' 'O'
18/01/17 20:46:46 [main]: ERROR ql.Driver: FAILED: ParseException line 1:2 cannot recognize input near 'D' 'R' 'O'
org.apache.hadoop.hive.ql.parse.ParseException: line 1:2 cannot recognize input near 'D' 'R' 'O'

I'm very new to Hadoop Hive, can someone take a look at the script and let me know where I'm going wrong

Thanks
samplehive.txt
0
How can i do random balance in ms access? as like attached file
Bank-Statement.xlsx
0
Hi,

How do I join these two databases?

db1: Visitors
Table: Users
This table contains all users on the system.  each one has a unique "UserID"


db2:  PT_UserData
Table: Client_Scores
This table contains only those users who have completed a test
If they complete a test, the field "YourType" IS NOT NULL
All rows contain the field "UserID"


Both tables have "UserID" in common

I'm looking to output those users who have completed the test, but I need their Email and LastName which is in the Users table
0
What does it mean to be "Always On"?
LVL 5
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.

I have a vb.net App attached to a SQL MDF database.  Inno Script supports .net 45  The database is version 852.(2016+) MsSQLLocalDB will only run version 782database.   since inno script doesn't check for or install dotnet46, or the local db version, how do either:
ADD the new files to connect to this database or
Is there an existing script for the new version of dotnet.

OR should i consider a different installer.  This is not an area of my expertise and this will be installed on many different machines as a local APP.   I could use some advise.  Thanks
0
I am upgrading SQL 2008 R2 to SQL 2016 Developer
Ran update advisor and took advice to install SQL 2008 service Pack 4, done successfully
However the feature rule step fails with Valid Database compatibility level and unsuccessful connection
The extended error message advises that:
The report server database is not a supported compatibility level or a connection cannot be established. Use Reporting Services Configuration Manager to verify the report server configuration and SQL Server management tools to verify the compatibility levels.
I knew nothing about the Reporting Service, but since then I have:
  • Checked Services that the SQL Server Reporting Services is started
  • Changed the security on SQL Server Reporting Services to Local system~Windows authentication
  • Stopped and started service
  • Run Reporting Service Config Manager as administrator.  It required a connection on opening.  Fails to Find connection to DESKTOP-PHACT and does not allow me to use other options.
  • Opened SSMS and opened report server.  Even run a Crystal type report (see attachment)  

Any suggestions?
SSMS_reportServer.jpg
0
Hello,

I would like to ask your help, perhaps someone has seen this problem:

- Using web service I upload product groups, products and variations into Presta shop
-Everything  looks fine in the admin window. The groups, products and variations are created.
-But at the end user window the new products cannot be seen among the New products and neither under the manufacturer.
However on the page of the product the quantity and the manufacturer fields are filled
-If I refresh a product manually then the product will be seen under the New products and under the manufacturer.

The product upload code is this:

$xml = $webService->get(array('url' => $shopurl.'api/products?schema=blank')); $product = $xml->children()->children(); $product->price = 0; $product->wholesale_price = 0; $product->active = 1; $product->on_sale = 0; $product->show_price = 1; $product->available_for_order = 1; $product->id_tax_rules_group = 1; $product->unity = $data->Termek_Csomagolasi_egyseg; $product->minimal_quantity = $data->Termek_MinimumKeszlet; $product->pack_stock_type = 3; $product->state = 1; $product->reference = $data->Termek_SajatCikkSzam; $product->id_manufacturer = $gyarto['id_manufacturer']; $product->name->language[0][0] = $data->Termek_Megnevezes; $product->name->language[0][0]['id'] = 1; $product->description->language[0][0] = $data->Termek_Megjegyzes; $product->description->language[0][0]['id'] = 1; $product->description_short->language[0][0] = $data->Termek_Megjegyzes; …
0
I have observed in many examples using entities and developing powerapps in office 365 that the designs are usually flat and do not use relational table examples.  Is it possible to have a relational entities/database in powerapps and develop reports from those relational tables?  If so, can anyone cite some examples?
0
Hello,

i've just just taken over management of an oracle 10g database and i've noticed there are no backups in place in the event of hardware or operating system failure.

I'm looking for the best way to schedule automatic backups of an oracle 10g database to a remote location.

I'm looking for a complete backup as the database has tables, views, packages, functions and triggers all of which i need backed up.

Preferably i'd need my backup destination to be either a remote server on vlan, a remote ftp server or possibly an AWS S3 bucket.

What would other oracle database administrators suggest?
0
Hello Experts,

I have followed the process from the following link to generate a flat file
https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-load-sql-data-warehouse

Instead of using the command Dbgen -s 1000 -S **1** -C 10 -T L -v, I used the command dbgen -s 1, to enerate the database population for the qualification database, as described at the following link

https://github.com/Azure/Azure-DataFactory/tree/master/Samples/TPCHTools

However, I'm not sure where to look on my PC for the generated file

Can someone let me know where I might find the file?

Cheers

Carlton
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.