Join them; it only takes a minute: Sign up 10.2g to 11.2g and Microsoft ODBC for Oracle issues Ask Question up vote 4 down vote favorite My team are trying to oracle oracle10g odbc oracle11g share|improve this question edited Mar 1 '12 at 21:04 Justin Cave 171k15233269 asked Mar 1 '12 at 20:29 Alistair Laing 8041717 add a comment| 1 Answer 1 Microsoft chose to desupport this driver rather than port it to the new version of the OCI API. Is it acceptable to quit in the middle of a project, when I am the only team member? this contact form
Browse other questions tagged oracle oracle10g odbc oracle11g or ask your own question. benefit from releasing the e-mails he released? They also have Oracle Client 7.3.3 which I can see Oracle73 (2.00.03.01) mentioned in the ODBM Data Source Admin screen. –Alistair Laing Mar 1 '12 at 20:51 @AlistairLaing - At the moment we are using Microsoft ODBC for Oracle driver (version 2.575.1132.00) to connect to our 10g Database and have not had any issues.
Can someone confirm that our understanding is correct about there being a compatibility issues with Microsoft ODBC for Oracle driver (version 2.575.1132.00) and 11.2g? What is that feeling...? How does Donald Trump Jr. In ORACLE SQL Developer, we're able to connect to our 11g instance using the "basic" connection.
They also have Oracle Client 7.3.3 which I can see Oracle73 (2.00.03.01) mentioned in the ODBM Data Source Admin screen. They also have Oracle Client 7.3.3 which I can see Oracle73 (2.00.03.01) mentioned in the ODBM Data Source Admin screen. What does grep do when it's not running the CPU? Microsoft Odbc For Oracle However when we try connect to 11g we keep getting ORA-03113: end-of-file on communication channel errors.
Linux version number convention Who does the "Crown prosecutor of Russia" refer to? Not the answer you're looking for? Is it wrong to choose features based on p-value? Does Cloak of Displacement hide your character's location or do others see two bodies?
Does it matter which one of those ODAC I download as long as it has the 11g ODBC driver. So am I right in thinking that ORACLE client just includes the ODBC driver? –Alistair Laing Mar 1 '12 at 20:59 @AlistairLaing - I updated my answer. Oracle Odbc Driver 11g What circumstance would produce a society filled with parents willing to let the children be exposed to life-threatening Danger? Oracle Odbc Driver 64 Bit The Oracle client includes much more than just the ODBC driver but it does include an ODBC driver. –Justin Cave Mar 1 '12 at 21:12 Thank you Justin for
Oracle 7 clients can connect to Oracle 10.2 databases but Oracle does not support connections between Oracle 7 clients and Oracle 11.2 databases. asked 5 years, 4 months ago viewed 12,515 times active 3 years, 1 month ago Blog Trends in Government Software Developers Introducing Channels: Private Q&A for Your Team Related 4Connect to Stack Overflow Questions Developer Jobs Documentation beta Tags Users current community help chat Stack Overflow Meta Stack Overflow your communities Sign up navigate here I have also used the "TNS" entries and that works well.
What are words that can distinguish these two business types? Oracle Odbc Driver For Windows 7 64 Bit Free Download share|improve this answer edited May 23 '14 at 7:44 Benjamin 13.1k22101194 answered Mar 1 '12 at 20:41 Justin Cave 171k15233269 I think the business users obtained the Microsoft ODBC As far as our understand it ORACLE SQL Developer uses a different JAVA based driver to connect so it does not use the Microsoft version.
Does this mean everytime we upgrade our database I would need to upgrade the oracle clients as well? –Alistair Laing Mar 1 '12 at 21:28 | show 4 more comments Your What is the lowest digit in n or in 7n? Multiply a string and a number! Odbc Driver Download For Windows 7 64 Bit We have tried googling for a result and after various tests, we have come to the conclusion that it is an ODBC driver issue.
Is there an existing data structure that is of fixed size, and will push the oldest/last element out if a new element is inserted? I'd suggest installing the 11.2 client on everyone's machines though the 10.2 client would also be sufficient (assuming it's still available). –Justin Cave Mar 1 '12 at 20:54 So Have we simply been lucky that this driver has worked with 10g? his comment is here PM opting for an overly-complex setup which nobody has experience with How small is an infinitesimal quantity?
Assuming that you install the 11.2 version of the Oracle client (the only reason not to upgrade all the way to the 11.2 client would be if the users still needed I’m only really after the driver and do not require sql plus etc. The Oracle client install should also have the option to install a version of the Oracle ODBC driver-- that should be sufficient as well. You'll need to upgrade the version of the Oracle client that is installed on the business user's machines and you'll want to use the latest version of the Oracle ODBC driver
The only bit that's delaying us with our migration is that our business users have access to Crystal Reports XI, MS Access/Excel 2003 whcih they use to connect to our database. How long does it take to drive from Heathrow airport to Covent Garden? I think the business users obtained the Microsoft ODBC for Oracle driver by installing ORACLE Discover 22.214.171.124 which is used for another Oracle DB. A typical user has Window XP SP 3 (32bit) operating system.
more stack exchange communities company blog Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and