This might be unrelated, but have you tried a simple search action
mimicking the SQL query to see if that provides you with similar
results? Sometimes WiTango does weird things...
____________________________________________________
Kaustav Acharya
Web Developer
U. Inc.
12250 El Camino Real, Suite #100
San Diego, CA. 92130
Office: (858) 847-3350 x1004
Fax: (858) 847-3340
email: kacha...@colleges.com
http://www.colleges.com
____________________________________________________
Power to the People - http://www.campaign.com
____________________________________________________
Important Note: This e-mail may contain privileged, undisclosed or
confidential information. If you have received this e-mail in error,
you are hereby notified
that any review, copying or distribution of it is strictly
prohibited. Please inform kacha...@colleges.com Immediately and
permanently destroy the original transmittal.
On Jan 7, 2009, at 7:29 AM, Wolf, Gene wrote:
I have an issue I can't seem to get around. I am trying to connect
to Oracle on a Windows 2003 Server. I have the tnsnames.ora file
set up (portion included) and in the developer the table names and
fields are showing up just fine. However, when I run a test program
to perform a simple request I get the error below. Anyone have any
suggestions on what I can do to get Witango talking to Oracle? I'm
confused why I can use the developer and see the table and column
names and even use the SQL Query within the developer (screen shot
included) and get values from the Oracle tables but when I run the
taf I get the error message below. The server tnsnames file is set
up exactly the same as the file on the development machine. Any
help would be greatly appreciated!
<att269e1.png>
Here's the pertinent portion of the tnsnames.ora file:
DEV = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = iruxs5.rsta.drs.master) (PORT =
1561) )
)
(CONNECT_DATA =
(SERVICE_NAME = DEV)
(INSTANCE_NAME = DEV)
)
)
Here's what I'm seeing in the developer. Everything looks fine.
<att3892e.png>
Results from query of the Oracle table:
<att320ee.png>
Gene Wolf
Supervisor, Business Systems
DRS Sensors & Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
321-309-0202 (fax)
Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/
This e-mail, including any attached files, may contain confidential
and privileged information for the sole use of the intended
recipient. Any review, use, distribution, or disclosure by others
is strictly prohibited. If you are not the intended recipient (or
authorized to receive information for the intended recipient),
please contact the sender by reply e-mail and delete all copies of
this message.
"This (document/presentation) may contain technical data as defined
in the International Traffic In Arms Regulations (ITAR) 22 CFR
120.10. Export of this material is restricted by the Arms Export
Control Act (22 U.S.C. 2751 et seq.) and may not be exported to
foreign persons without prior written approval from the U.S.
Department of State."
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
