Questions tagged as 'sql-server'

Tagged questions
1
answer

Problems comparing two variables in php

I have two sql server queries in php and I want to compare them. I have them as follows: $variable1 has N amount of data. $variable2 has N amount of data. Both variables save SQL Server queries from different tables...
asked by 17.11.2018 / 17:42
2
answers

No suitable driver found for jbdc: sqlserver

I have followed all the steps I find, I have tried several versions of the driver but still it does not let me connect and says that the driver version is not compatible This is the code I use to try to connect package dbtienda; import java.sq...
asked by 22.11.2018 / 05:50
0
answers

Group By Sum SQL How to show cumulative states by category

Hello basically I need to show for each category the accumulated by each state. Allow me to show the table of Forms Category Each Form has a category ID And we also have the form Submission table in this table are all the forms th...
asked by 16.11.2018 / 15:28
0
answers

Problems opening a report from C # in Crystal Report

Working in a Windows Forms, Crystal Report 8.5, and SQL Server 2014 desktop application To connect from CR to my database is through ODBC the strange thing is that I have a report that only use a single table and works well if I do not send p...
asked by 16.11.2018 / 13:16
2
answers

Validate if a record exists in a SQL SERVER table

Cordial Greeting, What I want to do is validate if a record exists in a table with a stored procedure from SQL SERVER. USE [BDCredito] GO /****** Object: StoredProcedure [dbo].[SP_CONS_SOLCUPO_APRO_EXISTE] Script Date: 11/15/2018 08:48:...
asked by 15.11.2018 / 15:14
0
answers

Error connecting pyodbc to external server

Hi, I'm connecting my application to an external database server sql server 2008 R2 and I can not connect, it gives me the following error    pyodbc.OperationalError: ('HYT00', '[HYT00] [unixODBC] [Microsoft] [ODBC Driver 13 for SQL Server] L...
asked by 10.11.2018 / 17:36
0
answers

Connection error to SQL SERVER By ip public

I have installed xammp on my home computer, I am developing a web inventory for a company, it is ready, I established a local connection from the company to the server of the same one and without problems connected, then I wanted to test...
asked by 14.11.2018 / 19:31
0
answers

How to get the data of a new user

My problem is the following one I want to obtain everything that that user of 6 days of antiquity did. I thought so but it does not give me any results and there are transactions within the range put the slogan is OBTAINING THE TRANSACTIONS T...
asked by 08.11.2018 / 19:44
1
answer

My registry is not updated with ConfigurationManager

For days now I am trying to do a update but nothing that updates the record I want. I have already tried two ways and none of them has worked for me. I do not know if I have a syntax error or what the problem might be. This is the c...
asked by 07.11.2018 / 18:36
0
answers

How to make a connection to SQL SERVER with php from a web server?

I have the following error: Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2] => This extension requires the Microsoft ODBC Driver 11 or 13 for SQL Server. Access the following URL...
asked by 06.11.2018 / 19:14