If you are running SQL Server 2005, you might want to look into the new Synonym feature.
http://www.developer.com/db/article.php/3613301 -Mike Chabot On 10/4/07, Bruce Sorge <[EMAIL PROTECTED]> wrote: > Sure. > My query looks like this: > > SELECT [xx.xxx.xx.xxx].Snowline.dbo.Street.RecordID, > [xx.xxx.xx.xxx].Snowline.dbo.Street.Prefix + ' ' + > [xx.xxx.xx.xxx].Snowline.dbo.Street.Name + ' ' + > [xx.xxx.xx.xxx].Snowline.dbo.Street.Type + ' ' + > [xx.xxx.xx.xxx].Snowline.dbo.Street.Suffix AS Name > FROM Bus_Routes INNER JOIN [xx.xxx.xx.xxx].Snowline.dbo.Street ON > Bus_Routes.Main_St_ID = [xx.xxx.xx.xxx].Snowline.dbo.Street.RecordID > WHERE Bus_Routes.Route_ID = @Route_ID > > What I was doing was on the inner join, I had it written like this: > INNER JOIN [xx.xxx.xx.xxx].Snowline.dbo.Street.RecordID rather than INNER > JOIN [xx.xxx.xx.xxx].Snowline.dbo.Street. Stupid mistake. This is what > happens when you use the Create New View gui for so long, that when you have > to write it out from scratch you forget the little things like that. > > The only problem now though is that I am not able to bind the individual > fields. When I do a SELECT * then it works fine, but as you can see I am > building a string so I need to reference the individual fields. > > > Bruce Sorge > > > > ----- Original Message ---- > From: Ian Skinner <[EMAIL PROTECTED]> > To: SQL <[email protected]> > Sent: Thursday, October 4, 2007 10:48:03 AM > Subject: Re: Linked SQL Server question > > > Bruce Sorge wrote: > > Disregard. I figured it out. > Can you share an example for those of us who may run into this in the > future? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2975 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
