How FlexODBC work with MS Reporting Service |
Author |
Message |
|
Posted : 2007-06-05 01:29:43 |
I built a report in MS Reporting Service. It is running fine in Visual Studio development console, but once I deployed to the report server(same server as developemnt server), I got error message as follows:
ERROR [S0000] [FlexODBC][FLEXERR] Found in FILELIST.CFG but can't open data (.DAT) file Root Name: [XNOTEPAD] In DFPATH:
It looks to me more like a security issue. I've set the credential as same credential I'm using in development console. What am I missing?
Thanks,
Louisa
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-06-05 08:20:24 |
The DSN should point to the DATA folder (the directory with the .DAT files) and filelist.cfg should be in the same folder. System users will need read/write permissions to the DATA folder also. |
|
|
|
|
Posted : 2007-06-05 23:28:33 |
I've build IIS application using same DSN setting without problem. The filelist.cfg file and dat file is in the same folder and the user has read/wirte permissions to the folder.
And the report can run within development console but not in report management console. I'm just wondering what extra step is needed for reporting service running properly with this ODBC driver. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-06-06 08:20:37 |
I've found that a user DSN and a system DSN in the same name can confuse some systems. Make sure the System DSN used by FlexODBC is a unique name. |
|
|
|
|
Posted : 2007-06-07 00:33:19 |
Checked... The System DSN is a unique name... not working... what else?
Thanks,
Louisa
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-06-07 09:29:09 |
The data folder must be on the server running the MS Reporting Service (a local folder on the server). It cannot be on a networked drive on another computer. |
|
|
|