Skip to Content
0
Former Member
Jan 11, 2008 at 07:18 PM

Change Database Source

41 Views

Post Author: scott@inwood.net

CA Forum: Data Connectivity and SQL

Crystal Reports 11 Professional Edition

I wrote a report using an odbc sql connection called "M2M" that works great. I now need to change the datasource to a different database called "M2M Company 2" on the same server. I created a new ODBC connection with the new database as the default database. I then changed the database source to look at the new ODBC. My report however is still looking at the original database instead of the new one. I think part of the issue is that both ODBC connections have permissions to see both databases the only difference between them is thier default database.

Thanks,Scott Hanebutt