Solved

OLEDB for Oracle

Posted on 2004-08-01
10
3,607 Views
Last Modified: 2008-01-09
Hi,
    we have a problem in migrating from oracle 8i to 10g. if some one can help us. it will be great.
here is my problem.
we have developed a web application with asp.net with oracle 8i. now we plan to migrate to 10g. in asp.net we have used oledb by microsoft for oracle(msdaora). i have installed 10g client in the machine. but when i try to run the application it gives install oracle client with networking options. but my sqlplus works fine.
then i tried with oracles OLEDB implementation. now iam getting
REGDB_E_CLASSNOTREG(0x80040154).

if any can help me to work with any one of oracle oledb or microsoft's oledb(msdaora)

the connection string are like this.
Microsoft's OLEDB "provider=madaora;user id=user;password=pwd;data source=ds"
Oracle's OLEDB "provider=OraOLEDB.Oracle;user id=user;password=pwd;data source=ds"

muthu
0
Comment
Question by:n_b_mkumaran
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
10 Comments
 
LVL 8

Accepted Solution

by:
annamalai77 earned 168 total points
ID: 11691073
my dear friend

get the latest OS and install it in ur webserver which runs the application.

i also had the same problem when my webserver was running with oracle 8 and my database was oracle 9i. i installed the latest ODBC driver and got the connection string which is now working fine.

"Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=BSL;Password=CREATIVE;Data Source=LTMPIPS"      

the above is the connection string i got after installing the latest ODBC.

regards
annamalai
0
 

Author Comment

by:n_b_mkumaran
ID: 11691369
Dear Friend,
i my PC i have windows 2003 with service pack 1 and .net framework 1.1.4 and MDAC version 2.7. but still it doesn't work.

muthu
0
 
LVL 8

Expert Comment

by:annamalai77
ID: 11691521
hi

check the link below

http://forums.aspfree.com/archive/t-20782

regards
annamalai
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 166 total points
ID: 11704518
My 2 cents:

It isn't suprising that the Microsoft driver won't work with 10g.

You might want to look at porting the app to ODP.Net.  The syntax is very similar to oledb so there shouldn't be many syntax changes.

We've been using ODP.Net with .Net since it came out and would never think about going back.  The only drawback is if you need to support multiple back end databases.  If you only need to support Oracle, then ODP is the way to go.
0
 

Author Comment

by:n_b_mkumaran
ID: 11711555
Hi Friend,
   thank u for the suggestion. i think the problem is with the registeration of OLEDB DLL with the windows. if i didnt have any solution, then i have to port it to odo.net.
if any one tell me what dll are to be registered then my problem will be solved.

thanks

muthu
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 11715265
Sorry, can't help with oledb.  We haven't used it for years and those brain cells have long since died.
0
 

Assisted Solution

by:suganthkumar1
suganthkumar1 earned 166 total points
ID: 11878045
you can go to microsoft's website mentioning about the MDAC and get the list of dlls, or download and install the latest MDAC in you machine. it will solve the problem
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question