Please help with stored procedure

[CRuser89]

Hello everyone,

This is my first time calling a stored procedure in CR 8.5. I usually add the tables and select the columns from there. I have this stored procedure that references 2 different databases. I was able to pull up the stored procedure via an ODBC connection but it errored out because the datasource is connecting to database 1 and the stored procedure references both database 1 and 2. Is there a way for me to make this work?

Thanks in advance,
Kathy

 

[synapsevampire]

Post the database being used, ODBC means Open Database4 Connectivity, not a database type.

Oracle has special considerations, as do other databases.

In general, when asking any technical question, first state your environment.

-k

 

[CRuser89]

Thank you synapsevampire. I'm sorry, I was using sql server. I found the problem to be permissions related. Thanks for your assistance.

Kathy