• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 113
  • Last Modified:

Can SQL Server Synonyms be used in a Crystal Report connection command

Hi Experts,
Can SQL Server Synonyms be used in a Crystal Report connection command?  
If so, how?

Thanks in advance,
mrotor.
0
mainrotor
Asked:
mainrotor
1 Solution
 
vastoCommented:
Command will be send to the database as is. If it works in SSMS it will work in Crystal.
0
 
mlmccCommented:
Agree.  I built many reports against an Oracle database that used synonyms.

mlmcc
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now