•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 402,549 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,319 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 17407 | Replies: 5
 |
•
•
Join Date: Jul 2004
Posts: 8
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I am trying to connect to an IBM AS/400. Can anyone help me interpet the error and possible guid me what to do. Thanks
Code:
Dim myAS400Connection As New OleDb.OleDbConnection
myAS400Connection.ConnectionString = ("Provider=SNAOLEDB;" & _
"Data source=as820;" & _
"User Id=vbuser;" & _
"Password=vbuser")
myAS400Connection.Open()
Error:
Exception Details: System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154).
Line 46: myAS400Connection.Open()
[InvalidOperationException: The 'SNAOLEDB' provider is not registered on the local machine.]
Code:
Dim myAS400Connection As New OleDb.OleDbConnection
myAS400Connection.ConnectionString = ("Provider=SNAOLEDB;" & _
"Data source=as820;" & _
"User Id=vbuser;" & _
"Password=vbuser")
myAS400Connection.Open()
Error:
Exception Details: System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154).
Line 46: myAS400Connection.Open()
[InvalidOperationException: The 'SNAOLEDB' provider is not registered on the local machine.]
•
•
Join Date: Feb 2002
Location: New York
Posts: 862
Reputation:
Rep Power: 12
Solved Threads: 15
The C# Man, Myth, Legend
Are you sure you are using the proper OLE DB Provider?
-Ryan Hoffman
ASP.NET Specialist / Webmaster, Extended64.com.
Please do not email or PM me with support questions. Please direct them to the forums instead.
ASP.NET Specialist / Webmaster, Extended64.com.
Please do not email or PM me with support questions. Please direct them to the forums instead.
•
•
Join Date: Feb 2003
Location: Canada
Posts: 786
Reputation:
Rep Power: 9
Solved Threads: 25
Master Poster
Consider:
OLE DB Provider for AS/400 and VSAM (from Microsoft)
For more information, see: ConnectionString Property
To view Microsoft KB articles related to OLE DB Provider for AS/400 and VSAM
Or
OLE DB Provider for AS/400 (from IBM)
For more information, search: A Fast Path to AS/400 Client/Server
OLE DB Provider for AS/400 and VSAM (from Microsoft)
oConn.Open "Provider=SNAOLEDB;" & _
"Data source=myAS400;" & _
"User Id=myUsername;" & _
"Password=myPassword"To view Microsoft KB articles related to OLE DB Provider for AS/400 and VSAM
Or
OLE DB Provider for AS/400 (from IBM)
oConn.Open "Provider=IBMDA400;" & _
"Data source=myAS400;" & _
"User Id=myUsername;" & _
"Password=myPassword" Assistant Manager, Regional Pharmacy Information Systems
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
•
•
Join Date: Jul 2004
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
I tried using the IBMDA400 provider (instead of SNAOLEDB). Now it gives me another error. Is there a config seeting I am missing ... or ??
Code:
Imports System.Data.OleDb
Dim myAS400Connection As New OleDb.OleDbConnection
Dim myAS400Command As New OleDb.OleDbCommand
myAS400Connection.ConnectionString = "Provider=IBMDA400; Data source=AS820; User Id=vbuser; Password=vbuser"
myAS400Connection.Open()
Error:
Non-NULL controlling IUnknown was specified, and either the requested interface was not IUnknown, or the provider does not support COM aggregation.
Exception Details: System.Data.OleDb.OleDbException: Non-NULL controlling IUnknown was specified, and either the requested interface was not IUnknown, or the provider does not support COM aggregation.
Line 63: myAS400Connection.Open()
Code:
Imports System.Data.OleDb
Dim myAS400Connection As New OleDb.OleDbConnection
Dim myAS400Command As New OleDb.OleDbCommand
myAS400Connection.ConnectionString = "Provider=IBMDA400; Data source=AS820; User Id=vbuser; Password=vbuser"
myAS400Connection.Open()
Error:
Non-NULL controlling IUnknown was specified, and either the requested interface was not IUnknown, or the provider does not support COM aggregation.
Exception Details: System.Data.OleDb.OleDbException: Non-NULL controlling IUnknown was specified, and either the requested interface was not IUnknown, or the provider does not support COM aggregation.
Line 63: myAS400Connection.Open()
•
•
Join Date: Feb 2003
Location: Canada
Posts: 786
Reputation:
Rep Power: 9
Solved Threads: 25
Master Poster
Hmm not sure of what to say. I have searched the web for an answer, but just the same response for that error.... no solution found.
Try google yourself, maybe you will have better luck than me.
Try google yourself, maybe you will have better luck than me.
Assistant Manager, Regional Pharmacy Information Systems
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
•
•
Join Date: Apr 2007
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: OleDB Connection Have you verified that th SNAOLEDB provider is installed on your MAchine where this code is running :
You may want to go to registry and check it . OR simply hit test connect on UDL , if this gives a message that " provider is not " available try installing the Product again ( making sure that Data Integratiuon feature is selected on install). Or you may try add / remove programs to install only this feature.
Asmita
http://blogs.msdn.com/asmitaw/
You may want to go to registry and check it . OR simply hit test connect on UDL , if this gives a message that " provider is not " available try installing the Product again ( making sure that Data Integratiuon feature is selected on install). Or you may try add / remove programs to install only this feature.
Asmita
http://blogs.msdn.com/asmitaw/
•
•
•
•
Originally Posted by snufse 
I am trying to connect to an IBM AS/400. Can
anyone help me interpet the error and possible guid me what to do. Thanks
Code:
Dim myAS400Connection As New OleDb.OleDbConnection
myAS400Connection.ConnectionString = ("Provider=SNAOLEDB;" & _
"Data source=as820;" & _
"User Id=vbuser;" & _
"Password=vbuser")
myAS400Connection.Open()
Error:
Exception Details: System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154).
Line 46: myAS400Connection.Open()
[InvalidOperationException: The 'SNAOLEDB' provider is not registered on the local machine.]
|
•
•
•
•
•
•
•
•
DaniWeb ASP.NET Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
.net .net framework 3.0 access adsl adsl1 adsl2 adsl2+ ajax asp cable code combo connection custom data developer development dom download dropdownlist feed internet kb kbps mbit microsoft module msdn net network office per reader reuse second skin software sql testing theme throughput upload vista weather web windows workflow xml xoap 240000
- Updated : Simple ASP.Net Login Page (ASP.NET)
- mysql and oledb .net problems (MySQL)
- Change ADODE to OleDb (VB.NET)
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
Other Threads in the ASP.NET Forum
- Previous Thread: Regular Expression
- Next Thread: little help in siteMap!!!!plz!
