Questions tagged as 'sql-server'

Tagged questions
0
answers

vb.net return image field value with Null value in database Sql server 2015

I'm trying to return a Null value in the image column of image type in sql server 2015 database in visual basic (visual studio 2015), but I do not know which parameter to pass in if, because it claims the following error:    It is not possibl...
asked by 18.06.2018 / 21:59
0
answers

Power BI - Problem connecting to Analysis Services

I'm trying to connect Power BI with Analysis Services, but I can not. Being that through Excel I can connect. At the time of putting the IP of the server, I tried two ways: XXX.XXX.XXX.XXX or, as in connection to SQL Server, XXX.XXX.XXX.XXX:1433...
asked by 12.06.2018 / 15:34
0
answers

Search in the combo box data that contains specific record in the bank

I am developing a project in C # MVC, it has a combo box that takes the data from a sql server database I did adding in the combo box itself and list all, I would like in that same combo box to be able to type for example "Maria" and return all...
asked by 11.06.2018 / 18:11
0
answers

Insert into the database a value of type date [duplicate]

How can I insert the value of a date, for example 2018-06-12, into the database from a java application? I have the application made in javafxml and when I run the application and I enter the date and the rest of the values it gives me this er...
asked by 11.06.2018 / 01:52
0
answers

Insert into the database a value of type date [duplicate]

How can I insert the value of a date, for example 2018-06-12, into the database from a java application? I have the application made in javafxml and when I run the application and I enter the date and the rest of the values it gives me this er...
asked by 11.06.2018 / 01:52
0
answers

SQLSTATE [IM003]: Specified driver could not be loaded due to system error 193

Itriedtoreinstallthedriver,butIdidnotsucceed.PHPisworkingnormal,IhaveinstalledtheMicrosoftDLLsforODBCinstallation,whichare:php_pdo_sqlsrv_56_ts.dll,php_sqlsrv_56_ts.dll. The error appears to be in the SQL SERVER 11 ODBC driver. The PHP versio...
asked by 08.06.2018 / 00:10
1
answer

ERROR NO PHP: Fatal error: Call to undefined function sqlsrv_query ()

My login validation is giving this error: Fatal error: Call to undefined function sqlsrv_query() every time I try to login to the site I created. I made the connection to the db SQL SERVER: <?php class Conexao { private stati...
asked by 07.06.2018 / 13:37
0
answers

Error in asp.net linked to sqlserver

I have this code: <head runat="server">                    <div class="barraCima"> <img class="simbolo" alt="icon" src="images/doctor.png"/> </div> <div class="main"> <div class...
asked by 11.06.2018 / 21:17
1
answer

Deploy rows in a date range

I have a question regarding SQL SERVER and I needed your help. I have a Query that returns a line with a number, Start_Date and End_Date. Inquiry: select 123456 as Numero, a.Data_inicio, a.Data_fim from CLI_INTERNAMENTOS_UTENTES a where a...
asked by 01.06.2018 / 20:10
0
answers

FileUpload file format saved on database sql server 2008 with type Image

I have a problem finding the right encoding for a file that is saved to the database through FileUpload from asp.net on sql server 2008 with type Image. I need to migrate a web system to an Android application using a webservice in asp.net for c...
asked by 30.05.2018 / 15:02