Question Locked

cant connect to two different databases from crystal enterprise X1

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Enterprise throws an error 'incorrect logon parameters..' if I try to run a report that uses two different databases of the same server.

Main report pointing to a stored proc in one database and subreport pointing to a table in another database.
I am using ODBC connection to sql server.

I tried following senarios:

1)In report used ODBC connection "DSN1" for Main Report database "DB1" and ODBC connection "DSN2" for subreport database "DB2".
Set these two connections and databases thru "Use custom database logon..." option in enterprise.
THROWS ERROR!

2) In report used ODBC connection "DSN1" for Main Report database "DB1" and same ODBC connection "DSN1" for subreport database "DB2".
Set one connection and one database thru "Use custom database logon..." option in enterprise. No option to set the second database one the same connection.

Appreciate your comments.

Thanks

4 replies

by tony hopkinson

if they are on the same server and equivalent privileges.

Select * from OtherDB.schema.Table

Different servers, look up remote stored procedures. Some dbms's will let you do
server.datbase.schema.table

Different DBMS, look at a data warehouse type option.

by fry100

Tony,

Apologies for posting so long after your original reply. I'm having exactly the same problem as detailed above but I don't follow your reply. Could you give me a little more detail please?

Kind regards,
Fry

by fry100

Hi, I'm having exactly the same problem with my Enterprise connection. Did you resolve your problem?

Kind regards,
Fry

This discussion is closed to new replies.