Link to home
Start Free TrialLog in
Avatar of rwhipple
rwhippleFlag for United States of America

asked on

Multiple ODBC Connections

We have several Mission Critical reports currently written in Crystal Reports 10 that utilize an ODBC connection to an MS SQL 2008 R2 DB. The person who knows CR10 is no longer available. We have a new person that is a little familiar with CR12, but not enough to try and update the older reports.

I was lead to believe that the CR10 Reports and CR12 Reports cannot or should not use the same ODBC Connection. Is it possible to create another ODBC connection to the same server/SQL DB under a different name without adversely affecting the original? I hesitate to just do it, because we cannot afford to break the CR10 Reports.
ASKER CERTIFIED SOLUTION
Avatar of Hypercat (Deb)
Hypercat (Deb)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rwhipple

ASKER

I think the reports all run as scheduled tasks. I could easily have them set to run with enough time gap to ensure one is done before the other starts. As for the security issue, I doubt that would be an issue. There is a specific "Reports" user that there run under. There are numerous vendor provided reports as well as the few custom reports in question that run daily.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I know next to nothing, beyond setting up the ODBC connection, about Crystal Reports, so I don't know why it was suggested to have a different connection.

Hypercat's suggestion with Vasto's expanded endorsement makes me less worried as I approach this. (I say LESS worried, because I've seen systems crash because of a routine system reboot.)