Solved

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

Posted on 2016-10-03
2
52 Views
Last Modified: 2016-10-03
Hi Experts,
Can SQL Server Synonyms be used in a Crystal Report connection command?  
If so, how?

Thanks in advance,
mrotor.
0
Comment
Question by:mainrotor
2 Comments
 
LVL 18

Accepted Solution

by:
vasto earned 500 total points
ID: 41826893
Command will be send to the database as is. If it works in SSMS it will work in Crystal.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 41827026
Agree.  I built many reports against an Oracle database that used synonyms.

mlmcc
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question