I am using CR Professional, Product Type: Full; version 22.214.171.1245.
Microsoft Dynamics GP Professional 9.00.0281, database: SQL Server, ODBC Driver, and Microsoft SQL Server 2005. Iu2019m on Windows 2000 SP4 workstation. I have already connected to the Dynamics database through ODBC on my computer.
I created two reports on my computer. Now that they are finished I need to let end-users run and query the reports.
I attempted to attached them to the server's database by selecting a blank report, create new connection, select ODBC (RDO), Data Source Selection opens, I select the database, Connection Information window prompts for password and database, I select the database that I've been using, click finish. In Database Expert I select the database, expand dbo (Views, Information_schema, sys are listed), expand tables, and I see my tables all on my computer.
One one computer I did not have to go through all this for the report to work.
Taking the steps I mentioned above I only get dbo and the tables do not contain the tables I need for my report. There's no view listed under "tables". Going through Admin Tools I verify he is connected to Dynamics through ODBC. I've attempted many, many times to connect this other computer but it simply won't do it.
What could be causing this problem?