>- see footer for list info -< sql server synonyms are great but it's new in SQL 2005 - I've found that most companies haven't moved to 2005 yet so this can be archived in a lot of cases.
On 10/08/07, Snake <[EMAIL PROTECTED]> wrote: > >- see footer for list info -< > If you are not allowed direct access to the database then you cannot use a > synonym either. > I think you are confused over what it is. > http://www.developer.com/db/article.php/3613301 > > If they want to only allow access via a web services type interface, then > this functionality is also built right in via sqlxml on IIS > > Here is some more info > > http://sqlxml.org/faqs.aspx?79 > http://sqljunkies.com/Article/53969753-E560-4923-89AC-0AA3C8ECACDC.scuk > > Alkso check your BOL for more info > > > Regards > -- > Russ Michaels > Russ Michaels Consulting Ltd > t: 0845 8620034 > f: 07092 300330 > > > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Fiaz Khan > Sent: 10 August 2007 11:32 > To: Coldfusion Development > Subject: [CF-Dev] SQL Server synonyms > > >- see footer for list info -< > Hi All > > I don't normally contribute to this list as my CF knownledge is somewhat > lacking as a result of fewer CF projects, hope its not a sign of things to > come. :) > > I have a question regarding SQL Server and synonyms. A system i am writing > needs to integrate into another existing system. Due to agency politics i > cannot query the database directly and have to go through api/web service of > some sort which is being planned. I have stumbled across sql server synonyms > which seem to answer all my problems in getting hold of data in this > fragmented/distributed database. > > Does anyone know, before i go synonym mad, of any issues with heavy use of > them in CF? Everything i have read seems to suggest that they are ok (and i > could be wrong) and is in fact a feature which has been around in oracle for > years. > > Am i right in saying that they could create a user with "select" only access > and i could create a synonym using that user to connect to the db table? > > Thoughts? > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > >-< > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > -- Nick Tong web: http://talkwebsolutions.co.uk blog: http://succor.co.uk f..works: http://cfframeworks.com short urls: http://wapurl.co.uk green link: http://wapurl.co.uk/?4Z2YDLX _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
