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 | 7916 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 | 53189 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 | 96336 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
SQL 2016 - Oracle OLEDB (ODTwithODAC122011) - Cannot Create Instance - Access Denied
Hello All, Any assistance is appreciated and thank you! Environment: - Host: Windows 2016 ...Unanswered | 3 Replies | 67 Views | Created by MarkCovi - 21 hours 22 minutes ago | Last reply by Rachel_Wang - 10 hours 57 minutes ago -
0 Votes
The format used to define the new variable for Invoke-Sqlcmd cmdlet is invalid. Please use the 'var=value' format for defining a new variable
&1 | Tee-Object -Variable statistics The = signs in the variable are causing the error. Is there a way to escape the = signs ...Unanswered | 3 Replies | 226 Views | Created by net_tech - Thursday, October 3, 2019 2:06 AM | Last reply by Sabrina Zhang - Monday, October 7, 2019 5:51 AM -
0 Votes
error occurs while executing oracle procedure (package) using mssql dblink.
Hi I hava a urgent question~ When I exectue a Procedure in SQL Server directly to execute oracle proceudre... ...Unanswered | 4 Replies | 169 Views | Created by call oracle procedure using mssql dblink - Friday, October 4, 2019 7:25 AM | Last reply by Soumen Barua - Saturday, October 5, 2019 3:08 AM -
0 Votes
SQL JDBC upgrade from v6.0 to v7.2 causes java.lang.NullPointerException in some stored procedure returned recordsets
I am developing a java application onWindows 10 using Eclipse Oxygen and SQL JDBC v7.2 and java 1.8 update 202. My code runs fine when I use SQL JDBC v6.0 (sqljdbc42.jar Jan 2017 and ...Answered | 8 Replies | 811 Views | Created by 4Forest - Friday, February 22, 2019 3:40 PM | Last reply by 4Forest - Thursday, October 3, 2019 9:47 PM -
0 Votes
Proper connection string format to access Azure SQL db using ADODB with Excel VBA
After 100 variations or so, and still unable to get the connection open, can someone please guide on the proper format to open and ADODB connection in Excel VBA for Azure SQL ...Unanswered | 2 Replies | 155 Views | Created by dinotom - Tuesday, October 1, 2019 2:51 PM | Last reply by Rachel_Wang - Wednesday, October 2, 2019 2:17 AM -
3 Votes
trying to update to odbc 17.4 but fails because it can't find the 17.3 media
next -> accept -> "client components" next -> Install. it runs for a bit then gives me a "feature you are trying to use is on a network resource that is ...Answered | 2 Replies | 201 Views | Created by Sean Hawkes (ADM) - Monday, September 30, 2019 9:39 PM | Last reply by Sean Hawkes (ADM) - Tuesday, October 1, 2019 4:10 PM -
0 Votes
Error 0x80004005 when open recordset via ADO
Hi, I am using Visual C++ 2008 + ADO to connect to a SQL Server instance on local computer. After connecting to SQL Server, my program will do lengthy tasks which normally takes ...Answered | 17 Replies | 623 Views | Created by tempc - Tuesday, September 17, 2019 1:35 PM | Last reply by tempc - Monday, September 30, 2019 10:08 PM -
0 Votes
Insert query not working with mssql driver
Hi, I am trying to connect to mssql server 2014. I am using a proxy server in between to connect to the same. The 'SELECT' , 'UPDATE' , 'DELETE' query are ...Proposed | 16 Replies | 405 Views | Created by Vinit697 - Monday, September 23, 2019 10:28 AM | Last reply by Tom Phillips - Monday, September 30, 2019 11:24 AM -
0 Votes
We have 2 SQL server 2016 servers that are having communication issues
We have 2 SQL server 2016 servers that are having communication issues when setting up Availability groups and replication. The servers can ping each other and can be connected using a UDL file and an ...Unanswered | 1 Replies | 224 Views | Created by Rbcheath - Friday, September 27, 2019 2:59 PM | Last reply by Sabrina Zhang - Monday, September 30, 2019 6:35 AM -
0 Votes
Repeat Invoke Parameterized Query will Cause "Multiple-step OLE DB operation generated errors"
ConnectionString = _bstr_t(L"Provider=sqloledb;Data Source=MYPC;Integrated Security=SSPI;"); Conn1->Open( _bstr_t(L""), ...Proposed | 9 Replies | 400 Views | Created by tempc - Sunday, September 22, 2019 8:17 AM | Last reply by Erland Sommarskog - Friday, September 27, 2019 10:59 AM -
0 Votes
foreign key/table constraint
We import data from devices. The first thing that is done is to insert into a header table. This table holds the serial number of the device and for each data import creates a ...Answered | 10 Replies | 296 Views | Created by Joe Garry - Thursday, September 26, 2019 5:42 PM | Last reply by Joe Garry - Thursday, September 26, 2019 11:56 PM -
2 Votes
Need to count characters and group by that result
Noob here. I have a large table and I need to count the number of characters in a single column Uwhere records have a corresponding value in another column Yand group by ...Proposed | 6 Replies | 340 Views | Created by Mateo Luis - Friday, September 20, 2019 3:27 PM | Last reply by Sabrina Zhang - Thursday, September 26, 2019 8:29 AM -
0 Votes
Command line truncate passwords that contain character '&'. Windows Server 2012 R2.
I have an application that passes the password to a batch script to invoke the BCP utility, the password contains the character '&' which is causing the command line to truncate it (up to the ...Proposed | 2 Replies | 264 Views | Created by Amine S - Wednesday, September 25, 2019 3:52 PM | Last reply by Erland Sommarskog - Wednesday, September 25, 2019 9:04 PM -
3 Votes
Microsoft ODBC driver for SQL (version 13)
Have an old VB6 app using Microsoft ODBC driver for SQL v13 to connect to our sql server (v2016). Using the default connect string from VB6, it appears to want to use named ...Answered | 3 Replies | 262 Views | Created by scott_m - Tuesday, September 24, 2019 4:59 PM | Last reply by Erland Sommarskog - Tuesday, September 24, 2019 9:09 PM -
0 Votes
Data Moving from Column -1 to 0 "Randomly"
We are having an issue with our software where we have a client log in and change a name setting for data, which "randomly" switches the data from column -1 to column 0. This causes the data ...Proposed | 2 Replies | 216 Views | Created by SaraReece181 - Tuesday, September 24, 2019 7:17 PM | Last reply by Erland Sommarskog - Tuesday, September 24, 2019 9:07 PM -
0 Votes
Linked server creation failed with ODBC provider
Hi, I am trying to create a linked server from one SQL Server to another with 'ODBC Driver 13 for SQL Server' by ODBC data source. But it is getting failed. Below is screen shot. ...Unanswered | 3 Replies | 240 Views | Created by arifulhaq - Monday, September 23, 2019 12:18 PM | Last reply by Sabrina Zhang - Tuesday, September 24, 2019 6:09 AM -
0 Votes
How do I select null
Hi everyone, I use select * from table where column =null to select null value . And then I get an error . Could you help ...Answered | 3 Replies | 258 Views | Created by sanyouss - Monday, September 23, 2019 1:29 AM | Last reply by sanyouss - Tuesday, September 24, 2019 2:44 AM -
1 Votes
Linked server provider version
Hi, How do I tell if the version of the provider listed in SQL server correspond to what is installed in the operating system ...Proposed | 5 Replies | 497 Views | Created by agepeder - Thursday, September 5, 2019 10:57 AM | Last reply by Rachel_Wang - Monday, September 23, 2019 9:46 AM -
0 Votes
Using SSMS... without a server
This is probably a silly question (the clue is on the name), but is it possible to use SSMS without a server? I have SSMS 2008 installed on my laptop to access data on multiple ...Proposed | 5 Replies | 609 Views | Created by jackthecat - Friday, August 30, 2019 8:34 PM | Last reply by Rachel_Wang - Monday, September 23, 2019 9:40 AM -
0 Votes
Accesses with expired date
Hello, Is there any way to grant limited accesses to users for a day or a week. I mean, make it automated, like create role with specific permissions and, when it is needed, to ...Answered | 19 Replies | 604 Views | Created by MariamG - Monday, September 9, 2019 8:06 AM | Last reply by MariamG - Monday, September 23, 2019 5:59 AM - Items 1 to 20 of 13581 Next ›
No announcements
