No announcements
Found 13770 threads
-
0 VotesJDBC Driver is making a sp_sproc_columns to get sproc column metadata for every sproc call
WE are using the Microsoft JDBC Driver v6.0 to connect to MSSQL 2014 databases, and call stored procedures. We use Named parameters when we call the sprocs. We are finding ...Unanswered | 2 Replies | 3867 Views | Created by Feroze Daud - Thursday, January 26, 2017 1:28 AM | Last reply by sagar_kondoori - Monday, June 29, 2020 10:02 AM
-
0 Votes
Spring's NamedParameterJdbcTemplate causing an unwanted metadata call
We noticed that performance wasn't stellar but didn't bother us that much because it was a background process then we were contacted by our DBA who informed us that each stored procedure call was ...Unanswered | 2 Replies | 5152 Views | Created by OMVillada - Wednesday, July 24, 2013 8:39 PM | Last reply by sagar_kondoori - Monday, June 29, 2020 9:52 AM -
0 Votes
Reconnecting to database after fresh install
I reinstalled my OS fresh and am trying to reconnect to my databases that were installed in the previous installation of SQL Server 2017. It was windows authentication and my credentials have changed. ...Proposed | 4 Replies | 2631 Views | Created by ecradtke - Thursday, June 25, 2020 12:03 AM | Last reply by Lily Lii - Friday, June 26, 2020 2:04 AM -
0 Votes
How can I access a SQL DB on a SQL Server in Azure from a docker container?
The docker container gets environment variables passed: DB=mysql MYSQL_HOST=<MySQL hostname> MYSQL_PORT=<Port> ...Proposed | 2 Replies | 2244 Views | Created by iThiemann System Solutions - Wednesday, June 24, 2020 12:51 PM | Last reply by Lily Lii - Thursday, June 25, 2020 2:44 AM -
0 Votes
SQL Server High Availability and ODBC drivers
Hi, we have a client using SQL Server 2016 using the High Availability option (they are using primary and secondary servers). We are having problems (intermittently) when our client application ...Answered | 4 Replies | 2441 Views | Created by varleyp01 - Tuesday, June 23, 2020 9:09 AM | Last reply by varleyp01 - Wednesday, June 24, 2020 9:53 AM -
0 Votes
Can somebody hack the database from Azure ?
Hello everyone, I have a question about settings of our Azure SQL database. We have default settings. Allow Azure Services and resources ...Answered | 3 Replies | 2752 Views | Created by Frantisek Langer - Tuesday, June 23, 2020 12:10 PM | Last reply by Frantisek Langer - Wednesday, June 24, 2020 7:04 AM -
3 Votes
select distinct records
> POSITION >> PAYROLL >> etc. Any assistance much appreciated. First Name Last ...Proposed | 11 Replies | 2787 Views | Created by LuisCarlosSantos - Tuesday, June 16, 2020 4:56 AM | Last reply by Lily Lii - Tuesday, June 23, 2020 5:17 AM -
1 Votes
Powershell connexion failed
Helo, I am new to SQL Server and I am trying to connect remotely from a server (A-SERV) to my SQL Server (B-SERV) with ...Answered | 6 Replies | 2685 Views | Created by Mike-eul - Friday, June 19, 2020 1:49 PM | Last reply by Mike-eul - Monday, June 22, 2020 8:59 AM -
0 Votes
postgresql Severity.error : Unsupported authentication type 3, closing connection
I created a flutter applications and plans to use Azure postgresql as the database. I used a dart package that connects with the database. Package is called postgres 2.1.1. However, as ...Proposed | 1 Replies | 2653 Views | Created by Geraldspacelim - Saturday, June 20, 2020 3:11 AM | Last reply by Lily Lii - Monday, June 22, 2020 6:45 AM -
0 Votes
How to install 32-bit linux version odbc driver for sql server (azure sql mi)
My partner want to connect to azure sql MI on linux system, and they need 32 bit ...Proposed | 2 Replies | 2335 Views | Created by Why stil can't i configuration lab Management - Friday, June 19, 2020 8:04 AM | Last reply by Lily Lii - Monday, June 22, 2020 2:40 AM -
0 Votes
VBA wrongly throws errors after upgrading SQL Server to version 14.0.2027 RTM from version 10.50.2500 SP1
Hi there, When using the new SQL Server, our Access Front End throws different writing conflict errors when executing code that involves writing to a table that contains a SQL ...Answered | 11 Replies | 2634 Views | Created by AngelBlanco - Thursday, June 18, 2020 1:12 PM | Last reply by Naomi N - Friday, June 19, 2020 1:39 PM -
1 Votes
Unable to access remote sql server on local machine.
I am using Azure VM with Windows 10 and right now unable to access remote sql server on local machine. please urgent help required.Unanswered | 5 Replies | 2069 Views | Created by Abdul Bhatti - Monday, June 15, 2020 5:12 PM | Last reply by Melissa Ma - Friday, June 19, 2020 8:21 AM -
0 Votes
Data Capture .... Where/How?
I posted this in the Community Form and they suggested I repost here... I am unclear how to work within the MS framework for this. Or what approach I should ...Unanswered | 3 Replies | 1930 Views | Created by NewIdea134 - Tuesday, June 16, 2020 8:48 AM | Last reply by Lily Lii - Friday, June 19, 2020 7:55 AM -
1 Votes
Create linked server to SYBASE ASA 9.0
Hi all, I´m trying to create a linked server to a Sybase database (.db file) so i can create some reports in sql 2005 (with ...Proposed | 8 Replies | 72794 Views | Created by PamSpace - Wednesday, April 2, 2008 4:17 PM | Last reply by SurFitz - Thursday, June 18, 2020 3:04 AM -
0 Votes
Using "like" statement in order to filter DATE field SQL SERVER 2014
Hello, could somebody help me in using "like" statement in filtering DATE field in SQL SERVER table. Namely, in C# web application, I have this date format e.g., 20-Dec-19 while, in SQL ...Answered | 8 Replies | 1988 Views | Created by daredavil3011 - Wednesday, June 17, 2020 3:41 PM | Last reply by daredavil3011 - Wednesday, June 17, 2020 8:20 PM -
3 Votes
Linked Server to DB2: Codepage conversion error
Hi, everybody! The Situation: This is a followup to a question I asked before regarding linked ...Answered | 11 Replies | 15790 Views | Created by Jens-Peter Giersch (OSGROUP) - Tuesday, March 29, 2011 1:02 PM | Last reply by DrQuery - Wednesday, June 17, 2020 3:50 AM -
0 Votes
SelfHosted Integration runtime - ODBC AlwaysEncryption does not work for insert into Sink database
Hello, We have Azure SQL Database with one of the column is been encrypted using ColumnEncryption features. CMK is stored in AzureKeyVault. To perform copy ...Answered | 2 Replies | 1901 Views | Created by jay_thaker12 - Friday, June 12, 2020 2:20 AM | Last reply by jay_thaker12 - Friday, June 12, 2020 7:55 AM -
0 Votes
Providers for Linked Servers on Linux SQL Server
I have installed Ubuntu 16.04 and MSSQL server (including the ODBC driver). I need this server to connect to an Azure database so the MS ODBC driver is ...Proposed | 2 Replies | 4446 Views | Created by KevinMClarke - Friday, March 16, 2018 10:45 AM | Last reply by KevinCamposatCR - Friday, June 12, 2020 4:53 AM -
0 Votes
Cross Database Ownership Chaining not working with AD Group
Hi I have tried to figure this problem for some time now, and cannot get my head around it :-( I am using MS SQL 2019 CU4 Std. I want to use ...Proposed | 4 Replies | 1620 Views | Created by Kilsgaard - Tuesday, June 9, 2020 1:17 PM | Last reply by Lily Lii - Thursday, June 11, 2020 9:52 AM -
1 Votes
Unable to connect to RDS PostGres
I want to access my DB on AWS RDS Postgres from the SQL Server. I have made the linked Server connection, connection was successfully established and I can see the AWS RDS Postgres tables. However, ...Answered | 4 Replies | 1904 Views | Created by ocp_aman - Tuesday, June 9, 2020 6:56 AM | Last reply by Erland Sommarskog - Wednesday, June 10, 2020 8:24 PM
No announcements
