Hi,
I've installed IBM Client Access V5M3 with the .NET Data Provider.
In C# I add a reference to the "IBM DB2 UDB for iSeries .NET Provider" for using the data provider. All work fine, I can create the iDB2Connection and other iDB2 object. But using VS2005 and the DbProviderFactories class, the GetFactory method fail with the message "Unable to find the requested .Net Framework Data Provider. It may not be installed.". But the provider is installed because I can use it, except with the DbProviderFactories class. If I call the DbProviderFactories.GetClasses() method the returned provider are:
Odbc Data Provider
OleDb Data Provider
OracleClient Data Provider
SqlClient Data Provider
SQL Server CE Data Provider
and I don't see the IBM data provider. Why this I need to do something "register" the provider
AS400 IBM.Data.DB2.iSeries .NET Provider
Hot Topic
- Where is mscorcfg.msc(beta 2)?
- Problem when sending email by System.Net.Mail
- How to Develop-Basic Network Application?
- Do Microsoft Recommend using Windows Server 2003 for ASP.NET development?
- Search and copy strings from steam in txt file
- Operation must use an updateable Query
- Queries reg Data Access in .NET Remoting
- Calling unmanaged c++ dll's and lib's into c# using visual studio 2005 beta
- DataGridView Problem
- regsvr32 and regasm
.NET Development
- .NET Framework 2.0 question
- Easy GAC question
- Loading external assemblies that are not strongly named
- Direct3D and Graphics object
- furious developer -- can't compile hello world using SDK on windows x64...
- Using C++ header in C#
- how will i detect immediately if changes have been made to the database?
- Receiving error: The root element is missing.
- Filling a datagrid from Oracle
- SerializationException on Sending Data Back to Serviced Component Via Remoting
AS400 IBM.Data.DB2.iSeries .NET Provider
Zakary
Something like this. I am not familar with this provider so please correct me.
<system.data>
<DbProviderFactories>
<add name="IBM DB2 UDB for iSeries .NET Provider" invariant="IBM.Data.DB2.iSeries" description=".Net Framework Data Provider for IBM DB2 UDB for iSeries" type="IBM.Data.DB2.iSeries.DB2Factory" />
</DbProviderFactories>
</system.data>
Please note that I am not even see this provider. Please check type attribute. You must supply type string of the factory class of this provider. Also this is possible that this provider does not support factories. In this scenario you will need implement this by your self. Is short words you will need implement class inherited from DbProviderFactory.
Kade
ZhangQing
If you need to connect to AS400 you must install an as400 oledb or odbc provider like IBM Client Access or Hit Software.
After install a provider you must set the connectionstring of the connection object. The data source property is the name or IP address of AS400.
bye
Marcin Obel
Thanks!