oledb Questions
6
I' m using a Windows Forms application to export data to excel.
Application is built both x64 and x86.
So both version of Microsoft Access Databse Engine must be installed to work the application...
Animation asked 29/2, 2016 at 14:3
1
Solved
Short Version
Trying to pass the datetime value 12/30/1899 to SQL Server, fails with Invalid date format - but only for the native client drivers, and only in DataTypeCompatiblity mode.
Long Versio...
Cuellar asked 15/3, 2020 at 16:39
3
Solved
I use the following from within some excel procedures to establish a connection to our database.
Private Const strConn As String = _
"PROVIDER=SQLOLEDB.1 ..."
Sub OpenConnection()
Set cn = Cre...
2
Solved
Pretty new to BI and SQL in general, but a few months ago I didn't even know what a model is and now here I am...trying to build a package that runs daily.
Currently running this is Excel via Pow...
Farthermost asked 18/1, 2020 at 21:8
7
I've having a problem with a VBScript connecting to an access MDB Database. My platform is Vista64, but the majority of resources out there are for ASP/IIS7.
Quite simply, I can't get it to connec...
9
Solved
I have users that name their sheets all sorts of crazy things, but I want to be able to get the first sheet of the Excel document regardless of what it is named.
I currently use:
OleDbDataAdapte...
3
I've been fighting with OleDbConnection for a while now trying to get it to not cache. Basically I am accessing a shared Access database, which is being written to from another application, and the...
Suttles asked 28/6, 2012 at 10:45
3
I am getting error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." on my testing servers. So My Question is :
i) Can i add reference for "'Microsoft.ACE.Oledb.12....
Arbil asked 22/8, 2013 at 12:26
10
Solved
I have a C#/.Net job that imports data from Excel and then processes it. Our client drops off the files and we process them. I don't have any control over the original file.
I use the OleDb librar...
4
Solved
This query produces an error No value given for one or more required parameters:
using (var conn = new OleDbConnection("Provider=..."))
{
conn.Open();
var result = conn.Query(
"select code, nam...
2
I have an SSIS package with a OLE DB connection manager to 'SQL Server 1', as well as flat file managers that come from the D disk of the local machine.
The package basically retrieves data from ...
Edholm asked 9/4, 2019 at 16:10
1
At my server, I am using SqlClient to connect to SQL Server, Oledb for old apps connecting with Oracle and ODP.NET for new apps connecting with Oracle.
I am seeing in perf counters:
.NET Data P...
Eng asked 14/2, 2017 at 8:57
3
Solved
I need to programatically check the refresh date on a number of OLEDB data connections in Excel to SQL tables and views. They're all configured the same way and use the same connection string, and ...
1
Solved
After creating an xlsx file with the following custom query (loading data from the jsonplaceholder service from typicode.com)
let
Source = Json.Document(Web.Contents("https://jsonplaceholder.typi...
Tull asked 21/11, 2017 at 12:12
3
I am writing a query to access what is in Excel sheet (2013 - 32 bit) and display that as a table in SQL Server 2014 SP2 64 bit. And I get this error:
The OLE DB provider "Microsoft.ACE.OLEDB.15...
Preussen asked 29/9, 2016 at 15:3
4
Solved
I have an excel file that contains a series of OLEDB connections leveraged by several pivot tables. I would like to create a VBA function that removes all password from that several connection stri...
Ply asked 31/10, 2018 at 22:37
1
I have a function that attempts to clear every connection string from every connection, it works as follows:
Public Sub RemovePasswordByNamePrefix()
Dim w As Worksheet
Dim qt As QueryTable
Dim c...
Stasiastasis asked 31/10, 2018 at 22:9
1
I have a 32 bit Windows 7 machine.
I am trying to access an excel sheet by creating a linked server in SQL Server 2012.
Below is my error.
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider &...
Derogatory asked 22/7, 2013 at 14:1
4
Solved
i try to get some Data from a Access Database via OleDB in a DataSet.
But the DataSet is empty after the Fill() method. The same statement works and return 1 row when i trigger them manually in D*....
Ledaledah asked 30/6, 2011 at 8:53
11
Solved
I was reading a MS Excel help article about pivotcache and wonder what they mean by OLE DB and ODBC sources
...You should use the CommandText
property instead of the SQL property,
which now ex...
11
Solved
I'm using OleDb to read from an excel workbook with many sheets.
I need to read the sheet names, but I need them in the order they are defined in the spreadsheet; so If I have a file that looks l...
Lifeordeath asked 22/7, 2009 at 11:42
6
Solved
I have an Excel worksheet I want to read into a datatable - all is well except for one particular column in my Excel sheet. The column, 'ProductID', is a mix of values like ########## and n########...
3
Solved
I have scoured the net, and found many people asking this, yet none have fixed my answer.
I have a Connection Class, and a Method that uses that Class in a page.
DataConn.cs
public static OleDbC...
2
Solved
In a SSIS ETL transformation I'm trying to load a certain .xls file. I have several identical files with similar schemas, and all of them work correctly. However this one file throws the "External ...
3
Solved
I am accessing an MS Access 2007 database through C#, and I keep getting an exception whenever I try to read an empty cell.
Specifically, I am trying to read a "Date/Time" cell that may or may not...
© 2022 - 2024 — McMap. All rights reserved.