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 | 91120 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 | 46783 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 | 83925 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
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 ...Unanswered | 8 Replies | 110 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 | 5972 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 ...Proposed | 5 Replies | 171 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 | 165 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 | 127 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 | 9393 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 | 112 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 | 130 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 | 185 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 | 181 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 | 417 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 | 255 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 | 176 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 | 208 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 | 141 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 | 186 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 | 211 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 | 208 Views | Created by MB82-20 - Friday, September 15, 2017 2:55 PM | Last reply by Xi Jin - Monday, September 18, 2017 1:29 AM -
0 Votes
Insert entities from SQL to table storage
Hello guys, can I write statement through SQL Server to writing entities straight to table storage account? There are syntaxs on SQL Server 2014/2016 to interact ...Unanswered | 1 Replies | 240 Views | Created by mykernel - Sunday, September 17, 2017 12:42 PM | Last reply by Martin.Cairney - Monday, September 18, 2017 12:44 AM -
0 Votes
Connect SQL with API
Hello, I am trying to connect site (Poloniex) with SQL Studio manager via API key but without success. Does anybody can assist me on ...Unanswered | 4 Replies | 241 Views | Created by tocy - Friday, September 15, 2017 5:55 PM | Last reply by Erland Sommarskog - Sunday, September 17, 2017 6:14 PM - Items 1 to 20 of 12920 Next ›
No announcements
