Chris, Wow! Thank you for your reply! Oracle9i Enterprise Edition Release 9.2.0.1.0
When I tried to select the Tables I got this error msg error 7399: OLE DB provider 'OraOLEDB.Oracle' report an error OLE DB error trace[OLE/DB provider 'OraOLEDB.Oracle' IDBInitialize:: Initalize returned 0x80004005;]. thanks seng -----Original Message----- From: Lomvardias Christopher [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 10:05 AM To: Ung, Seng Subject: RE: [CFCDev] SQL server 2000 What error are you receiving? What version of Oracle? I assume you've already loaded the appropriate client tools on the SQL box that you want to do the linking? Chris -----Original Message----- From: Ung, Seng Sent: Wednesday, October 29, 2003 10:01 AM To: [EMAIL PROTECTED] Subject: [CFCDev] SQL server 2000 To All: Sorry! the question that I am about to ask is not releated to Coldfusion. I am not sure where I can post my question to? I am trying to use Linked Servers to connect to my Oracle, but I am not having any luck... Here is the tns infomation TestDrive = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Seattle.webxyz.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = test) ) ) >From linked server properties, here is what I entered... Linked Server=TestDrive Privider name=Oracle Provider for OLE DB Product name=Oracle Data Source=testDrive Provider string = msdaora Am I missing anything? thanks seng ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
