Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error with Excel 2002 and Oracle 8i

When I try to connect from Excel 2002 and VB with an Oracle 8.1.6 DB I get an error, "Error while trying to retrieve text from for error ORA-03121". If I try with Excel 2000 I do not have any problem, but if I try with Excel 2002 I have this error.

When I try to connect from Excel 2002 and VB with an Oracle 8.1.6 DB I get an error, "Error while trying to retrieve text from for error ORA-03121". If I try with Excel 2000 I do not have any problem, but if I try with Excel 2002 I have this error. It is something related to libraries?
The ORA-3121 error is "no interface driver connection." In order for Excel to connect to Oracle, you will have to define an ODBC connection to the database and then instruct Excel to use that ODBC connection. if this works in your older Excel spreadsheet, then you'll have to define the same ODBC connection, you'll have to tell Excel where to find the data. This is typically done with the Data->Import External Data menu option.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close