Stack Overflow
Stack Overflow

Questions tagged [sqloledb]

sqloledb is the legacy OleDB provider for SQL Server that ships with Windows.

26 questions
5
votes
3 answers

Is sqloledb actually using MSOLEDBSQL on Windows Server 2019

A legacy piece of software using the provider "sqloledb.1" via the OleDbConnection Class (System.Data.OleDb.dll) is still working on Windows Server 2019 with TLS1.2. Whereas on Server 2016 or 2012 R2 with TSL1.2 it is not? Windows Server 2016 gets…
RickWeb
  • 1,765
  • 2
  • 25
  • 40
4
votes
1 answer

OPENROWSET fails with "Invalid authorization specification"

I am trying to use OPENROWSET in SQL Server 2008 SP1: SELECT * FROM OPENROWSET( 'SQLOLEDB', 'Data Source=hydrogen;User ID=scratch;Password=scratch;', 'select * from users') OLE DB Provider: SQLOLEDB Connection String: Data…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
2
votes
0 answers

ActiveState Perl and Win32::OLE on Windows 10

I'm trying to figure out what some old Perl that is used for reporting on our websites is doing. I've gotten ActiveState Perl installed and things seem to be working EXCEPT that when the Perl tries to open a database connection. The following error…
Owen
  • 426
  • 5
  • 15
2
votes
1 answer

ADODB, SQLSERVER, SERVERPROPERTY: different types using sqloledb or ODBC driver?

I'm trying to switch one of my VBS scripts from using SQLOLEDB to ODBC driver. So long all works like expected - all but one thing: When fetching SERVERPROPERTY("is_clustered") from an MSSQL instance the resulting value is different using each…
Marcel
  • 21
  • 3
2
votes
1 answer

Use of provider=SQLOLEDB in EF 6 connection string

We have legacy connection strings in use by different sql clients from years past. The connection string has legacy syntax: "Provider=SQLOLEDB". Provider=SQLOLEDB;Data Source=;Initial Catalog=;Integrated Security=SSPI EF6 uses…
Colin
  • 331
  • 3
  • 19
1
vote
3 answers

Error: Row cannot be located for updating. Some values may have been changed since it was last read. On changing provider from SQLOLEDB to MSOLEDBSQL

On change of provider from SQLOLEDB to MSOLEDBSQL in the ADODB connection string, we get the error: -2147217864 Row cannot be located for updating. Some values may have been changed since it was last read. The connection string…
Shah
  • 31
  • 1
  • 5
1
vote
0 answers

Error 80040e21 and DBBINDSTATUS_BADBINDINFO during bind after switching from SQLOLEDB to SQLNCLI or MSOLEDBSQL provider

I'm working on some legacy C++ code that uses OLE DB to connect to a SQL Server database. I need to move from the old SQLOLEDB provider to a more modern one (SQLNCLI, SQLNCLI10, SQLNCLI11, or MSOLEDBSQL). Suposedly, this should be possible by just…
the klaus
  • 81
  • 2
  • 5
1
vote
2 answers

Switching from sqloledb to odbc driver 13 for SQL Server

I want to use Always Encrypted feature introduce in SQL Server 2016 SP1. In order to do that, I need to use the new ODBC Driver 13.1 for SQL Server instead the current one sqloledb. It seems it is breaking my application, for example, when XML is…
gotqn
  • 42,737
  • 46
  • 157
  • 243
1
vote
1 answer

How can I pass DataTable to view as JSON/XML code?

I am new to the .NET environment and trying to write a simple MVC application to read student data and display it to the end user. I have connected to a database using SQLOLEDB, the code of which I have pasted below. The data obtained from the query…
Nikhilesh
  • 21
  • 5
1
vote
1 answer

DB Connection works with SQL Server 2008 R2, but not with SQL Server 2014

I have to update a very old site using classic ASP and SQLOLEDB but the connection to SQL Server doesn't work using SQL Server 2014. It works for my client using SQL Server 2008 R2, but it doesn't work for me using SQL Server 2014. The obvious…
Dzyann
  • 5,062
  • 11
  • 63
  • 95
1
vote
1 answer

Retrieve/create recordset from SQL Server data in Excel vba

I want to access / retrieve / create recordset from SQL Server in Excel vba. I tried following methods but they return an error. Code 1: Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim sConnString As String sConnString =…
curious K
  • 145
  • 5
  • 15
1
vote
2 answers

Database to Array

I am trying to write a VBScript UFT test that gets a set of data from a table (it will be 100 records). I am only going to select one column as you can see from the query below. SELECT TOP 100 l_Name FROM lessee I was able to get the first record…
Krazy Dev
  • 184
  • 3
  • 16
1
vote
1 answer

How to prevent ADO from altering my SQL command text?

i am running a MERGE statement against an SQL Server 2008 R2 database (which is in 2008 compatibility mode). The exact merge statement SQL is irrelevant, but here is an example of a MERGE statement: MERGE Users USING (VALUES…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
0
votes
0 answers

Migrating from SQLOLEDB to MSOLEDBSQL problem with recordset update

During migration from SQLOLEDB to MSOLEDBSQL i am facing some issues with ADO update operation on Recordset. In our system we use old ADO with SQLOLEDB provider and during migration to MSOLEDBSQL it occures that there are some differences during…
Bbb Tttt
  • 1
0
votes
0 answers

How do I "Check each OLE DB status value" as instructed by the error message?

I am troubleshooting a very old web site that uses Classic ASP written in Visual Basic. I've narrowed the problem down to a failure when attempting to open an ADO connection. The code looks like this: On Error Goto 0 Set myConnection =…
John Wu
  • 50,556
  • 8
  • 44
  • 80
1
2