Everyone,
Thanks for the reply. We are trying to get data from McKesson Horizon Clinicals Server. We currently query the Oracle db using FREE TOAD. We have the sql for the 3 queries that are used. I just want Boston to duplicate this process. I have loaded the Microsoft ODBC driver for Oracle. We try to use data station to open the file but when we test it we get ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor. I need to know where this service name and descriptor is defined. Also is there any documentation on how to set up the ODBC connection to Oracle. Thanks in advance Scott Hendrix Sacred Heart Health System Pensacola, FL 850-416-7879 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bendapudi, Ranjit Sent: Monday, July 21, 2008 12:49 PM To: [email protected] Subject: RE: [Talk] HELP..BWS and Oracol Databases I guess you are trying to connect to Oracle. If so you can use an ODBC connection to Oracle database. Make sure you have the ODBC driver for Oracle on the PC you are running BWS to connect to Oracle. Then you can create a DNS file with the connection information. Once the connection is established you can use the recordsets in your BWS Vb-Code. HTH -Ranjit ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hendrix, Scott Sent: Monday, July 21, 2008 10:55 AM To: [EMAIL PROTECTED] Subject: [Talk] HELP..BWS and Oracol Databases Does anyone know how or even if BWS can open Oracle database file off a Red Hat server. I just need to pull some data and FTP it to our iSeries join it with other data gathered there and produce reports. I have been given the great opportunity to learn BWS and accomplish this task in a week.. Please forgive me if I sound like an idiot. I am new to BWS and Oracle. Any code examples or ideas would be great. Scott Hendrix Sacred Heart Health System Pensacola, FL. CONFIDENTIALITY NOTICE: This email message and any accompanying data or files is confidential and may contain privileged information intended only for the named recipient(s). If you are not the intended recipient(s), you are hereby notified that the dissemination, distribution, and or copying of this message is strictly prohibited. If you receive this message in error, or are not the named recipient(s), please notify the sender at the email address above, delete this email from your computer, and destroy any copies in any form immediately. Receipt by anyone other than the named recipient(s) is not a waiver of any attorney-client, work product, or other applicable privilege. This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient. Any review, reliance, or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies. CONFIDENTIALITY NOTICE: This email message and any accompanying data or files is confidential and may contain privileged information intended only for the named recipient(s). If you are not the intended recipient(s), you are hereby notified that the dissemination, distribution, and or copying of this message is strictly prohibited. If you receive this message in error, or are not the named recipient(s), please notify the sender at the email address above, delete this email from your computer, and destroy any copies in any form immediately. Receipt by anyone other than the named recipient(s) is not a waiver of any attorney-client, work product, or other applicable privilege.
