.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Migrating specialized system from Oracle to Microsoft

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server
 

I’ve been an Oracle DBA for over 15 years and am out of work. The Oracle well seems to have dried up. I want to switch to Windows/SQL Server (and possibly HPC Server) for a project I’ve been working on :

 

This summer I worked on building a massively parallel system I hope to market through my own company when I find some venture capital. My company is me, a one person organization and has no money. This machine uses the Intel 980X hex-core processor, Intel’s fastest commodity processor and four Fermi processors, each with 448 cores. The Intel portion of the code is programmed using the Intel parallel compilers & tools and the Fermi cores are programmed with Nvidia CUDA C and associated debugging and profiling tools.


View Complete Post


More Related Resource Links

System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot open or save any mo

  

Hello good people, 

I have this beast as an error. Did my research and found some posts here as well but did not do any good for me. 

Here is what I did. I had an error regarding issue rights with COM objects so I gave access rights under component services for Microsoft Excel application now I am getting this error. 

Here is some information regarding this

1. Gave rights to ASPNET and network service to my web app directory to try to fix this error. 

2. The exact same process works on my Windows 2003 server and my Windows 7 development machine. I am trying to get this going on a different windows 2003 machine that is outside of our domain.

3. Developing on windows 7 64 bit with office 2010 installed. Also excel 2010 is installed on my Web server

4. Here is the code that is causing the error: The last line is causing the error.:

GC.Collect();
            MyXl = new Microsoft.Office.Interop.Excel.Application();
            MyXl.Visible = false;
            
            MyWb = (Microsoft.Office.Interop.Excel._Workbook)(MyXl.Workbooks.Add(Missing.Value));
            int test = 0; 
            MySheet = (Microsoft.Office.Interop.Excel._Worksheet)MyXl.ActiveSheet;
            if (reader.HasRows)
            {
                int InRow = 2; 
                for (int i = 0; i < Nu

What's wrong with MSDAORA.1 (Microsoft OLE DB Provider for Oracle) in SQL2008R2

  
Dear Gurus, I'd install a test SQL2008R2 on Windows Server 2008 R2 x64 Version. And Install Oracle  11.2.0.1.0 both x86 and x64 version Client. And I'd create a new AS Database as AS System Administrator. And then create a new Datasource with "Microsoft OLE DB Prodiver for Oracle" Provider. When I test connection ,  it tested succeed. Then I create Datasource View / Dimension / Cubes etc... But when I process then Database. There is a error occurs. "Database Access Module Error , Provider 'MSDAORA.1' not register" I'd follow http://msdn.microsoft.com/en-us/library/ms152516.aspx change SQL Server 2008 R2's registry key as the note. Then restart this server . But still same error !   And I'd success process the cube if I change provider as "Oracle OLE DB Proverder"   Is MSDAORA been obsolete in SQL SERVER 2008 R2 ?Wilson

Unable to open physical file - Operating system error 5: 5(error not found) Microsoft SQL Server: Er

  
I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.   I get the following message: Unable to open physical file "C:\ArrowSQL\Arr@Data\Arrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".   I have loaded SQL and the database fiel and directory with the same user acccount which is a local adminstrator ont hsi machine. I have checked that I have read/write access to the file.   The machine runs Windows Vista Business. SQL has SP 2 loaded.   What causes this?

How to install Microsoft OLE DB Provider for Oracle

  
I am using an SSIS Package to get the data from Oracle DB to  SQL server 2005 DB. I am using Micorsoft OLE DB provider for oracle for creating a connection manager to connect to ORACLE 10 g.   The package runs great in my local PC.  when I move the package to the Server ( Microsoft windows server 2003 R2, Enterprise x64 edition) which also has SQL server 2005 .  the package fails to run showing the error: " the AcquireConnection method call to the connection manager "HRDATA" failed with error code 0xC0202009."   I tried to see if the Microst OLE DB provider for  Oracle is installed or not  using the .udl file.  The provider tab in .udl file does not show any provider named " Microsoft OLE  DB provider for Oracle"   Can anyone please help me by telling how can I installed the Microsoft OLEDB provider for Oracle, given my server is ( Microsoft windows server 2003 R2, Enterprise x64 edition)  and my source data base is  ORACLE 10g.

Analysis Services Using Oracle as a Data Source Data Types mismatch System.Int32 and System.Int64

  
Hi everyone, I searched for this issue but there is only 4 questions about it in this forum from 2007 I hope that someone can help me. Im usign SASS 2008 using a Oracle as a datasource.  I already have my fact tables linked with dimensions, lets say, FACTID System.Int64 with DIMENSIONID System.Int64 (My dimensions are replaced by named querys and work perfectly) I add a new table to my DSV and the NEWDIMENSIONID looks like System.Int64, but at the moment I replace the table with a named query (I have to use Oracle quering) the NEWDIMENSIONID changes to System.Int32 .  After that I cant relate the fact table with the dimension table. Actions: Looked for the columns that relate from Oracle... both are NUMBER(5). Looked for the differences between my other tables that are already related as System.Int64 and there is not a single difference between the ones that works and the one who doesnt. Solutions Ive tried and didnt work: 1. Cast the column as SQL query didnt work it send an error.  Looks kind of obvious because we are quering Oracle... but I had to try.  CAST( X AS BIGINT) 2. Cast the column as Oracle query . TO_NUMBER 3. Do it inside the server using the Analysis Services Enterprise insted of my Analysis Services Developer. Same issue.   Any ideas? suggestions?   Please? Thank you very much ;) Sincerly Adriana L. PS. At the begging of

When attempting to install Security Update Microsoft for the Microsoft 2007 Office system updates (u

  
When attempting to install "Security Update Microsoft for the Microsoft 2007 Office system updates (updates KB2277947 and KB982331)" the sintallation fails and then I recieve the error "The detection failed, this can be due to a corrupted installation database". System Info: XP Home Edition Version 2002 Service Pack 3 Intel Atom CPU N270 @ 1.60 GHz I am running XP and have installed and run the "Fit It" tool, to no avail. I even tried downloading each update individually, from the Microsoft site, instead of through the automatic update. I also read this same question posted by another user (link: http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/cfa66cd3-2aa2-44ee-9393-ffae41d4f70c/) only to find his info contained no answer either. How do I fix this so that I can get these updates installed?

Microsoft ole provider for oracle is not available in my VS 2008 list of providers when setting up C

  
Hi, Trying to set up a connection manager using Microsoft OLE Provider for Oracle, but it is not in the list of Providers. I do have Oracle Provider for OLE DB. But I need the former. I tried installing MDAC 2.8 but I get a message saying that it cannot be installed because it is part of the OS already. So, how do I get Microsoft OLE Provider for Oracle as an available provider? Thanks!--ACG

System.TypeLoadException: Could not load type 'Microsoft.Office.Server.Security.LdapMembershipProvi

  
So this is odd, I am attempting to setup FBA with Sharepoint Foundation 2010 and i get the following Error: (from ULS log viewer): System.TypeLoadException: Could not load type 'Microsoft.Office.Server.Security.LdapMembershipProvider' from assembly 'Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at System.Web.Compilation.BuildManager.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase) at System.Web.Configuration.ConfigUtil.GetType(String typeName, String propertyName, ConfigurationElement configElement, XmlNode node, Boolean checkAptcaBit, Boolean ignoreCase) and in IIS Logs: Exception information:     Exception type: ConfigurationErrorsException     Exception message: Could not load type 'Microsoft.Off

Not able to see microsoft oledb provider for oracle in sql server 2005 providers

  

Hi,

can any one help me, environment window server 2003  64 bit and sql server 2005 sp3 64 bit and i have installed oracle client  10g 32 bit. problem is, I am not able to see the provider name  while creating linked server.


hi i m getting "failed to install assembly:- microsoft.visualbasic.vsa.dll because of system error:-

  
pls help me rectifying this error n pls guide me to rectify it

hi i m getting "failed to install assembly:- microsoft.visualbasic.vsa.dll because of system error:-0x80131107" during the installtion of microsoft .net framework 2.0

Sharepoint & SSRS 2008 "System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft

  

my environment as below:

1- SERVER A (SQL server DB 2008 sp1)
2- Server A (SSRS 2008 sp)
3- SERVER B MOSS 2007 sp1
I configured the SSRS to be sharepoint intergated mode but when i  hit the Web Service URL i got the error below:

Reporting Services Error

  • The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled)

    System.BadImageFormatException: Could not load file or assembly 'Microsoft.Sharepoint.Search

      
    I've done a fair amount of digging on this and have found this post that suggests that its caused by the .dll being marked for AMD and not for ia64.  This error occurred after I linked the new cluster to the existing sharepoint farm prior to migration.  Then started moving project files over and rebuilding for the upcoming new server name.  I've tried copying the .dll from the regular 12 hive into the GAC but it won't make a change to the processor architecture.

    Do I need to re-run the configuration wizard or something?  Anyone have an easy fix?  Thanks.
    Jack Burnish

Oracle connection fail with Microsoft OLEDB provider for Oracle MSDAORA.1

  

Hello,

On my dev server I have working ssis packages that use connections Microsoft OLEDB provider for Oracle MSDAORA.1 and Oracle provider for oledb and OracleClient data provider.

I use one or the other according to my needs.

In anticipation and to prepare for the build of a new production server, I have build a test server from scratch and deployed to it the entire dev.

Almost everything works except Microsoft OLEDB provider for Oracle.

ssis packages on the test machine will return an error

Error at Pull Calendar from One [OLE DB Source [1]]: The AcquireConnection method call to the connection manager "one.oledb" failed with error code 0xC0202009.

Error at Pull Calendar from One [DTS.Pipeline]: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

[Connection manager "one.oledb"]: An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle error occurred, but error message could not be retrieved from Oracle.".

I have used the same installers for OS, SQL and Oracle SQL*Net on both dev and test machines. The in

System.Data.SqlClient.SqlError: Could not continue scan with NOLOCK due to data movement. (Microsoft

  

Hi,

I am trying to restore SS2000 database backup .BAK (full backup) on to SQL Server 2005 and at then end SSMS throws an error

System.Data.SqlClient.SqlError: Could not continue scan with NOLOCK due to data movement. (Microsoft.SqlServer.Smo).

Any help will be appreciate on this.


How to get all the rules of an association model using "CALL System.Microsoft.AnalysisServices.Syste

  

Dear All,

I am using sql server analysis services to build an association model, once the model is built i am using "CALL System.Microsoft.AnalysisServices.System.DataMining.AssociationRules.GetRules"  procedure to get support,importance,probability for a rule  by passing the name of a model (1 st parametre), but this procedure can retreive only max of 2000 rules though there are more than this depending on the sorting condition( 4 th parametre) specified in the above procedure.

Is it possible to get all the rules of a model using the above procedure?

If not pls suggest some alternative to get all rules of a model with support,probability and importance.

Thanks in Advance.


How to get all the rules of an association model using "CALL System.Microsoft.AnalysisServices.Syste

  

Dear All,

I am using sql server analysis services to build an association model, once the model is built i am using "CALL System.Microsoft.AnalysisServices.System.DataMining.AssociationRules.GetRules"  procedure to get support,importance,probability for a rule  by passing the name of a model (1 st parametre), but this procedure can retreive only max of 2000 rules though there are more than this depending on the sorting condition( 4 th parametre) specified in the above procedure.

Is it possible to get all the rules of a model using the above procedure?

If not pls suggest some alternative to get all rules of a model with support,probability and importance.

Thanks in Advance.


Trying to connect to Microsoft OLEDB Provider for Oracle ...but giving the following error

  

Hi All,

When I am trying to Connect to Oracle 11g using SSIS OLEDB source adapter ....Its giving me the following error.

TITLE: Connection Manager
------------------------------

Test connection failed because of an error in initializing provider. ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Tried various ways by changing the TNSNames file and Sqlnet file...but I am unable to connect to oracle database...

If any body have any ideas...can you share with me ASAP...Appreciate your help.

Thanks,

 


vineesh1701
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend