No announcements
-
38 VotesMicrosoft is Aligning with ODBC for Native Relational Data Access - FAQ
For more information please see our blog post ...Sticky | 32 Replies | 91131 Views | Created by Amina Saify - MSFT - Tuesday, August 30, 2011 1:46 AM | Last reply by Narinder Sharma - Friday, January 29, 2016 1:02 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 | 46787 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 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 | 83939 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 Votes
Slow data extraction in Pivot Excel
Good evening, I have some query (view) that run acceptably in SQL Server Management Studio. They also run almost without ... -
0 Votes
Cannot add more than one table in the user securables
Hello, I have a user who is part of an AD Admin group (deconadmin). The database user security settings are as follows General : User Type (window ... -
0 Votes
Application connected to Online SQL Server
Hi, we do have a desktop application which is connected to an online database. We are renting the database server and we pay monthly for their service. I would love to host our application locally ...Answered | 7 Replies | 117 Views | Created by Dikong42 - Friday, October 06, 2017 5:09 PM | Last reply by Erland Sommarskog - Saturday, October 07, 2017 9:14 AM -
0 Votes
how to get the oracle session id using ole db API
Simply put, I am trying to track down a problem with leaked db connections that use a connection pool. We have a multi-threaded app which is using the same user id and password for database ...Answered | 3 Replies | 5975 Views | Created by mab98122 - Monday, May 17, 2010 9:31 PM | Last reply by Prof.hu - Thursday, October 05, 2017 5:03 PM -
0 Votes
Linked Server shows local databases in catalog rather than remote databases
We use linked servers between all 15 of our SQL Servers regularly and successfully. We use a local sysadmin account that is the same on all 15 servers to connect with. We added a ...Answered | 5 Replies | 176 Views | Created by mschelstrate - Friday, September 29, 2017 10:01 PM | Last reply by Erland Sommarskog - Tuesday, October 03, 2017 9:11 PM -
0 Votes
How to increase 1 in a query?
I want the rowNumber column in the query auto increases 1 each row. For example Select rowNumber, Column1, Column2 from Table1 Thanks.Answered | 6 Replies | 167 Views | Created by danyeungw - Friday, September 29, 2017 11:22 PM | Last reply by danyeungw - Monday, October 02, 2017 9:55 PM -
2 Votes
how to get data base file from a project .
i have made a project in visual studio ,i also attached a data base backup file with that project . due to some reason i reinstalled ...Unanswered | 4 Replies | 131 Views | Created by mwaqasali - Sunday, October 01, 2017 5:32 PM | Last reply by mwaqasali - Monday, October 02, 2017 10:58 AM -
0 Votes
How to get "System.Data.SqlClient" back in reference/assembly registry?
I am using C# to develop an app and I need a connection to a SQL server database. However, I am not able to add the reference "System.Data.SqlClient" to the C# app ...Proposed | 5 Replies | 9402 Views | Created by ILoveMicrosoftMSDN - Thursday, December 13, 2012 7:59 PM | Last reply by navyjax2 - Friday, September 29, 2017 7:36 PM -
0 Votes
connection via mail
Good day, i don not know if this is the right forum for this question is it possible to make updates and insert etc to tables in a server via email and if yes can ...Discussion | 1 Replies | 113 Views | Created by zubenubie - Friday, September 29, 2017 4:35 PM | Last reply by Tom Phillips - Friday, September 29, 2017 6:34 PM -
0 Votes
Unable to load communication module. Driver has not been correctly installed. Client unable to establish connection
For some strange reason, on installation of Citrix XenApp 7.15 on Windows Server 2016. I'm getting below error. I have VB6 code that uses DAO to connect to SQL ...Unanswered | 1 Replies | 135 Views | Created by NandaG - Thursday, September 28, 2017 5:05 AM | Last reply by Olaf Helper - Thursday, September 28, 2017 5:45 AM -
0 Votes
incompatible in the add operator error with encrypted columns
Hi I'm getting the following error message from a query within a stored procedure, when I execute this using SSMS (ver 17.2): Msg 402, Level 16, State 1, Line ...Answered | 2 Replies | 187 Views | Created by nik.jethwa_81 - Tuesday, September 26, 2017 2:21 PM | Last reply by Will_Kong - Wednesday, September 27, 2017 6:58 AM -
1 Votes
bcp operations in ODBC tracing log
While debugging bulk copy functions in ODBC driver tracing log (enabled from odbcad32.exe, trace tab), I could not find any keyword about bcp. What are the bcp operations corresponding T-SQL? For ...Answered | 2 Replies | 182 Views | Created by Jill Chen - Thursday, September 21, 2017 7:18 AM | Last reply by Jill Chen - Monday, September 25, 2017 3:33 AM -
0 Votes
SQL Server Driver doesn't set @@TRANCOUNT to 1 when AUTOCOMMIT is off.
Hello, O/S : Winodws 2008 R2 SQL Native Client driver version: 2011.110.3000.00 SQL Server driver version: ...Answered | 11 Replies | 420 Views | Created by Mukesh Singh - Tuesday, September 05, 2017 8:27 AM | Last reply by Dan Guzman - Thursday, September 21, 2017 10:42 AM -
0 Votes
Access LOB data using SNAC driver
Hi, I have a table with 5 columns CREATE TABLE t1 (c1 int, c2 varchar(20), c3 varchar(20), c4 varchar (max), c5 int); c4 is ...Unanswered | 3 Replies | 259 Views | Created by LEFT OUTER JOIN without a JOIN condition - Sunday, September 17, 2017 5:59 AM | Last reply by LEFT OUTER JOIN without a JOIN condition - Thursday, September 21, 2017 4:46 AM -
0 Votes
SQL Connectivity Problem
We have apps (very old) developed in Visual Studio 6 (vb6) and are working together with SQL 7, 2000 and 2008. When we upgraded to SQL 2014, these apps no longer works. What seems ...Proposed | 4 Replies | 177 Views | Created by Myk Fariolen - Wednesday, September 20, 2017 6:22 AM | Last reply by Erland Sommarskog - Wednesday, September 20, 2017 10:30 AM -
0 Votes
Always Encrypted Scenario
I have a stored proc which retrieves SSN from a table (which has SSN Column encrypted) and then inserts it into a different table which doesn't have SSN Column encrypted. If I ...Proposed | 5 Replies | 209 Views | Created by vai2000 - Tuesday, September 19, 2017 2:10 PM | Last reply by Will_Kong - Wednesday, September 20, 2017 3:15 AM -
0 Votes
Getting Title, Issued, Affected OS and Products and Severity information.
Hello, My team is working on a project that needs to obtain KB Title, Issued, Affected OS and Products and Severity. I tried a few however none of them can satisfy the ...Unanswered | 1 Replies | 142 Views | Created by KeJiaLi - Tuesday, September 19, 2017 3:12 PM | Last reply by Tom Phillips - Tuesday, September 19, 2017 4:36 PM -
0 Votes
PLEASE HELP!!
Hello, I had a working SQL server and had connectivity from all workstations (Using a Billing program called Lytec) I changed ISP over the weekend to Verizon Fios ...Unanswered | 3 Replies | 187 Views | Created by mikefromfilly - Monday, September 18, 2017 8:04 PM | Last reply by Xi Jin - Tuesday, September 19, 2017 5:43 AM -
0 Votes
[OData Source [2]] Error: System.Net.WebException: The operation has timed out
while execute SSIS, I'm receiving Timeout error to get project data from MS Online ...Unanswered | 1 Replies | 217 Views | Created by Sathiyagu - Monday, September 18, 2017 6:36 PM | Last reply by Xi Jin - Tuesday, September 19, 2017 2:53 AM -
0 Votes
How to combine 2 results into one?
I have below two queries and want to combine into one by applying group by: Below are the 2 columns results from a single ...Answered | 3 Replies | 210 Views | Created by MB82-20 - Friday, September 15, 2017 2:55 PM | Last reply by Xi Jin - Monday, September 18, 2017 1:29 AM - Items 1 to 20 of 12922 Next ›
No announcements
