COM based database access API bundled into Windows by Microsoft.
2
votes
1answer
174 views
Debugging a SSIS OleDbCommand
I have an OleDb Command component in a dataflow that does an update(yes, I'm aware of the performance implications).
Running the pack in BIDS shows me that the component is being reached and runs ...
2
votes
1answer
221 views
Jet OLEDB driver refuses to open a linked table where the original has a lock - any way to force this?
I have a requirement to read reference data from several access databases for an ETL job. The data owners have produced a file with a series of linked tables that consolidates them all into one ...
2
votes
1answer
820 views
SSIS PL/SQL task hangs with message “Multiple-step OLE DB operation generated errors.”
I've configured a Microsoft SQL Server 2008 R2 SSIS package with an Execute SQL Task to run a PL/SQL query on an Oracle 10.2 database.
The Execute SQL Task (named "SQL Update MY_STATUS flag") is ...
1
vote
1answer
385 views
Connect to SQL Server using OLEDB or ODBC?
We have a desktop application written in Visual Basic .NET. One our clients needs to use ODBC instead of OLEDB to connect to the SQL Server 2008 R2 Database. The company has several databases ...
1
vote
2answers
583 views
Import Excel Table to SQL Server - with date column
I'm trying to import a excel table that has a column with dates. My query works without the column date. I'm using ODBC to import.
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ...
1
vote
1answer
49 views
Get all the database in db2 through web
I would like to get all the databases available on a db2 instance from a C# application.
The CLP command to be used is LIST DB DIRECTORY.
How can I fire this command from C#? Is there another select ...
0
votes
1answer
837 views
Cannot initialize the data source object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server
This is going to be a long story I'm afraid ;-(
I have to read some text-files into a SQL database. This database is on a SQL 2008 R2 x64 database server. I want to use a linked server so after some ...
0
votes
0answers
52 views
Transfer tables from multiple servers into one single server [duplicate]
I have to migrate similar tables present in multiple different servers (30+) into our new server using SSIS package. What would be the right approach towards this?
I was successfully able to transfer ...
0
votes
0answers
59 views
SSIS Data Flow Task Slows Down
I am trying to transfer data from one table to another in the same database using SSIS. It seems to go fine (I can see the record count going up) until it gets to about 30 million records, then it ...
0
votes
0answers
35 views
Trouble with ACE.OleDB.12.0 connection across domains
Here is the situation:
I have two servers, for simplicities sake we'll call them database-server and website-server.
The database-server is to hold an Access database that we're using during ...
0
votes
0answers
132 views
Getting UserInfo data out of Sharepoint via OPENROWSET
The query below returns most of the data from the SharePoint list that my customers want:
SELECT *
FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0',
...
