No announcements
-
1 VotesGuidelines 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 | 47106 Views | Created by Jimmy Wu - MSFT - Saturday, August 02, 2008 12:44 AM | Last reply by PK79 - Thursday, October 18, 2012 3:54 PM -
9 VotesSteps 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 | 84721 Views | Created by Xinwei Hong - MSFT - Wednesday, April 30, 2008 4:40 PM | Last reply by Ramu_MSFT - Saturday, February 04, 2017 2:47 AM
-
0 VotesNamed Pipes Provider: Could not open a connection to SQL Server [53]
Hello there, I am trying to establish a connection to another SQL Server using a linked server but I receive the below error ...Unanswered | 2 Replies | 66 Views | Created by AngelBlanco - 10 hours 20 minutes ago | Last reply by AngelBlanco - 2 hours 38 minutes ago -
0 VotesOLE DB Error Record dump for hr = 0x80004005
Hi, We get following errors intermittently while connecting from Application to Database server Application: Windows service built using ...Unanswered | 2 Replies | 82 Views | Created by Rajesh Thareja - Saturday, December 09, 2017 7:20 AM | Last reply by Rajesh Thareja - Saturday, December 09, 2017 9:08 AM -
0 VotesProtecting The Master Database
Hello Forum I'm currently working on data security, so far I've been renaming the sa account, introducing TDE and introducing Backup Encryption. The concern I ...Unanswered | 3 Replies | 66 Views | Created by Anthony C-UK - Friday, December 08, 2017 9:51 AM | Last reply by Tom Phillips - Friday, December 08, 2017 12:56 PM -
0 VotesCreating connection to SQL server by database.CreateConnection()
In my web application we are creating connection like, public void GetData(DataTable dtObj) { dbInternal = ...Unanswered | 4 Replies | 71 Views | Created by h2007 - Friday, December 08, 2017 2:23 AM | Last reply by Will_Kong - Friday, December 08, 2017 9:59 AM -
0 VotesProblem reusing ADO Command objects with SQL2005 through SQLNCLI/SNAC(SQL Native Client)
pADOCtrl; pADO->wIOErrorID = IOErrorId; HRESULT hr; long lngValue; int iErrorCode = SUCCESS; if (NULL == ...Unanswered | 1 Replies | 57 Views | Created by the8thavatar - Thursday, December 07, 2017 4:29 PM | Last reply by Will_Kong - Friday, December 08, 2017 9:15 AM -
0 VotesThe OpenForm action was cancelled
I am working on a really old 2002 Access Database attached to SQL 2000 which I did not create The database is in the process of being recreated but in the meantime, I have to deal ...Unanswered | 2 Replies | 59 Views | Created by jeannecote65 - Friday, December 08, 2017 12:34 AM | Last reply by Xi Jin - Friday, December 08, 2017 7:42 AM -
0 VotesODBC driver 13.1 for Sql Server consumes 100% of CPU time
Hi. We are using ODBC driver 13.1 (version 2015.131.4413.46) asynchronously using event notification method. In cases when execution time of a called ...Unanswered | 1 Replies | 90 Views | Created by Dragan Mihajlovic - Monday, December 04, 2017 12:59 PM | Last reply by Xi Jin - Friday, December 08, 2017 6:01 AM -
0 VotesDTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. Excel Connection Manager
The problem began after the November 10 Windows update was applied. SSIS package failing to acquire Excel connectionProposed | 1 Replies | 44 Views | Created by VivekSh - Thursday, December 07, 2017 2:47 PM | Last reply by Visakh16 - Thursday, December 07, 2017 3:32 PM -
0 VotesSQL Server 2016 STD Edition SP1 CU6 memory not getting released
Dear Team, We are using SQL Server 2016 STD SP1 with CU6 and eventhough memory releasing issue is happens. We have Windows 10 OS and using 8 GB RAM, We have ...Proposed | 4 Replies | 73 Views | Created by Amit Borele - Wednesday, December 06, 2017 12:46 PM | Last reply by Olaf Helper - Thursday, December 07, 2017 7:18 AM -
0 VotesWriting to 2 databases at once
Hello, What is the best way to have one query write to 2 separate instances? Is there an option besides linked servers? Any help ...Proposed | 8 Replies | 111 Views | Created by deescott - Tuesday, December 05, 2017 5:04 PM | Last reply by Erland Sommarskog - Wednesday, December 06, 2017 11:58 AM -
0 VotesA well tested query is not returning all rows
= 'FromDate' AND UpdatedAtProposed | 4 Replies | 96 Views | Created by Jeff13579 - Tuesday, December 05, 2017 3:19 PM | Last reply by Jeff13579 - Wednesday, December 06, 2017 1:06 AM -
0 VotesSql backup failed throug veeam backup
Dear Geniues, We have hyper v Host 2012 R2 AND GUEST OS MACHINE SERVER 2008 r2 standand, we are using veeam for backup, now backup are failing because of vss writer failed, ...Proposed | 3 Replies | 99 Views | Created by Ashru785 - Saturday, December 02, 2017 7:53 AM | Last reply by Olaf Helper - Monday, December 04, 2017 8:52 AM -
0 VotesWhat is flag in sql server ????
Hello :) i want to set all my StoredProcedure ( update , add , delete..... ) in one stored procedure !!!! some one tell me that there are something called Flag !! ...Answered | 4 Replies | 17917 Views | Created by abu5alilo - Wednesday, July 28, 2010 7:02 AM | Last reply by Elango Sengottaiyan - Friday, December 01, 2017 2:17 PM -
32 VotesThe OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.
Hi, I am importing Excel 2007 file into SqlServer 2005 (Sqlexpress). The office 2007 is not installed in the machine. I have downloaded and ...Answered | 30 Replies | 295153 Views | Created by Parmeshthee - Thursday, December 18, 2008 10:28 AM | Last reply by Nukotine - Thursday, November 30, 2017 9:12 AM -
0 Votes2147467259 - [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network...
2147467259 - [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network...please send the salutation.Proposed | 3 Replies | 120 Views | Created by shivahatte - Thursday, November 30, 2017 8:21 AM | Last reply by Will_Kong - Thursday, November 30, 2017 8:53 AM -
0 VotesConnection Timeout and ODBC Native Client
I use ODBC SQL Native Client to connect to SQL Server. When I call SQLDriverConnect to connect to an SQL Server instance and server is down, the function takes 20+ ...Unanswered | 4 Replies | 1697 Views | Created by Dimitris V - Wednesday, June 25, 2014 11:54 AM | Last reply by AndyX - Thursday, November 30, 2017 8:40 AM -
0 VotesLinked Server configuration to availability group listener
I have a need to configure two linked servers that point to availability group listeners the arrangement of which is as follows: Server A.domain1 is the SQL server 2008 R2 ...Unanswered | 2 Replies | 108 Views | Created by Eden Ravenwood - Wednesday, November 29, 2017 11:29 PM | Last reply by Will_Kong - Thursday, November 30, 2017 3:24 AM -
1 Voteshow to find max date in sqlserver
Hi All, I have a table with these datas CreatedOn Jan 24 2017 4:34PM Mar 31 2017 5:34PM Feb 27 2017 4:57PM May 2 2017 ...Answered | 4 Replies | 101 Views | Created by baiju krishnan - Wednesday, November 29, 2017 7:20 AM | Last reply by Erland Sommarskog - Wednesday, November 29, 2017 9:52 PM -
0 VotesSSDT: timeout in create database script
We have recently moved to SSDT for our database management and deployment tool. We are using SqlPackage.exe to deploy the package. We are occasionally getting timeout errors when deploying the ...Proposed | 5 Replies | 179 Views | Created by Mayur Birari - Tuesday, November 21, 2017 5:50 PM | Last reply by Will_Kong - Wednesday, November 29, 2017 9:06 AM -
0 Votesdisabled SSH & TLS V.1 on OS win server 2012 but it affect SQL 2012 & SQL 2014
according to Vulnerabilities my customer has disabled SSH & TLS V.1 on OS win server 2012 but it affect SQL 2012 & SQL 2014 as all services stopped , i read that i have to enable TLS v ...Proposed | 1 Replies | 72 Views | Created by telename - Tuesday, November 28, 2017 3:36 PM | Last reply by Will_Kong - Wednesday, November 29, 2017 6:25 AM - Items 1 to 20 of 12980 Next ›
No announcements
