Same ODBC Name; Different Properties....

[putts]

Okay, here's the situation.

We have an outside company do some stuff for us and they have a working copy of some of our databases however they use different naming techniques than we do for the actual MS SQL Database names.

So, they made a report for us that pointed to an ODBC connection that matched perfectly with the name of ours - in fact, everything about the connection is identical as this is for their product - everything, that is, except the name of the actual database.

Everytime I did a "Set Datasource Location" and tried to switch the report's datasource to be our ODBC (which has a name identical to theirs) it keeps giving me the same error...something to the effect of .....
Table not found 'Frank_test.dbo.EOR_DETAIL'
....well that's because it should be 'Eclipse.dbo.EOR_DETAIL' in our world but it just seems determined not to update.

Well, I thought that it was because of sharing the same ODBC DSN name so I created a new one with a different name and tried setting it to that, but it still insists on finding these tables under the old name despite the fact that even in the "Set Datasource Location" screen, it no longer references Frank_test.

Is there any way to "purge" our report of this old database name?

We are using 9.0

 

[synapsevampire]

Go into the Set Datasource Location and manually edit it by selecting the connection properties->double click the Data Source name to edit.

We used to intentionally go in and leave it blank so that it wasn't explicitly set to anything, that way changing the ODBC allowed us to flip back and forth between databases.

-k

 

[ciscowiz]

synapse could you elaborate on what exactly you left blank and how you flipped back and forth between DBs in ODBC?

 

[IdoMillet]

See:

http://support.businessobjects.com/library/kbase/articles/c2014760.asp

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com