Questions tagged [sql-server-2017-express]
51 questions
1
vote
1 answer
Use common python libraries for SQL Server 2017 and Visual Studio 2017
The Anaconda python packages installed for Visual Studio 2017 and SQL Server 2017 are separate. Is there any way that the two programs can reference one common set of Anaconda python packages?
mrduncle1
- 589
- 7
- 11
0
votes
1 answer
Using SQL Server authentication with localdb
I have a web app (SPA) with React as front-end and ASP.NET Core as backend. It is working fine on my desktop using SQL Server 2017 localdb with Windows authentication.
I want to use SQL Server authentication with username and password because the…
Fiaz Ahmed Ranjha
- 245
- 1
- 6
- 22
0
votes
1 answer
Two history tables for system-versioned tables shown
Today I noticed that one of my many databases in SQL Server has two history tables for all system-versioned tables in the database.
Both tables have similar content but NOT IDENTICAL. One history table has more records than the other. I tried to…
emphyrio
- 87
- 7
0
votes
2 answers
Discount Present Update When Quantity Change
I have table call tblInvoice. This is my table with some data.
InvoiceNo
ItemName
Quantity
CostPrice
ItemCode
DiscountPrice
DisPresent
Amount
GrossAmount
SalePrice
INV01
80= BK
10
30.00
EX80=
40.00
100.00
400.00
575.00
50.00
INV01
80=…
0
votes
2 answers
Prevent Combobox values repeating When select Items form another combobox
I have two combo box which names are cmbInvoiceNo and cmbItemName. I get all invoice numbers to the cmbInvoiceNo using following code.
// Get data from database to the **cmbInvoiceNo** combobox
private void GetInvoiceNo()
{
using…
0
votes
2 answers
How to run crystal report on client machine without giving full path
I created Stock Management System using c# and SQL Server Management Studio. In my system have crystal reports. when I run my project on client machine. its work as expected. but I cannot open crystal report. The reason is given path is not same…
0
votes
1 answer
Unable to connect to a Linux-based SQL Server 2017 Latest database container with SSMS
A RESTFUL API depends on a SQL Server database so I am trying to use a SQL Server Linux container as shown here.
API app dependents on a database (mcr.microsoft.com/mssql/server:2017-latest-ubuntu), so I ran this docker command in Windows…
Anirban Goswami
- 41
- 6
0
votes
0 answers
YII2 PDO Error with MSSQL 2017 on Docker?
SQLSTATE[42S02]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'auth_item'.
The SQL being executed was: SELECT * FROM [auth_item] WHERE [name]='admin'
Error Info: Array
(
[0] => 42S02
[1] => 208
[2] =>…
JohnWorks
- 33
- 3
0
votes
1 answer
Remove time when exported to pdf
My datagridview doesn't have the time in datePurchased column. But when I exported it to PDF, it already includes the time. I need only the date not the time. Below is the sample code
//For exporting to pdf
Private Sub…
Annie
- 1
- 1
0
votes
0 answers
Cannot install the database engine services for Microsoft SQL Server 2017. Error on SqlEngineConifg_Action_configonrc_Cpu64
I am trying to install Microsoft SQL Server 2017 that was provided to me from school. However I keep getting an error that my database Engine Services do not get installed, it keeps hanging at one specific point.
Mainly the…
ThunderSpark
- 183
- 2
- 11
0
votes
1 answer
Remove the time in Datagridview and when exported to PDF
Please help me guys!
I want the time in Date_Purchased(date) to be removed in datagridview. Because whenever I exported the datagrid in PDF, it has the date and time in it. I only want the date and remove the time especially when exported to…
Annie
- 1
- 1
0
votes
1 answer
SQL Server downgrade to 2014 problem with permissions Windows 10
I finished development of my ASP.NET application. As database I used SQL Server 2017. I am trying to move the app from localhost to server. I buy hosting but version of SQL Server on hosting is 2014. They sent me that I need downgrade my database to…
Šimun Višević
- 35
- 1
- 6
0
votes
1 answer
How to give every Remote Desktop User access to SQL Server via a database admin account, not their own credentials
I'm working with ancient software using MS Access components on a Windows Server 2016 (configured as domain controller) Remote Desktop Terminal server (which I cannot circumvent or replace with local installations due to licensing hardware) that…
Henry van Megen
- 2,159
- 2
- 23
- 35
0
votes
1 answer
SQL Server 2017 for Docker does not work (because of missing ipv6?)
I am working on a SQL Server 2017 Docker container. The database will never start.
I have customized the image only to run the health check. Same problem occurs without using the cusotmized Dockerfile.
The host machine has ipv6 completely disabled.…
usr-local-ΕΨΗΕΛΩΝ
- 26,101
- 30
- 154
- 305
0
votes
1 answer
Unable to get data from Json string in sql server database
I am trying to get all the fileDisplayName value from my data set column which has json string.
select
id_ref id,
JSON_VALUE(cast(data_map as varchar(max)),'$.dataMap."4805".fileDisplayName') Attachments,
data_map dataa
from action_data where…
