Question: Is there a way to test an OLE DB connection? I'm trying to run a report on a new machine and it is getting a database connection error.
Answer: Yes. As long as you know the OLE DB connection information from your report (you can see this in Crystal Reports
or in our Report Runner log files), then you can type/paste that same connection information into this test:
http://www.gotknowhow.com/articles/test-a-database-connection-string-using-notepad