I feel like this should be so simple but I'm struggling. I want to use data in an Access 2016 Database to create reports on Report Builder. When I'm not connected to the report server the connection string works and I get data. When I connect it to the report server I get an error: "Unable to connect to the data source. Please verify the connection properties and credentials". When I click "details" I get either an architecture error (which I believe indicates a 32bit to 64bit error) or "Data source name not found and no default driver specified". Our Access is 32 bit and the ODBC Driver I'm using is 32 bit. Again, it works when Report Builder is not connected to the report server but errors when connected to the report server. I've selected that I'm using an ODBC connection type. I think the error is in the connection string but I can't find any help on what a valid connection string would be. I don't know where to look/change if the problem is actually that something is 64 bit. It seems like it should be so simple for a Microsoft Report Builder on a Microsoft Server to pull data from Microsoft Access. Anyone have any ideas?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.