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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Attunity connector for Oracle -here is a tip if you use Project Real [admin].[Configuration]. entrie

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

Hi Folks,

Here is a tip that is not documented if you use Oracle Connections in Project Real--.There is a table called admin.configuration.configuredvalue that holds connection strings

Here is the  Attunity Oracle connection string





Here is the old Micorsoft OLE DB for Oracle connection string



'Provider=MSDAORA.1;Password=xxx;User ID=TRIAL;Data Source=GoogleD;Persist Security Info=True'


cheers Dave



View Complete Post

More Related Resource Links

FAST non-admin configuration - middleware.cfg not found?!

I'm stuck with an interesting error as i try to configure a non-admin FAST search node.  Admin configuration was successful, with deployment.xml referencing the 2ndary server, as noted in the install_info.txt I'm repeatedly receiving this same error in the non-admin configuration error log: C:\FASTSearch\bin\MonitoringServiceConfig.exe" Output - Error: The file 'C:\FASTSearch\etc\middleware.cfg' was not found. This file is in the Admin FASTSearch\etc folder, but not on the this new server i'm attempting to add to the farm.  Best i can tell there is some sort of communication issue between the two servers, but i havent been able to discover what it is?! Running the install by the install script throws a communication error related to possible ipsec issues.  


Hi All, I am attempting to implement the Project Real BI solution (http://www.microsoft.com/sqlserver/2005/en/us/project-real.aspx) It is designed for 2005. I am running two instances of SQL Server: 1. 2005 (default instance) 2. 2008 (named instance) AS 2005 is not installed, AS 2008 is. I have been able to get the source transactional and DW up on my SQL2005 instance. And have implemented the cube onto my AS 2008 instance. However, when i run the SSIS packages it fails when it gets to the AS_Dim_Process_MT.dtsx package - with the following error: [Execute Process Task] Error: In Executing "C:\Microsoft Project REAL\ETL\ETL\ascmd.exe" " -S "(local)" -d "REAL Warehouse Sample V6 MT" -v  maxparallel=6 ProcessType=ProcessUpdate -i "C:\Microsoft Project REAL\ETL\ETL\Dim_64bit.xmla" -T "C:\Microsoft Project REAL\ETL\ETL\Dim_process_trace_20100915_165920.csv" -Tl low " at "C:\Microsoft Project REAL\ETL\ETL", The process exit code was "1" while the expected was "0". I am guessing it has something to with either: 1. ascmd.exe and it's compatibility with 2008, or 2. the XMLA and it's compatibility with 2008? Also, in the project real directory there is also a Dim_32bit.xmla which i think it should be picking up (i am on 32 bit). Any assistance greatly appreciated. Thanks, Clay   &nbs

Adding Oracle table into SSIS project --Oracle error occurred, but error message could not be retrie

Hi all I am new to design SSIS packages,to day I stated creating package SSIS package and adding the Tables,while adding tables,one of the table giving an below error . I verified the table structure it has one "CLOB" datatype. can some body help how to add this table( whole idea of the package is I have Dump those tables with structure and Data to SQL Server 2008 Database)  =================================== Oracle error occurred, but error message could not be retrieved from Oracle. Data type is not supported. (Microsoft Visual Studio) ------------------------------ Program Location: at System.Data.OleDb.OleDbCommand.ProcessResults(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.PrepareCommandText(Int32 expectedExecutionCount) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType) at Microsoft.AnalysisServices.Design.DataSourceDesigner.AddRemoveObjectsFromDSV() Thanks in Advance.   SNIVAS

procedure of doing project in real time environment



i am new to .net, i know fundamentals/basics only, i am using vs2008,sqlserver2005

i want to do a project with asp.net(using c#), SQlServer, Ajax, etc.

but i dont know how to start a project in real time scenario.

please guide me in detail. .

plz z z z z

thanks in advance 

Use VS Project Module to Deploy Page to Central Admin


Does anyone know if it's possible to use a Visual Studio project Module to provision a page to the Central Admin site when a SITE feature is activated?

If I use  

<Module Name="MirrorAdmin" Url="_admin/Datagility">
    <File Path="MirrorAdmin.aspx" Url="MirrorAdmin.aspx" />

(or similar, I haven't copied and pasted) the file gets deployed to a folder called _admin under the site where my solution gets deployed. Do I need to create a separate solution and deploy it to the admin site or is there something I can use in the Url= element to deploy the page to the correct place?


Hi can u please explain me WWF taking real time scenario / live project

please explain me WWF  taking real time scenario / live project

Analysis Services Project under VS2008 not honoring Configuration Settings ?

I have a solution with SSRS and SSAS projects in it. Since we have 3 different environments I use VS Configurations for the individual settings. In each of these environments different groups have access to these cubes. However if I deploy the project the roles on the instances are always overwritten by the settings defined in the project. And it seems it is not possible to have different role settings that for each VS configuration. Am I missing something, it should somehow be possible to use the VS configurations to have different permissions per deployment environment?!

Package Configuration causing problems with Oracle Connection


Hi All,


We need to import the data from Oracle 10g database to SQL Server 2005 database.

Solution Picked:

In order to accomplish the above, we used SQL Server Integration Services along with Business Intelligence Developer Studio.


Base Details:

There are around 17 packages, each retrieving data from Oracle and storing into SQL Server based on current date. Following are the steps used:

  1. Get current date from SQL Server [Execute SQL Task].
  2. Create Query based on date obtained from step (1) [Script Task].
  3. Based on query obtained from step (2). Inside a [Data Flow Task] following sub actions are performed:

    Actions performed in [Data Flow Task]

  1. Retrieve data from Oracle database using query through [OLE DB Source].
  2. Perform any data modifications to correct the data [Derived Column].
  3. Store data in SQL Server [OLE DB Destination].
  4. Rejections are saved in text file [Flat File Destination].

64 Bit ASP.NET Project - Attempt to load Oracle client libraries threw BadImageFormatException.


I am getting a "Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed."

I have a main ASP.NET project which is 64 bit(set to Auto though) and another oracle database project 64 bit(set to Auto). I am getting the above error in "Connection.open()' in the oracle database project. I am using System.Data.Oracle client, the 64 bit version-2.0.50727.5420

Edit.I thought I would mention that I am using the latest Instant Client v from the Oracle to run my program.
....I also tried the ODAC provider from Oracle. Same problem.

Also the oracle database project seems to run fine in x64 bit mode by itself without any problems. The way i verified that it was running in 64 bit mode was I just looked into task manager while the Oracle database project was executing and there was no *32 in the name of the project. All the frame references to this project are already 64 bit. It seems like the issue is the ASP.NET project which is at 3.5

Meanwhile below are things i did to try resolve the issue .

Project Example: ASP.NET MVC + SubSonic Architecture

use of SubSonic to provide the DAL in association with some ASP.NET MVC sites and was waylaid in my original intent to throw up a post summarizing the architecture we're using for the effort. Well I've finally gotten around to it. Recall that in his fake it till you need it post, Dave provided a window on our architecture that I'll build upon here

GridView Sorting/Paging : 'REAL' AJAX with Asp.Net Series

This is a continuation of my 'REAL' AJAX with Asp.Net (not Asp.Net AJAX) series posts for those of us trying to stop relying on Asp.Net 'AJAX'.

Ok, nothing too dramatic to start things off, we are going to make some tabled data sortable and pagable all without using a bit of postback. Not only that, but it is going to be incredibly easy!

VS2010 Professional .NET 4.0 Remote Debugging ASP Website Project


Trying to remote debug ASP website from VS2010 Pro to Windows Server 2003 machine.  Specifically, trying to debug a Web Service, but breakpoint says, "The breakpoint will not currently be hit. No symbols have been loaded for this document."  This happens for all compiled code though.  I have read this is due to missing PDB files and the work around is to manually copy them, as noted here.  Problem is, I cannot find any PDB files for my project, except referenced libraries, which I can remote debug.


  • web.config has <compilation debug="true">
  • Debugger is attached to wewp.exe process on remote server
  • Installed VS2010 remote debugger from DVD (as I can remote debug referenced libraries)

This is beyond frustrating.  I migrated my code from VS2008 .Net3.5 to VS2010 .Net4.0 to take advantage of the inherent multithreading framework.  Debugging works when using local host and was stable until deployment to test server.

Thanks in advance,


How can I be sure that my entire project is up-to-date and free of errors in VS2010?


Seems like a stupid question, but I will go to Build > Build Solution many many times and the build will succeed many many times, then I will put in a minor syntax error and the build will fail, BUT the build will not fail because of the minor syntax error; it will fail because of an unresolved type that I put in about twenty compiles ago. And then I will fix the minor syntax eror, and the compiler will still complain about the unresolved type. Here is my code:

<%@ Register TagPrefix="FTB" Namespace="FreeTextBoxControls" Assembly="FreeTextBox" %>
  <form runat="server">
  Hello World!!  

Pretty simple, really. I go to Buld > Build WebApplication1 and it runs OK. Now, if I put in a minor syntax error, such as substitute "forrrrrrrm" for "form" and then try to Build Solution, it complains not about the misspelled word, but about the FreeTextBox. And then if I correct the misspelled wird, it still complains about the FreeTextBox. Which leads me to believe that Building the Solution does not check absolutely 100% everything that needs to be checked. Is there a more thorough way of compiling a program that I need to use?

is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site p


is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project


my current project references




i have a very annoying iis problem

iis server stops working until app pool is recycled


i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem


ASP.NET Configuration not opening


I recently upgraded to VS 2010 and downgraded to SQL Server 2005. Now when I go Website > ASP.NET Configuration nothing happens.

It's likely this has to do with the fact that when I was installing SQL Server I got the 'ASP.net Version Registration requirement' warning, as well as the 'Failed to find the ASP.net Version Registration requirement with MS IIS'.

Anyone know what I need to get ASP.NET Configuration working?

Business Intelligence Reports Project in Visual studio 2008 ?



I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..

Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

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