Hi,

I have an ODBC Connection installed on our PROD server that when you test through I-SQL and the ODBC Administrator it works.

When I add a new data source to the reporting server we interface and press test connection it just hangs for ages then gives a page cannot be displayed.

I have installed all the same on the DEV server and it works fine.  I have set all of the configs to exactly the same!

I feel like something to do with reporting services is not correct.  Any one have any ideas?

Thanks.

Hi KMoff,

Per my understanding that you are using the ODBC datasource type and when you have set the connection string and click the "Test Connection" it hangs and got some error, right?

Please find the details steps below and try to provide more information according to the questions:

1. Whether the error message you got is "page cannot be displayed", if not, please try to provide more details inforamtion.
2. Did you got the error message when you click on the "Test Connection" from designer or report manager.
   If you got the issue only in the report manager, the issue can be caused by the support of the ODBC driver in the report manager and also the bit.
   Standard .NET Framework data providers do not necessarily support all the functionality supplied by Reporting Services data processing extensions. In addition, some OLE DB data providers and ODBC drivers can be used to author and preview reports, but are not designed to support reports published on a report server. See Data Sources Supported by Reporting Services (SSRS)
   
   When you deploy a report to a 64-bit report server (x86), the report server must have natively compiled 64-bit data providers installed. Wrapping a 32-bit data provider in 64-bit interfaces is not supported.
   
3. Could you provide more details information about the connection string you are currently using.(Excel files or something else)

Similar thread for your reference:
SSRS - Using Excel as a Data Source
Details information about the ODBC datasource:
Create SSRS report using Excel Data Source Step by Step

If you still have any problem, please feel free to ask.

Regards,
Vic

Hi Vicky,

The error message was getting was just page cannot be displayed and this was from the report manager not the designer.

I managed to search the Reporting service Logs and found some 20 minutes after pressing test errors appeared in the Logs saying that it was an incorrect password or login.  Although the exact username and password are working on the DEV machine.  

I then found that the accounts that run the services on the PRod server were not permitted to logon locally! Yet on the DEV machine they were.  I changed this and now it is working! Bizarre! 

Thank you for your help.

• Marked as answer by Vicky_LiuMicrosoft contingent staff, Moderator 18 minutes ago

Hi KMoff,

Thanks for your sharing  which will help others a lot and glad to hear your problem have been resolved.

Regards,
Vicky Liu