As we are passing through critical phase of the project and we are facing following issues which need to be resolved.Please help on this.
Currently we are transferring Data from SQL Server to DB2 using SSIS (SQL Server 2008).The IBM DB2 version is DB2 ESE 9.1 Fix Pack 5 on Linux 4.8.
1] Unable to connect with IBM DB2 using IBM DB2 .NET Data Provider 9.1.5
in SSIS 2008 at run time (although the connection is tested successfully with IBM DB2 using
IBM DB2 .NET Data Provider 9.1.5 in SSIS 2008) and the error is
"[ADO NET Destination ] Error: An exception has occurred during data insertion, the message returned from the provider is: Object reference not set to an instance of an object. "
I tried to use CozyRock DB2 Destination component instead of ADO destinatoin Component then i am able to use IBM DB2 .NET provider at run time.
Also i tested connection successfully using IBM DB2 .NET Data Provider 9.1.5
View Complete Post
View Complete Post
I am trying to create an Ad Hoc report project using SSRS2005. We are using Oracle 10G and I have Visual Studio2005.
I have the Oracle client installed and I am an administrator.
I create a new "Report Model Project " and attempt to create a new data source, but with "Create a data source based on an existing or new connection " selected, I click on "new " where I should be
able to specify the database, but the Provider shows "SqlClient Data Provider " and is grayed out so I can't change it.
How do I tell it I want to point to Oracle data? I have no trouble normally doing this with an SSRS report but this is the first time I have tried an Ad Hoc report so I don't know what the problem is.
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 !
The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers.
MSDN Magazine December 2001
MSDN Magazine August 2001
I am using visual studio 2005 and sql server 2005.
I am developing a small quiz application and i have stored the connection string in app.config file which is given below.:
<?xml version="1.0" encoding="utf-8" ?>
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Quiz Application.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
i have retrieved connection string property through configurationmanager class
and when i m connecting to database it gives me a runtime error:
Sql Exception was unhandled
System.Data.SqlClient.SqlException was unhandled Message="An attempt to attach an auto-named database for file F:\\Quiz\\Quiz\\bin\\Debug\\Quiz Application.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located
Here is my SP:
create or replacePROCEDURE ZGETUSERSSIGNONS (vUid IN VARCHAR2, p_getuserssignon_recordset1 OUT SYS_REFCURSOR) ASBEGIN Open p_getuserssignon_recordset1 for SELECT Distinct(Userid), UserPassword, SecurityLevel, ActiveStatusFROM ZSIGNON WHERE substr(UserId,1,2) <> vUidOrder By UserId;END ZGETUSERSSIGNONS;
I would like to run this SP from code and fill a gridview with the result.
I am not sure how to go about this, as I have found several different examples, other than the one I think I need.
I am using the oracle data provider and I have an input parameter (vUid, which will equal "zz").
First question. When filling a gridview with a result set from a stored procedure should the recordset OUT be defined as a REFCURSOR (like i did above)?
Do you have example code as to how to execute the SP and fill a gridview? I keep trying different variations of code i've found on the internet without any success other than getting more confused.
(I am using VS 2005, VB).
I am attempting to use the 64-bit OLEDB Provider for Access found in the "Microsoft Access Database Engine 2010 Redistributable" to connect to and query an Access 2003 database that is on another server separate from my SharePoint server. I have not had
any success making the connection. My SharePoint server is Windows Server 2008 SP2 and I am running MOSS 2007 (patched up to the April 2010 CU)
Here is the connection info in my Application Definition XML:
<Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RevertToSelf</Property>
<Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">OleDb</Property>
<Property Name="rdbconnectionData Source" Type="System.String">\\server1\share1\Lessons.mdb</Property>
<Property Name="rdbconnectionProvider" Type="System.String&qu
I am designing a data form - adding some formatting etc. I am able to see the webpart correctly in SPD split view, but when I trying to preview it, it gives me the following error
Thank you for advance.
I created the web application using asp.net 2.0, c# and sql server 2005
sometimes i am getting the following error,
Message: Unable to validate data.Source: System.WebTargetSite: Byte GetDecodedData(Byte, Byte, Int32, Int32, Int32 ByRef)StackTrace:
buf, Byte modifier, Int32 start, Int32 length, Int32& dataLength) at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString)
I am trying to pick data from the database through data access layer and use those values in different text boxes on the page.Basically on a click on the form, modal popup is planned to read the database and put the values into different text boxes which can be latter changed/ updated.
What I am unable to do is accessing those values on the form itself progamatically. I will be thankful for any ideas and help.
My data access component is as follows:
new SqlParameter ("@reg_id", SqlDbType.Int ));"@reg_id"].Value=reg_id;try