This is a bit basic but it works. Install the Sybase client on your DB Server. Setup an ODBC DSN to that DB. Go into SQL Server Enterprise Manager/<Remedy DB Instance>/Security/Linked Servers right click and tell it to create a new linked server. Choose 'Microsoft OLE DB Provider for ODBC Drivers'. Provide it with a DSN Name. Go into the Remedy DB (ARSystem?) and create a view using your new linked server, it took me forever to get the table names proper but I use <LinkedServerName>..DBA.<TableInRemoteDB>. Now that you have a View in your Remedy DB you can create a vendor form base off of that view and you should be good to go.
Please feel free to contact me off list if you need additional details or help getting it working. L. J. Head Software Engineer Remedy Approved Consultant -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Wednesday, September 13, 2006 10:40 AM To: [email protected] Subject: ARDBC plug-in to Sybase Hello Listers, ARS 6.3 Patch 14 MS SQL Server 2000 Has anyone seen any sample ARDBC plugin code for reading a remote Sybase DB? I looked at the Buoyant Solutions Integrations but there are two problems. We have no money and it looks like the Sybase integration is not ready yet. We are looking for a solution to read a remote Sybase table and either use a Vendor form or just a Set Fields filter action. I checked some other options from information I gleaned off of the List. I have not been able to find a "gateway" for MS SQL to interact with Sybase. I have control of the MS SQL Server but the Sybase system is controlled by the corporation. Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
