Click here to Skip to main content
14,838,767 members
Home / Discussions / Database
   

Database

 
AnswerRe: GUID or long for MVC site Pin
Eddy Vluggen17-Oct-17 23:38
professionalEddy Vluggen17-Oct-17 23:38 
AnswerRe: GUID or long for MVC site Pin
Gerry Schmitz18-Oct-17 18:32
mveGerry Schmitz18-Oct-17 18:32 
QuestionInserting the values of a Stored Procedure directly into a Table by using the Column names Pin
indian14313-Oct-17 12:59
Memberindian14313-Oct-17 12:59 
AnswerRe: Inserting the values of a Stored Procedure directly into a Table by using the Column names Pin
jschell15-Oct-17 8:15
Memberjschell15-Oct-17 8:15 
GeneralRe: Inserting the values of a Stored Procedure directly into a Table by using the Column names Pin
indian14315-Oct-17 15:03
Memberindian14315-Oct-17 15:03 
GeneralRe: Inserting the values of a Stored Procedure directly into a Table by using the Column names Pin
indian14316-Oct-17 7:25
Memberindian14316-Oct-17 7:25 
GeneralRe: Inserting the values of a Stored Procedure directly into a Table by using the Column names Pin
Eddy Vluggen17-Oct-17 2:14
professionalEddy Vluggen17-Oct-17 2:14 
QuestionOpenRowSet is giving error: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". Pin
indian14312-Oct-17 7:38
Memberindian14312-Oct-17 7:38 
Hi all,

I am trying to read from an Excel file using OpenRowSet, I am getting the above error, as I found in the google I tried the below script.
USE master 
GO 
sp_configure 'show advanced options', 1 
GO 
RECONFIGURE WITH OverRide 
GO 
sp_configure 'Ad Hoc Distributed Queries', 1 
GO 
RECONFIGURE WITH OverRide 
GO 
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1 
GO 
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1 
GO 
EXEC sp_configure 'show advanced options', 1 
GO 
-- To update the currently configured value for advanced options. 
RECONFIGURE 
GO 
-- To enable the feature. 
EXEC sp_configure 'xp_cmdshell', 1 
GO 
-- To update the currently configured value for this feature. 
RECONFIGURE 
GO 

Still no luck it would be very helpful if anybody can help me out, I am also trying different options from online but somehow its not working. Here is the script I am trying.
SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
'Excel 12.0;Database=C:\TestFiles\1-085 Cancelled with Cash-Report 129_2017-10-03.xls;', 
'SELECT * FROM [Sheet1$]')

And the error message full is:
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

This error is happening even if I open VS on the server itself and run this openrowset script and even if I run from the client machine like my local machine, in both cases the openrowset is failing any help can be greatly appreciated friends.

Thanks in advance friends.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."
AnswerRe: OpenRowSet is giving error: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". Pin
Victor Nijegorodov12-Oct-17 9:00
MemberVictor Nijegorodov12-Oct-17 9:00 
GeneralRe: OpenRowSet is giving error: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". Pin
indian14312-Oct-17 11:30
Memberindian14312-Oct-17 11:30 
GeneralRe: OpenRowSet is giving error: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". Pin
Richard MacCutchan12-Oct-17 22:11
mveRichard MacCutchan12-Oct-17 22:11 
AnswerRe: OpenRowSet is giving error: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". Pin
Richard Deeming13-Oct-17 2:10
mveRichard Deeming13-Oct-17 2:10 
QuestionSSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209302 Pin
indian14311-Oct-17 7:36
Memberindian14311-Oct-17 7:36 
QuestionSQL Server store procedure and prevent sql injection Pin
Mou_kol6-Oct-17 8:45
MemberMou_kol6-Oct-17 8:45 
AnswerRe: SQL Server store procedure and prevent sql injection Pin
Richard Deeming6-Oct-17 9:27
mveRichard Deeming6-Oct-17 9:27 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
Mou_kol6-Oct-17 11:30
MemberMou_kol6-Oct-17 11:30 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
Eddy Vluggen7-Oct-17 2:22
professionalEddy Vluggen7-Oct-17 2:22 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
Richard Deeming9-Oct-17 8:59
mveRichard Deeming9-Oct-17 8:59 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
MadMyche22-Nov-17 4:13
mveMadMyche22-Nov-17 4:13 
QuestionImporting the integer values that are coming within " Pin
indian1435-Oct-17 14:14
Memberindian1435-Oct-17 14:14 
AnswerRe: Importing the integer values that are coming within " Pin
jschell6-Oct-17 7:18
Memberjschell6-Oct-17 7:18 
QuestionYou cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office Products installed Pin
indian1432-Oct-17 11:49
Memberindian1432-Oct-17 11:49 
QuestionRe: You cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office Products installed Pin
Richard MacCutchan2-Oct-17 21:53
mveRichard MacCutchan2-Oct-17 21:53 
AnswerRe: You cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office Products installed Pin
jschell4-Oct-17 7:53
Memberjschell4-Oct-17 7:53 
QuestionHow Commonly used are the dotNet Datatables and Datasets? Pin
MarcusCole683328-Sep-17 6:06
professionalMarcusCole683328-Sep-17 6:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.