sqloledb is the legacy OleDB provider for SQL Server that ships with Windows.
Questions tagged [sqloledb]
26 questions
0
votes
1 answer
[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).] SSL security error on windows server 2008
I have a problem of SQL connection between two servers. One of the servers where the site code is stored is a Windows Server 2008 and my database is on a Windows Server 2003.
Here is a part of my code :
Set Conn =…
Maxence Svensson
- 11
- 1
- 1
- 2
0
votes
0 answers
sys.sp_reset_connection runs for up to 5 minutes
sys.sp_reset_connection runs for up to 5 minutes on SQL Server 2019 CU13 [SQL1] .
At the same time other SQL Servers [SQL100..SQL200] that have linked server to [SQL1] are timing out:
TCP Provider: An existing connection was forcibly closed by the…
oleg
- 1
0
votes
0 answers
Return Select Queries Using ADO and Provider = SQLOLEDB
My ultimate goal is to run sql queries against sql-server and capture the returned data in a spreadsheet. The following code roughly reflects my current set-up and it works. The design allows me to read sql codes from text files and submit it to a…
user14565129
- 1
- 1
0
votes
0 answers
How to to use SQL Server application role in my connection string
My current application uses very powerful credentials to access the SQL Server back-end database. I want to improve the security in my application by using an application role created.
For example, if I created one called app-role, with a…
Ian Boyd
- 246,734
- 253
- 869
- 1,219
0
votes
3 answers
Excel VBA Userform to SQLOLEDB Connection works Locally but not remotely - Run-time error '-2147467259 (80004005)': [DBNETLIB]
It's been a week of research now and I am still unable to fix this problem.
I have created an Excel VBA User form that inserts data into an SQLOLEDB Connection (SQLEXPRESS 2017) when a CommandButton (Called "Save") is clicked. Locally (localhost) it…
Dave
- 19
- 1
- 6
0
votes
1 answer
VBA runtime error for primary key violation when calling ADO RecordSet.MoveFirst method
I'm using SQLOLEDB provider through ADODB to work with a SQLServer 2012R2 database using VBA running in Excel.
I have no problems navigating through a RecordSet generated from a SELECT statement generated through a RecordSet.Open method.
I…
BioData41
- 862
- 9
- 15
0
votes
1 answer
Command dialect is not supported by SQLNCLI11 provider SQL Server 2012
We are using classic ASP and SQL Server 2012 standard edition.
Our connection string is as below
provider=SQLNCLI11;Data Source=xxx; MultiSubnetFailover=True; Initial Catalog=xxx; User ID = xxx; Password =xxxxxx; DataTypeCompatibility=80; Integrated…
Dream
- 11
- 1
- 1
- 3
0
votes
1 answer
Crystal reports not remapping nvarchar fields that have been resized to nvarchar(max)
I have a Crystal Report which is connected to a SQL Server database via the SQLOLEDB provider.
Some of the columns referenced in the report have been resized in the underlying SQL Server database from a set nvarchar size to nvarchar(max).
On…
Scott McKeand
- 540
- 1
- 4
- 15
0
votes
1 answer
SQL query to sort the ID as ASC and Zip must not dup
I have an SQL statement like this:
SELECT TOP 100 id,
lastname,
firstname,
address1,
city,
state,
zip
FROM leads
WHERE id > 100
ORDER BY…
learnscript
- 49
- 7
0
votes
1 answer
vbscript using variables when connecting to databases
I'm trying to use variables to store my username and password for my database in a password-protected program, pass them as parameters, and then use them in a VBScript as arguments that will send the info to the database. This will prevent the user…
Lou
- 389
- 3
- 20
- 38
-4
votes
1 answer
Using SQLOLEDB in c# or wpf Devexpress
just run into https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0ff7f210-7697-431b-9e6b-0f2e10f4c031/sql-2016-slow-connection-using-server-name-fast-using-127001?forum=sqlsetupandupgrade.
Is it possible to simply bypasse .net in a c# program…
user1644338
- 15
- 1
- 3