Solved

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

Posted on 2016-10-03
2
60 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

735 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