SQL sep instance databases connection
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11378
Printed Date: 02 May 2024 at 3:01pm
Topic: SQL sep instance databases connection
Posted By: Debbie Giles
Subject: SQL sep instance databases connection
Date Posted: 09 Oct 2010 at 11:58pm
|
I am trying to retrieve data from a seperate instance of SQL using
Select * From MyRemoteServer.DatabaseName.dbo.Sysobjects eg Select * From RFF-03\KRONOS.tkcsdb.dbo.DG_DailyReports
My server name is RFF-03 and the instance is KRONOS and SQL doesn't like the '-'. If I use the server number 174.173etc, then it doesn't like the '.'
 Debbie ------------- Debbie Giles Syspro Consultant EOH +27 21 525 7200 |