Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : How FlexODBC work with MS Reporting ServiceSearch Forum

Forum Home > FlexODBC - ODBC Driver for DataFlex Embedded DBMS > FlexODBC Forum

 New Topic 
 
 Post Reply 
[1]  
 How FlexODBC work with MS Reporting Service 
 Author   Message 
  Louisa 
  
 Group: Members 
 Posts: 10 
 Joined: 2007-05-29 
 Profile
 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

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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. 

  Top 
  Louisa 
  
 Group: Members 
 Posts: 10 
 Joined: 2007-05-29 
 Profile
 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.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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. 

  Top 
  Louisa 
  
 Group: Members 
 Posts: 10 
 Joined: 2007-05-29 
 Profile
 Posted : 2007-06-07 00:33:19

Checked... The System DSN is a unique name... not working... what else?

Thanks,

Louisa

 

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to