>- 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 -<
