Skip to Content
Former Member
Mar 06, 2009 at 08:17 PM

SQL Database Problems Wrong Tables


I am using CR Professional, Product Type: Full; version

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?

Cynthia Wyman