Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I access Oracle 8 data via ODBC
Hello
I have installed Oracle 9 client and can access Oracle data via Excel 2003 via ODBC. But not via Microsoft Word 2003. If I attempt to connect via an ODBC data source which I have already setup I get [Microsoft][ODBC Driver Manager] This driver is incapable of supporting the current environment attributes. Anyone have any ideas? I have installed the Oracle version 9 client. the actual database is Oracle 8. Angus |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I access Oracle 8 data via ODBC
On Apr 22, 1:05 pm, Angus wrote:
I have installed Oracle 9 client and can access Oracle data via Excel 2003 via ODBC. But not via Microsoft Word 2003. If I attempt to connect via an ODBC data source which I have already setup I get [Microsoft][ODBC Driver Manager] This driver is incapable of supporting the current environment attributes. Anyone have any ideas? I have installed the Oracle version 9 client. the actual database is Oracle 8. It sounds like the limitation you're hitting is not in the Oracle 9 Client, per se, but in the ODBC Driver associated with it. My best guess is that Word is setting up a somewhat different Environment than Excel uses, and that the ODBC Driver doesn't support all the differences. "Free" often doesn't lead to "fully featured." You might try using one of the ODBC Drivers for Oracle from OpenLink Software. The Single-Tier "Lite Edition" for Oracle 9 [1] will be needed for use with the Oracle 9 Client you have installed. The Single-Tier "Express Edition" [2] will only work if you're targeting Oracle 8.1.7.4 or later, as it is self-contained and doesn't make use of the OCI client you have already installed. The Multi-Tier "Enterprise Edition" [3] is probably not appropriate for you, unless you have many client hosts or significant need for security and/or centralized administration features. Each of these links will bring you to a login/register page, from which you can download the driver and a 14-day evaluation license. All features are fully enabled without limitation, other than this expiration date. [1] http://download.openlinksw.com/downl...-dbms=6.1-ora9 [2] http://download.openlinksw.com/downl...-dbms=6.1-ora8 [3] http://download.openlinksw.com/downl...m=3&fam=1&df=1 (Mouse to the row of your Oracle instance's host OS, in the Oracle v8 column; then click on the exact version of the Oracle host OS. You'll choose your ODBC client host OS on the next page.) Up-and-running support may be found through OpenLink's online Support Center and Case System, http://support.openlinksw.com/, or the new discussion site, http://boards.openlinksw.com/support/. I hope this proves helpful. Ted -- A: Yes. http://www.guckes.net/faq/attribution.html | Q: Are you sure? | | A: Because it reverses the logical flow of conversation. | | | Q: Why is top posting frowned upon? Ted Thibodeau, Jr. Evangelism & Support OpenLink Software, Inc. http://www.openlinksw.com/ Universal Data Access and Virtual Database Technology Providers |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge from query of ODBC data source | Mailmerge | |||
Oracle connection error | Mailmerge | |||
ODBC Iseries access - Record 1 contains too few data | Mailmerge | |||
Error Message when using ODBC: " Record |
Mailmerge | |||
Merging Oracle data with Word Templates | Microsoft Word Help |