oledb Questions
11
I have to move some customer sites from a very old IIS Server to a newer one, and some sites have troubles to work in the correct way. Most of them complain about a failure called:
Microsoft OLE D...
Wrangle asked 11/1, 2013 at 14:47
9
I am trying to run openrowset from MS SQL Server on an Oracle server.
When i execute the following command:
select * from
OPENROWSET('OraOLEDB.Oracle','srv';'user';'pass',
'select * from table')...
Mckibben asked 24/1, 2013 at 11:14
11
I am trying to import data from Excel 2007 (.xlsx) files into SQL Server 2008 using a T-SQL OpenRowset() command with the "Microsoft.ACE.OLEDB.12.0" OLE DB provider, and I'm getting a persistent "C...
Deposit asked 10/1, 2012 at 2:48
12
I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.Data)
...
Oruntha asked 1/11, 2016 at 13:20
9
In an ssis package consists of data flow task,contains
OLEDB source and OLDB Target ..provider is sql native client..This used to run fine ..but now got an error as shown below..
Please tell me how...
Headachy asked 22/8, 2013 at 12:51
6
Solved
Some context: one of the systems I'm working on is a .net 2.0 web application. VB.net for the front end, and SQL Server 2005 for the backend. For a variety of reasons that have been lost to time, t...
Oldenburg asked 23/1, 2009 at 18:18
4
Solved
I am currently running a third-party software suite, which uses SQL Server as its database. I have a second instance of SQL Server running in a different location, and some apps that I am building ...
Chigoe asked 24/7, 2009 at 18:25
22
Solved
I created a windows application developed in .NET 3.5 in a 32 bit Windows 2008 server. When deployed the application in a 64 bit server it shows the error "Microsoft.Jet.OLEDB.4.0' provider is not ...
Juicy asked 2/1, 2010 at 13:52
6
Solved
I know this topic is done to death but I am at wits end.
I need to parse a csv. It's a pretty average CSV and the parsing logic has been written using OleDB by another developer who swore that it ...
Hornback asked 25/7, 2011 at 8:48
8
I know that there are different ways to read an Excel file:
Iterop
Oledb
Open Xml SDK
Compatibility is not a question because the program will be executed in a controlled environment.
My Requi...
Baste asked 21/10, 2012 at 8:36
4
Solved
There was a communication link error while I was using SQL Server Native Client 10 in an SSIS Data Flow component.
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has
occurred. Error c...
Photodisintegration asked 6/2, 2014 at 13:7
14
Solved
I have an SSIS package which reads an Excel File (Data Flow Source) and transfer the data to SQL Server using OLEDB Destination Data Flow Item. The OLEDB Connection Manager used for the destination...
Cudweed asked 14/4, 2009 at 15:27
8
Microsoft Excel allows import of data from "Other Sources". One of the options is to use an OLE DB provider.
How to get a list of available OLE DB providers?
8
Solved
I have a 64 bit windows 7 and SQLServer 2008 R2 (64 bit)
I follow the instructions that are here to import excel file to sql server but in figure3 section of that post when I try to access excel f...
Sherrellsherrer asked 30/3, 2012 at 12:36
4
I'm trying to do an insert in oledb(ms access database)
the field called objectdate is date/time
the code i use to add the parameter is this, but i'm getting error.
OleDbParameter objectdate = n...
Capercaillie asked 23/9, 2011 at 0:8
6
Solved
2
Solved
I'm trying to execute a stored procedure via SSIS
Error: 0xC0207014 at PO Header, OLE DB Source [59]: The SQL command
requires a parameter named "@SessionID", which is not found in the
paramet...
Budge asked 27/5, 2019 at 9:56
6
Solved
I know that is this question has dozen of answers and posts, but nothing works for me.
I have my MVC 5 application and I deploy it to the IIS 7.5 to my server. Application runs great, everything ...
Bithynia asked 5/12, 2013 at 21:41
5
Solved
I'm using this code to open an excel file and save it in a DataGridView:
string name = "Items";
string constr = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=" + Dialog_Excel.FileName.ToString(...
Satyriasis asked 30/4, 2013 at 6:31
6
Solved
Our client recently upgraded from TLS 1.0 to TLS 1.2 and after this our software cannot connect with SQL server. It uses OLE DB provider for connecting to SQL server.
Below is the error which is re...
Handful asked 2/9, 2017 at 7:56
5
Solved
I have been trying to find a solution to this problem but so far nothing worked.
private void Insert()
{
string ConnectionStringAccess = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=###Jet OLED...
3
Solved
I'm developing a small application that will simplify logging, it does so by adding some inputs to an MS Access database through OleDB.
let private conn = new OleDbConnection(connectionString)
l...
2
Solved
Is it possible to write data using Oledb into a common excel ?
There are no table structure or anything, it's a user document.
When I tried, i had always an OleDbException
"INSERT" query reply ...
7
Solved
I have the following code :
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\db\suc.xls; Extended Properties=""Excel 12.0;HDR=YES;""";
// Create Connection to Ex...
7
Solved
I have an Excel file with data in it. I want to write some specific rows of it to another Excel file that I created by code. By the way I have the indexes of these rows in a list. How can i do that...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.