Tagged Questions

COM based database access API bundled into Windows by Microsoft.

learn more… | top users | synonyms

1
vote
1answer
51 views

Oracle OLEDB Connections hang in SQL Server: Can I restart Instance?

There is a killed/rolled back query on this instance that was originally attempting to execute a SELECT on a remote Oracle Server via OLEDB. This query was running for over two days before it finally ...
0
votes
0answers
71 views

Problem with EXEC MyLinkedServer…sp_executesql within transaction

I rather clueless about this so any help is appreciated. We have got a stored procedure that is running within a transaction. The stored procedure is called from a .NET program (via normal ADO.NET). ...
0
votes
1answer
49 views

Cannot connect with OLE DB

OLE DB connection... Can anyone suggest me on this. Authentication with windows security works in 2012-2005 "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False; ...
1
vote
1answer
199 views

What does it mean? ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Q 1: Whenever an Oracle SP wants to return error code/message, it fails returning below exeption: OLE DB provider "OraOLEDB.Oracle" for linked server "ORASRV" returned message "ORA-06502: PL/SQL: ...
0
votes
0answers
338 views

The OLE DB provider “SQLNCLI10” for linked server “(null)” indicates that either the object has no columns or

When I run the following script its run fine merge RDW_RRR_MAIN_ST.dbo.tmps AS dest USING (select * from RDW_RRR_MAIN_ST.dbo.tmprole cross join RDW_RRR_MAIN_ST.dbo.tmpscreen) as src1 on ...
0
votes
1answer
362 views

Invalid date format in SSIS

I am using BIDS to export data from Oracle to SQL server. I am using OLEDB source and destination. I have around 6 datetime fields in ORACLE out of which two fields give no problem while 4 fields give ...
1
vote
0answers
112 views

Link up an ms access database to SQL Server 2008 R2?

I've installed the OLE DB Provider for JET by downloading this and installing it. I closed and reopened Microsoft SQL Studio, and connected to my SQL Server Instance. In <instance-name> ...
0
votes
1answer
470 views

Selecting from an excel spreadsheet into SQL Server table

This question has been asked before but I tried giving full admin rights to the SQL Server user on C:\temp\ folder location (I am using Windows authentication into SQL Server Express). So for the ...
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
1answer
393 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
0answers
170 views

SSIS Data Flow Task Slows Down [closed]

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
2answers
9k 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
399 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', ...
1
vote
1answer
668 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
3k 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=" & ...
2
votes
1answer
451 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
2k 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 ...
2
votes
1answer
345 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 ...