Click here to Skip to main content
15,882,705 members
Home / Discussions / Database
   

Database

 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
indian14320-Apr-17 12:58
indian14320-Apr-17 12:58 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
Mycroft Holmes20-Apr-17 14:10
professionalMycroft Holmes20-Apr-17 14:10 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
CHill6023-Apr-17 22:26
mveCHill6023-Apr-17 22:26 
Questioncontext::Context(void) - cs_ctx_alloc() failed Pin
papi2414-Apr-17 1:29
papi2414-Apr-17 1:29 
QuestionRelational Database Design for N dimensional function, I have some problems Pin
User 110609796-Apr-17 3:26
User 110609796-Apr-17 3:26 
AnswerRe: Relational Database Design for N dimensional function, I have some problems Pin
Mycroft Holmes6-Apr-17 11:40
professionalMycroft Holmes6-Apr-17 11:40 
GeneralRe: Relational Database Design for N dimensional function, I have some problems Pin
User 110609796-Apr-17 19:18
User 110609796-Apr-17 19:18 
QuestionCannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" Pin
indian1435-Apr-17 9:53
indian1435-Apr-17 9:53 
Hi,

I am getting the following error when running the sql script

Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.12.0 for linked server (null)
SELECT * 
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
    'Text;Database=\\xxxx\xxx\xxx\DataExchange\xcxcxcx\xxxx\;HDR=Yes;Format=TabDelimited', 
    'SELECT * FROM TIN_Solicitation_Response_Error_01032017.txt')

I tried online reading different articles and answers, I could not get answer for it. Any help like why does it happen, when it happens and any fixes etc can be greatly helpful.

Thanks in advance.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

-- modified 5-Apr-17 17:03pm.
AnswerRe: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" Pin
Mycroft Holmes5-Apr-17 12:46
professionalMycroft Holmes5-Apr-17 12:46 
QuestionWhat is merge join in sql server Pin
Tridip Bhattacharjee23-Mar-17 22:56
professionalTridip Bhattacharjee23-Mar-17 22:56 
AnswerRe: What is merge join in sql server Pin
CHill6023-Mar-17 23:36
mveCHill6023-Mar-17 23:36 
GeneralRe: What is merge join in sql server Pin
Richard MacCutchan24-Mar-17 1:40
mveRichard MacCutchan24-Mar-17 1:40 
GeneralRe: What is merge join in sql server Pin
CHill6028-Mar-17 1:31
mveCHill6028-Mar-17 1:31 
GeneralRe: What is merge join in sql server Pin
Tridip Bhattacharjee27-Mar-17 22:33
professionalTridip Bhattacharjee27-Mar-17 22:33 
GeneralRe: What is merge join in sql server Pin
CHill6028-Mar-17 0:42
mveCHill6028-Mar-17 0:42 
GeneralRe: What is merge join in sql server Pin
Eddy Vluggen28-Mar-17 1:35
professionalEddy Vluggen28-Mar-17 1:35 
QuestionGet all Packages that are failed to execute Pin
indian14321-Mar-17 14:15
indian14321-Mar-17 14:15 
QuestionGETTING EXCEPTION ON JDBC TRANSACTION MGMT --->java.sql.SQLException: Invalid column index:at LINE 8 & 12 Pin
LOKENDRA YADAV10-Mar-17 21:13
LOKENDRA YADAV10-Mar-17 21:13 
QuestionRe: GETTING EXCEPTION ON JDBC TRANSACTION MGMT --->java.sql.SQLException: Invalid column index:at LINE 8 & 12 Pin
Richard MacCutchan10-Mar-17 21:55
mveRichard MacCutchan10-Mar-17 21:55 
AnswerRe: GETTING EXCEPTION ON JDBC TRANSACTION MGMT --->java.sql.SQLException: Invalid column index:at LINE 8 & 12 Pin
LOKENDRA YADAV10-Mar-17 21:58
LOKENDRA YADAV10-Mar-17 21:58 
AnswerRe: GETTING EXCEPTION ON JDBC TRANSACTION MGMT --->java.sql.SQLException: Invalid column index:at LINE 8 & 12 Pin
LOKENDRA YADAV10-Mar-17 22:05
LOKENDRA YADAV10-Mar-17 22:05 
GeneralRe: GETTING EXCEPTION ON JDBC TRANSACTION MGMT --->java.sql.SQLException: Invalid column index:at LINE 8 & 12 Pin
Richard MacCutchan10-Mar-17 22:27
mveRichard MacCutchan10-Mar-17 22:27 
QuestionAccess Application VS .Net Application Access Behind - How to Decide Pin
Member 1304435510-Mar-17 15:52
Member 1304435510-Mar-17 15:52 
AnswerRe: Access Application VS .Net Application Access Behind - How to Decide Pin
Mycroft Holmes11-Mar-17 13:05
professionalMycroft Holmes11-Mar-17 13:05 
GeneralRe: Access Application VS .Net Application Access Behind - How to Decide Pin
Member 1304435511-Mar-17 14:54
Member 1304435511-Mar-17 14:54 

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.