Let me give you a tip. You might have to do some research to find the exact settings, but your DBAs on both servers, if they are windows 2k3, will need to enable DTC transactions or this won't work, at least not with Microsoft SQL Server.
This has to do with remedy wrapping each query that is sent with BEGIN TRANSACTION and END TRANSACTION tags. Windows will strip out these tags, as they are not needed for general select commands. This, in turn, breaks remedy. So, make sure they enable DTC transactions, so these tags are not removed, or remedy will not be able to query the remote database, this includes setting up any views to any tables on that database. Just an FYI, in case you are affected by it. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mikhail Sent: Thursday, June 14, 2007 12:45 PM To: [email protected] Subject: Re: Setting up Linked Server Hi Robert The database im connecting to is a MySQL database. And yes, just linking at a db level On Jun 14, 2:04 am, Robert Page <[EMAIL PROTECTED]> wrote: > Mikhail > > What DB type are we talking about as there are differences between them. > Also just for clarification are you linking at a DB level not thinking of > using a View form? > > Regards > > Robert > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Mikhail > Sent: 13 June 2007 17:34 > To: [EMAIL PROTECTED] > Subject: Setting up Linked Server > > Hello, > I have a menu that retrieves data from a database in another server. I have > read somewhere that linking the server remedy is in, to the server that the > database is in will do the job. Would anyone know the steps I have to take > to set this up? Thanks, Mikhail > > ________________________________________________________________________ ___-_ > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > Answers Are" No virus found in this incoming message. Checked by AVG Free > Edition. > Version: 7.5.472 / Virus Database: 269.8.15/848 - Release Date: 13/06/2007 > 12:50 > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.472 / Virus Database: 269.8.15/848 - Release Date: 13/06/2007 > 12:50 > > ________________________________________________________________________ ___-____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the Answers Are"- Hide quoted text - > > - Show quoted text - ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
