If anyone is interested, it turns out that the Oracle ODBC drivers were hosed up (bad install). When we switched to the Microsoft ODBC drivers, everything worked fine. So, a reinstall of the Oracle client and the fix was complete.
Dave ----- Original Message ----- From: "Dave Hannum" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 2:08 PM Subject: (REPOST) CFMX and ODBC I posted this about 2 hours ago, and have not received any response. I went to the Forums, and WOW - there are lots of ODBC issues surrounding CFMX - expecially with Oracle. Any of you FigLeaf guys have any insight into this? I don't see MM lending any support here. It seems to be an issue with many. Dave ----- Original Message ----- From: "Dave Hannum" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 12:08 PM Subject: CFMX and ODBC Hello, I have CFMX on Win2K. I've installed the Oracle ODBC and have my TNS Names file fine. Now, here is my issue. I have CFMX talking to Oracle on a Sun box (which has Java). But, I cannot get CFMX to talk through an ODBC Socket to my Oracle on an IBM mainframe without Java. CF5 does this fine. The error I keep getting in the CF Administrator when I set up the connection is that my datasourse is not configured in the "jrun-resrouces.xml" . I've looked in there, and it is in there, just like the connections to the other databases. Now, it may not be "correctly configured" but I have no way of knowing. The info (Server IP, Port and such) is all correct. I can connect to the IBM database through SQLPlus, so I know that the machines can talk to each other, but I don't believe SQLPlus uses ODBC, but it does use the TNSNames.ora file, so I know it's correct. I have Oracle ODBC on the server. Any clues? Thanks, Dave =============================== David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] "If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists