PC Review


Reply
Thread Tools Rate Thread

ADODB Reference Error on vb6 conversion

 
 
Vic Spainhower
Guest
Posts: n/a
 
      21st Jan 2005
Hello,

OK - I'm trying to make the big jump from vb6 to vb.net. I took one of my
vb6 programs and ran it through the converter and I'm getting some ADO
errors that indicate a reference is required. I have a reference set to the
2.8 library.

Here's some examples of the errors:

Reference required to assembly 'ADODB' containing the type
'ADODB.CursorLocationEnum'. Add one to your project.
Reference required to assembly 'ADODB' containing the type
'ADODB.LockTypeEnum'. Add one to your project.
Reference required to assembly 'ADODB' containing the type
'ADODB.CommandTypeEnum'. Add one to your project.

What reference do I need to add? I put together a test program with an ado
recordset, referencing the 2.8 library and it worked fine. Under references
on the form it is properly showing 2.8 as being referenced. Of course the
form design won't come up because the error line is inside the generated
code "Initialize Component"!


TIA,


Vic


 
Reply With Quote
 
 
 
 
=?Utf-8?B?Q293Ym95IChHcmVnb3J5IEEuIEJlYW1lcikgLSBN
Guest
Posts: n/a
 
      21st Jan 2005
Rather than merely fix the exceptions you are seeing, I would alter the code
to use the ADO.NET model rather than use Interop to ADO. The enums should be
available through interop, but it is far less efficient than refactoring to
the new model.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

"Vic Spainhower" wrote:

> Hello,
>
> OK - I'm trying to make the big jump from vb6 to vb.net. I took one of my
> vb6 programs and ran it through the converter and I'm getting some ADO
> errors that indicate a reference is required. I have a reference set to the
> 2.8 library.
>
> Here's some examples of the errors:
>
> Reference required to assembly 'ADODB' containing the type
> 'ADODB.CursorLocationEnum'. Add one to your project.
> Reference required to assembly 'ADODB' containing the type
> 'ADODB.LockTypeEnum'. Add one to your project.
> Reference required to assembly 'ADODB' containing the type
> 'ADODB.CommandTypeEnum'. Add one to your project.
>
> What reference do I need to add? I put together a test program with an ado
> recordset, referencing the 2.8 library and it worked fine. Under references
> on the form it is properly showing 2.8 as being referenced. Of course the
> form design won't come up because the error line is inside the generated
> code "Initialize Component"!
>
>
> TIA,
>
>
> Vic
>
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADODB reference? Corta Microsoft Access VBA Modules 8 22nd Oct 2007 08:52 PM
ADODB to ADO.NET conversion sck10 Microsoft ASP .NET 4 21st Sep 2006 09:58 PM
ADODB.DLL - Error Object Reference not set to an instance of an object BuddyWork Microsoft ADO .NET 1 1st Aug 2005 04:15 PM
ADODB.DLL - Error Object Reference not set to an instance of an object BuddyWork Microsoft C# .NET 0 1st Aug 2005 09:06 AM
Object reference error in ASP.NET application using ADODB.dll just_jt Microsoft ASP .NET 0 3rd Dec 2004 01:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:06 AM.