Michael Maddison
michael at ddisolutions.com.au
Tue Dec 26 21:19:05 CST 2006
Thanks for the reply, After screwing around for a day I handballed it to the clients IT dept, after 2 days they got it working... cheers Michael M I did set this up, but cannot refer to how I did it as it was at my previous place of employment. However the problem I had was with using the Oracle provider vs the MS provider. Grant it you need to have both, but the MS Oracle provider is a wrapper for the Oracle provider is how I understand it. I can't remember the error I received when trying to use the Native Oracle client but it simply wouldn't work. Please try to use the MS Oracle provider. It should work just fine.. Rich -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Michael Maddison Sent: Tuesday, December 19, 2006 10:21 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Linked Oracle Server While I'm thinking of it, anyone set up a linked Oracle server in 2K? What should the provider string look like? None of the examples I've found seem to work for me. cheers Michael Maddison DDI Solutions Pty Ltd michael at ddisolutions.com.au Bus: 0260400620 Mob: 0412620497 www.ddisolutions.com.au _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com CONFIDENTIALITY NOTICE: The information contained in this transmission may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please be advised that any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you received this transmission in error, please contact the sender at TIGG Corporation immediately by replying to this email and deleting it from your computer. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com