Publishing with multiple drivers

[jcl5]

Hi guys

I'm using Crystal 10, CE10 and Oracle 8i (all components installed on one server)

I have a number of reports using native drivers successfully published. I now have a new report which is using a Microsoft ODBC driver and I can't get it to publish - it gives me the following error:-
The database information for this report is either incomplete or incorrect [on cache/page server: db1.pageserver]

I'm sure I do have the correct logon information and in the database tab in the management console I have 'use original database logn information from the report' ticked.
However, I have also tried prompting the user for the database details at runtime and it doesn't like the correct user name and passowrd for some reason so I know the difficulty is in seeing the database.

Any suggestions on what's wrong?

Many thanks

jcl5

 

[Turkbear]

Hi,
What database is the ODBC DSN accessing?
What type of DSN ( system,user, file)?
Did you test the connection after creating it?

Do the pageserver ( and the report jobserver) have rights to read the ODBC info?( What account are they running under)?

 

[jcl5]

The odbc dsn is accessing the Oracle database.
It is a system dsn - don't know how to test the connection - do you need to have Crystal Reports installed on that server?

The pageserver and job server both have administrator rights.

Thanks

jcl5

 

[Turkbear]

Hi,
No, CR is not needed but an Oracle client is ( since your Native Driver ones work, I expect that is OK)
[is the ODBC connection to the same instance as the Native Driver connection that works?]

Try creating a DSN using the Oracle ODBC driver instead of Microsoft's.

If you create a File type DSN, the ODBC configuration tool should ask you to test the connection ( what Windows version?)- but continue to use the SYSTEM type for actual use.