May 20, 2009 at 2:11 pm
Has any successfully tied a report to fixed width text file on a network? When I report locally, it works fine. The following message is the result of running it from the network:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'BPMF41'. (rsErrorOpeningConnection)
ERROR [HY024] [Microsoft][ODBC Text Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY024] [Microsoft][ODBC Text Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
May 20, 2009 at 3:29 pm
Does the reporting services service account have rights to the location?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 20, 2009 at 3:36 pm
The report service is set to use the local service account. I am also able to navigate to the directory that has the text file without having to put in a windows username and password. I change report service account to the domain admin account to see if that works.
May 20, 2009 at 4:36 pm
I switched the service to use a domain admin account. I know get the following message:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'BPMF41'. (rsErrorOpeningConnection)
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
May 21, 2009 at 3:22 pm
I tried running the SSRS on the domain account and I get the same result. Additionally, I tried using OLEDB but also ended up with the same result.
Does anyone have any suggestions?
June 10, 2009 at 9:35 am
Are you runing on a 64 bit OS?
Do you create your ODBC as a System DSN?
Or did you create one using C:\Windows\SysWOW64\odbcad32.exe
June 10, 2009 at 10:24 am
I could be wrong, but from the error "ERROR [IM002]", it appears that you need to use the correct ODBC connection for the applicaiton.
32-bit applications will only see a DSN created in %WINDIR%\SysWOW64\odbcad32.exe
64-bit applications will only see a DSN created using %WINDIR%\System32\odbcad32.exe
If you installed the 64-bit version of SQL Report Services but created the DSN in the 32-bit %WINDIR%\System32\odbcad32.exe, then you will get that error.
It would be interesting to how if you solved this.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy