n_b_mkumaran
asked on
OLEDB for Oracle
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(0x8004 0154).
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
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(0x8004
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;
muthu
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
Sorry, can't help with oledb. We haven't used it for years and those brain cells have long since died.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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