Problem with data sources...

[KCcasey]

Hi gurus...

anyone come across this one yet?? I'm querying an ODBC data source for my report. The report runs fine in V.S., but once I import the report into report manager (hosted on a separate machine) the report fails to generate with the following error:

[blue]An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'CO1 PO Purchase Order Headers'. (rsErrorOpeningConnection) Get Online Help
ERROR [S1000] [Flex/ODBC][FLEXERR] Required file COLLATE.CFG missing from DFPATH Cant Open filelist.cfg ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).[/blue]

I've tested that the report server service logon account has the required permissions for the datasource, and I can even query the DSN from the report server machine using SQL Q.A.

I'm at a loss!!!

Anybody got any ideas for me??

Thanks in advance,

Casey.

 

[Catadmin]

Check your ODBCs on the server with Report Manager. It can't access and ODBC that doesn't exist. Even if you're using shared data sources, that's not the same thing on the machine as the actual ODBC connection. If it's not there, you need to create it as it exists (same name and everything) on your development box.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[KCcasey]

Thanks for the input, but the ODBC datasource setups between dev' server and prod' server are identical... the only real difference is the account being used to run the report manager service. I've given the account full control over the datasource path and files, and restarted the service.

My only thought is that maybe the account hasn't picked up the privileges somehow...???? Unfortunately I stuck with the account...

Any other ideas??

Kind Regards,

Casey.

 

[Catadmin]

Required file COLLATE.CFG missing from DFPATH Cant Open filelist.cfg

What is this Collate.cfg file? And what is DFPATH?

Just yesterday, I had a similar error message, without the missing file part, because I forgot to grant the login account Exec permissions on my stored procedure. Have you verified SQL table & SP permissions yet? Can the new account do whatever SQL is required from SQL Server?

The best way to test this is to open up a QA window under that account, past your dataset into it and see if it runs.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[ookete]

It sounds to me like less of a permissions problem and more of a driver/file problem. Does your server have all the updated ODBC drivers?

 

[KCcasey]

[blue]Catadmin:[/blue] Collate.cfg is a required file for the FlexODBC driver to talk to the Dataflex datasource. The DFPATH is basically a path to the required files. Regarding testing permissions; I've accessed the data source using the Report Server account (using the FlexODBC driver throught MS Access). I don't think I can add the datasource as a linked server, I'm sure that it doesn't support the required level of ODBC compliance - hence the driver.

[blue]ookete:[/blue] I'm running Win 2003 server (sp1) and SQL 2000 (sp4). The server is using the same version of the FlexODBC driver my desktop is - are there any other OS or SQL specifc updates related to ODBC I should look at installing??

Thanks Guys!!!

 

[Catadmin]

Have you tried installing your driver on the machine hosting the Report Manager?

I'm betting that's where your problem is, since you don't see the error message until after you've deployed the report. Especially since your error message indicates that RS can't find that driver file.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[KCcasey]

[blue]catadmin:[/blue]
Yeah the driver is installed on both machines (same version). I've created a work-around by importing the data into SQL for RS to perform its wizardry. Cludgey but it works. I'm going to petition my IS Manager to buy an upgraded driver that is supposedly ODBC 2.0 compliant

Thankyou very much for you input, it was most appreciated!!!

Kindest Regards,

Casey.

 

[Catadmin]

Sorry I couldn't help more.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???