Questions tagged as 'sql-server'

Tagged questions
0
answers

Auto-incremental secondary field in SQL Server

good day! I do this thread because I'm working with a transformer database The subject is the following, I have something like that .. Table Transformer *Código comercial 1º Cliente 1º Nota de venta Fecha de diseño Norma etcetera...
asked by 22.03.2018 / 15:44
1
answer

Node mssql Error: "Connection is closed" when I run several queries at the same time

It turns out that I'm using Node and SQLServer and angular, when I make a query, I do not get any error, the detail is when for example I enter a form and I want to load data as types of ID, user types, ect . In which I call a query for each one...
asked by 16.03.2018 / 21:22
1
answer

Help with this string to save in SQL

Could you help me find the error in this string, I'm using Visual Basic INSERT INTO PRODUCTOS (CodigoProducto,Nombre,Compra,Venta,Stok,Fecha,Impuesto,idCategoria,idProveedor) VALUES (" & ID & ",' " & nombre & " ',' " & Co...
asked by 17.03.2018 / 04:39
1
answer

How to make a view with tables of different databases?

I know that my question is basic, but I want to know how to do a view that returns me certain fields of 3 tables that are in different BD, 2 of these tables are from one database and the remaining table from another database. I hope you can help...
asked by 16.03.2018 / 23:35
0
answers

Access an OLAP Cube out of the Network

I am wanting to enable the connection so that through excel, they can connect to the Analysis Services cubes that I have already processed on the server. I'm following this tutorial, but I do not get anywhere:    link I already made...
asked by 16.03.2018 / 16:33
0
answers

Does a server have access to the internet to run a .NET page inside an intranet?

Currently working in local mode with a Web application developed in .NET using c #, Html and JavaScript, which works perfectly (in local mode). But, when I do the publication in the server of this Web App, the functionalities of it are lost,...
asked by 13.03.2018 / 17:37
1
answer

Error inserting in Mysql from Sql Server2014 with SSIS

I am using an Integration Services with VS 2013 and Sql Server 2014 I want to export data from a Sql Server table to Mysql but it gives me an error and I will export to another database in Sql Server and also to execel 2016 and I will not no pro...
asked by 12.03.2018 / 20:01
1
answer

Connection to Sql Server by JAVA - Windows Authentication

I want to connect to Sql Server using Java with Windows Authentication but I get the following error: This driver is not configured for integrated authentication. ClientConnectionId: 0b65956b-a286-4aef-a372-ab741a239761 This is the code I use...
asked by 09.02.2017 / 20:20
2
answers

Query without repeating sql server

Someone can help me get a query without repeated data by "column", and try the famous DISTINCT but only remove the repeated fields of all the columns that you select, SELECT DISTINCT RUC, BUSINESS NAME , TRADENAME , HOME , TELEPHONE , email, web...
asked by 03.03.2018 / 20:24
1
answer

Problem connecting Yii2 with SQL Server

I'm trying to connect my Yii2 application with a database in SQL Server, the version I'm using is 10.0, this is my error message:    exception 'PDOException' with message 'SQLSTATE [08001]: [Microsoft] [ODBC Driver 11 for SQL Server] Named Pi...
asked by 01.03.2018 / 03:10