No announcements
-
6 VotesAnnouncement: Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) Released
A new OLE DB driver, Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL), has been released. This new driver includes the support for the latest TLS 1.2 standards and is backwards compatible ...Sticky | 9 Replies | 10093 Views | Created by Dan Guzman - Friday, March 30, 2018 11:17 PM | Last reply by Erland Sommarskog - Tuesday, November 27, 2018 8:08 AM
-
1 Votes
Guidelines when posting JDBC related questions
In order to better assist troubleshooting JDBC and JDBC related connectivity issues, the more specific the problem you describe, the faster we can help you out. Please take a few ...Sticky | 3 Replies | 54917 Views | Created by Jimmy Wu - MSFT - Saturday, August 2, 2008 12:44 AM | Last reply by PK79 - Thursday, October 18, 2012 3:54 PM -
9 Votes
Steps to troubleshoot SQL connectivity issues
Please follow this blog to troubleshoot SQL connectivity issue and post question here. Steps to troubleshoot SQL connectivity issues Lot of blogs related to SQL ...Sticky | 7 Replies | 98792 Views | Created by Xinwei Hong - MSFT - Wednesday, April 30, 2008 4:40 PM | Last reply by Ramu_MSFT - Saturday, February 4, 2017 2:47 AM
-
0 Votes
PolyBase - Oracle Statistics FULLSCAN Requirement
Is this going to be changed in future CU's? This causes significant performance issues with large tables within Oracle.Unanswered | 2 Replies | 189 Views | Created by Brent Proctor - Wednesday, December 25, 2019 8:42 PM | Last reply by Erland Sommarskog - Thursday, December 26, 2019 9:49 AM -
1 Votes
ODBC all of a sudden not working - Invalid cursor state
Hi all, been using a SQL Server R17 for 2 years now, and using Microsoft Access 64-bit to access data via passthrough queries and export to Excel. All of a sudden ...Proposed | 12 Replies | 919 Views | Created by ddregs - Tuesday, December 17, 2019 11:17 AM | Last reply by Rachel_Wang - Thursday, December 26, 2019 2:56 AM -
0 Votes
Problems with Access and ODBC
Since last week's update, our Access has an error when using ODBC. The situation is as follows. 3146 ODBC CALL ...Proposed | 2 Replies | 387 Views | Created by Wl52070 - Wednesday, December 18, 2019 8:17 AM | Last reply by Rachel_Wang - Thursday, December 26, 2019 2:52 AM -
0 Votes
SQL Database Access
Hi there, please kindly assist. I have a SQL2012 database hosted on a server, which is remote connected through an end-user application. I am ...Unanswered | 6 Replies | 248 Views | Created by Nhlex The Messenger - Monday, December 23, 2019 1:02 PM | Last reply by Lily Lii - Thursday, December 26, 2019 1:47 AM -
0 Votes
accessing an access db
in sql2008 the following runs fine SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0', 'Data ...Proposed | 12 Replies | 234 Views | Created by berli - Tuesday, December 24, 2019 11:28 AM | Last reply by Erland Sommarskog - Wednesday, December 25, 2019 9:52 AM -
0 Votes
Views not returning complete data
I recently started a factory position that uses SQL to store machine data. One of the Views in a database is set-up to return values for about 10 different columns. The problem is that the Views query ...Proposed | 4 Replies | 932 Views | Created by Robert A. Perry - Tuesday, December 10, 2019 4:03 PM | Last reply by Rachel_Wang - Wednesday, December 25, 2019 5:41 AM -
2 Votes
Porblem with SQLBulkCopy when Column in Primary Key with UniqueIdentifier
I am trying to insert data into a table with a primary key having default value of newsequentialid() using SqlBulkCopy. Prior to insert the data by examining ...Answered | 5 Replies | 7039 Views | Created by Gene Ariani - Saturday, March 10, 2012 3:40 PM | Last reply by Erland Sommarskog - Monday, December 23, 2019 10:04 PM -
0 Votes
Data Factory SQL Server Connection Error
Hello, I am trying to use Azure's data factory to copy data from a SQL Server. I am able to access this server using SQL server management studios but when I try to access using ...Proposed | 3 Replies | 568 Views | Created by SantiASC - Wednesday, December 18, 2019 4:57 AM | Last reply by Rachel_Wang - Friday, December 20, 2019 7:37 AM -
1 Votes
The database [ABC] is not accessible (ObjectExplorer)
Hi, I am getting an error while accessing the database ABC (which I Created.) and the error is below. The database is not ...Answered | 6 Replies | 54300 Views | Created by Sunil Kumar KVA - Monday, October 24, 2011 1:34 PM | Last reply by snamburu - Thursday, December 19, 2019 7:40 PM -
2 Votes
Ubuntu 16.04 LTS repos for mssql odbc driver 17 unusable since this morning
Hello, c.f. this post on askubuntu I created earlier today. Since this morning's update of the repo a sum mismatch prevent the use of the official ...Unanswered | 5 Replies | 1040 Views | Created by Chalmel Vincent - Friday, December 13, 2019 1:17 PM | Last reply by Ace6807 - Tuesday, December 17, 2019 12:15 PM -
0 Votes
Problem executing SP from sqlagent job, EXECUTE AS USER' failed for the requested user '' in the database
Hi I have a stored procedure in the database that retrieves a data set for an SSRS report. No problem executing the stored procedure from query window. In the ...Answered | 2 Replies | 509 Views | Created by ghw123 - Sunday, December 15, 2019 7:28 PM | Last reply by Will_Kong - Tuesday, December 17, 2019 7:11 AM -
0 Votes
New ADODB from Win 10 (1803) too slow
Hello Some time ago I updated my Windows 10 Pro to 1803 build. Today I detected than my tests, created on VBScript and ...Answered | 9 Replies | 3512 Views | Created by Kovalenko_Dmitry - Monday, August 27, 2018 4:40 PM | Last reply by Riemenjoe - Thursday, December 12, 2019 3:00 PM -
2 Votes
MSOLEDBSQL Provider. Error using ADODB.Command XSL property
Hi, First post so apologies if I break any forum rules. We are undertaking a migration from SQL2008R2 to SQL2017 on Windows 2016. The new Windows 2016 servers are ...Proposed | 9 Replies | 1262 Views | Created by SlowV6 - Wednesday, December 4, 2019 1:26 PM | Last reply by Ashin_c - Thursday, December 12, 2019 6:59 AM -
0 Votes
SQL server to DB2 database federation
I am new to SQL Server. I have a Sql server 2016 database and db2 luw 10.5 database. I want to access the db2 tables as remote views within my sql server ...Proposed | 2 Replies | 857 Views | Created by Laxmi Sriram - Tuesday, December 10, 2019 6:54 PM | Last reply by Rachel_Wang - Wednesday, December 11, 2019 3:23 AM -
2 Votes
Win 10 client can't connect
Hi all, I have a client app which I have been installing on various computers that run Win 7 in a domain. This has worked fine. I installed this same app on two Win 10 computers and ...Answered | 4 Replies | 1032 Views | Created by SagaV9 - Monday, December 9, 2019 6:58 PM | Last reply by SagaV9 - Monday, December 9, 2019 10:24 PM -
0 Votes
custom database occationally crashing - SQL backend, MS Access front end
Windows 2012R2, 16GB ram, SQL version 2012, up to date windows updates. No additional AV running on this server. Workstations -> new Lenovo M710s, Windows 10 Pro (v1903, OS ...Proposed | 3 Replies | 1342 Views | Created by johnny77 - Saturday, November 30, 2019 2:51 PM | Last reply by Rachel_Wang - Thursday, December 5, 2019 7:38 AM -
0 Votes
SQL Server Agent is getting stopped after latest update
Dear Team, After latest patch update on Windows server SQL server agent got stopped.It gives below error logs . 2019-12-03 10:24:59 - ? [100] ...Proposed | 6 Replies | 1169 Views | Created by Shushant Vikram - Tuesday, December 3, 2019 5:33 AM | Last reply by Rachel_Wang - Thursday, December 5, 2019 7:26 AM -
0 Votes
having issues with the agent job failure
Date 12/2/2019 2:40:07 AM Log Job History (DonorStudio - ETL Letters - Daily) Step ID 4 Server Job Name ...Proposed | 3 Replies | 1336 Views | Created by sunni121 - Monday, December 2, 2019 5:48 PM | Last reply by Rachel_Wang - Tuesday, December 3, 2019 5:39 AM -
12 Votes
Persist Security Info
Hi, Can someone explain to me the use of Persist Security Info = 'TRUE' on the SQL connection string from a DOT NET application. All microsoft documentation and ...Answered | 8 Replies | 70977 Views | Created by Venky24 - Friday, February 17, 2012 5:19 PM | Last reply by Dan Guzman - Tuesday, December 3, 2019 3:20 AM -
0 Votes
Bug report: ODBC Driver 17 for SQL Server fails to relay error messages containing apostrophes
Description: When SQL code or a SQL Server stored procedure raises a custom error message that contains an apostrophe, the error message is not relayed to the ...Proposed | 1 Replies | 882 Views | Created by c-am - Monday, December 2, 2019 2:25 AM | Last reply by Rachel_Wang - Monday, December 2, 2019 6:35 AM - Items 1 to 20 of 13626 Next ›
No announcements
