Just a thought...
Have you tried this query from the windows 2003 server.
you have to setup the server as a client to Oracle,
being able to do it from dev studio means that your computer is setup
as a client, but that doesn't translate to your server being a client.
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
Ben Johansen
http://www.webspinr.com
[email protected]
Phone: 360-597-3372
Mobile: 360-600-7775
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
