I can not get an ODBC socket DSN set up to our Oracle databases on one server from my local development box.
1) The ODBC socket DSN connections on my box to our other Oracle Servers work just fine.
2) Testing of the service in question in the Oracle Net8 Assistant tool works correctly.
3) The ODBC DSN configuration in MS ODBC Data Source Administration works correctly, I can link to tables in the these databases with Access from my box using the MS ODBC DSN.
But when I try to set up the DSN on my CF Administrator it fails telling me to check my user name, password, URL, and other connectivity info. Well I have checked and rechecked all that as many ways as I can figure out how to, but I can not find the problem.
The problem does seem to be something specific to this one Oracle server and my local box. There are two databases on that server and I can not connect to either one of them. But I can connect to any database on our other Oracle servers just fine. As well as all these DSN's work just fine on our staging server between all the Oracle servers
As far as I can tell all the connectivity information is the same between the staging box and my local box.
Help greatly appreciated.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
