I am trying to create pivot table on our website (intranet).
Everything seems to be going well until viewing the web page. It doesn’t seem to want to connect to the data source. I created a new “data source” from a MS Access 2007 database. The following is what’s displayed in the pivot table box on the site:
The query could not be processed:
– Data provider could not be initialized.
– [Microsfot] [ODBC Microsoft Access Driver] ‘(unknown)’ is not a valid path. Make sure that hte path name is spelled correctly and that you are connected to the server on which the file resides.
This seems like such a simple thing to try and do. But I can’t seem to figure out this piece of it!
The website and database reside on our company server running SBS 2003. I’m trying to view the website from one of the networked computers.
Any help would be appreciated. Thank you!