| John Yager 2005-06-09, 8:59 pm |
| Hi all,
I'm hoping someone can assist me. I'm developing a SQL Server 2000
database using VB 6.0 and Crystal Reports 8.5 report designer. I had
been testing in a "sandbox" database, but I'm now moving to a dedicated
test database on the same server. I created my reports in the sandbox
database with no problems. I'm using a system DSN to make the
connection.
When I tried to set the location of the database tables to the new
database, the report designer is not finding the tables. Nor is it
finding the tables that it previously found in the sandbox database. I'm
right-clicking on "Database Fields" and then "Set Location". In the "Set
Location" box I click on the "Set Location" button to bring up the "Data
Explorer" box. I then expand "ODBC" to bring up the connections. I then
expand the DSN that I want and it says "...no items found..."
If I run Crystal Reports and create a report using this DSN it finds the
tables with no problems. Also, if I use the Data Form wizard in VB and
connect using the DSN it will find them okay. So I know the problem
isn't with the DSN or the server. For some reason the report designer
just isn't finding any of my tables in this or any other database.
Can anyone suggest what might be the problem?
Thanks.
|