two Environments in one?! 1

[RSX02]

Hi
In my crystal report If I click on the lightning, I have the SQl Server Login.
As my datasource it show me DB1
if I click on the Option button my database is DB2
How come it is not the same thing there? How can I know which one is use?
Thanks in advance
Rsx02

 

[synapsevampire]

Try posting your environment, especially given tha language barrier.

Crystal version?
Database used?

What does it show in Database->Set Loaction as the database?

-k

 

[RSX02]

Crystal 8.5
Database: SqlServer
it show db2 in the set location

 

[synapsevampire]

Use the Set Location to go point at the proper database.

-k

 

[RSX02]

The right Database is db2 (so it's already ok)
But I wonder why the DB1 is the datasource (is it because it's with this database that I build the report)???

 

[synapsevampire]

Sorry, I misunderstood, I thought you meant the big kid database product DB2 as opposed to a server or database name.

Let's clarify our technical terms here:

When you select Database->Set Location where does it display DB2?

There should be:

Server Type
Server Name
Database
User ID

Under the Server Type will be ODBC or whatever
Server Name will be the name of the SQL Server database
Database will be the Database name on that server
User ID will be the logon being used

There shouldn't be anything called data source.

Perhaps you mean the DSN because you're using ODBC, which doesn't matter, you can name any connection in ODBC whatever you'd like (except reserved names).

Remember, when you tell people that you're pointing to DB2, they're probably going to think that you mean the big boy database product, not a server. It's like saying that you have a server named Oracle...

-k

 

[RSX02]

Let's forget DB1 and DB2...I'll use the real name here.

Server Type: ODBC-SPIN (which SPIN is the one that I build my report with)
Server Name: SPIN
Database: SPIN_App
User ID: ID

but when I try to logon I go to the option (the "Options" button) And then the datasource is SPIN and the database is Syt7_App

I sent my report (once it was done) to my customer and they install it on there site (Syt7_App). As I build my report with the data contained in the Spin site...It seems to stay with the Spin in memory...I think the report is working anyway...My question is : why does it stay with the SPIN in memory?
If you need furthers informations just ask me.
Thanks in advance
Rsx02

 

[synapsevampire]

It retains the ODBC information within the report with exception to the password.

If they have Crystal, have them open the report and run it using the proper ODBC connection, and then save it.

-k

 

[RSX02]

ok thank you
Rsx02