Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SRS 2005, Excel, ODBC, "Cannot Create Connection.."

Status
Not open for further replies.
scrimej

scrimej

Programmer
Dec 22, 2004
17
US
I am using an Excel ODBC connection to create a SRS 2005 report with a dataset resulting from a query of data in the excel file.

My problem is that if either
a) the excel file is open or
b) the development environment is open,
I get a message in the live environment that it cannot create a connection to the data source.

I have specified ReadOnly as both 0 and 1 in the connection string and still cannot run the report without a data contention error.

Anyone know if it is possible to use excel as a data source and not run into problems if the spreadsheet is open by another user?

Thanks,
Jeremy
 
Status
Not open for further replies.

Similar threads

Colin Burton
  • Locked
  • Question
SSRS - access to "master" Sys function xp_fileexist
Replies
1
Views
784
fredericofonseca
fredericofonseca
tarikqazza
  • Locked
  • Question
SSRS server connection to datasource fail randomly ( sql server 2016)
Replies
0
Views
726
tarikqazza
tarikqazza
Tom_2023
  • Locked
  • Question
SSRS wrapping text in Excel
Replies
0
Views
791
Tom_2023
Tom_2023
kjv1611
  • Locked
  • Question
Create a "Jeopardy board" out of SQL Results - I'll explain
Replies
2
Views
780
kjv1611
kjv1611
DaveAd
  • Locked
  • Question
Additiona colum in excel download
Replies
1
Views
91
simian336
simian336

Part and Inventory Search

Sponsor

Back
Top