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
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"
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines