473,386 Members | 1,820 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Type 'ADODB.Connection' is not defined.

I'm getting the following error in my application:

Compiler Error Message: BC30002: Type 'ADODB.Connection' is not defined.

Source Error:

Line 112: if(Request.Form("HdnQuestionCount") = 0) thenLine 113:Line 114:
Dim objDataConn as ADODB.ConnectionLine 115: Dim objRSList as
ADODB.RecordSetLine 116: dim iRecordCount as integer

I've tried running gacutil.exe /I adodb, but get the following error:

Failure adding assembly to the cache: The system cannot find the file
specified.

Any suggestions would be appreciated.

Thanks.

Joe


--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access
Feb 19 '06 #1
3 7174
Joe,
"ADODB.Connection" is classic ADO which you would normally use only with
classic ASP and VBScript. Is there any particular reason why you need to do
this instead of using the ADO.NET managed providers?

Is this some sort of a converted project from Classic ASP?

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Joe Befumo" wrote:
I'm getting the following error in my application:

Compiler Error Message: BC30002: Type 'ADODB.Connection' is not defined.

Source Error:

Line 112: if(Request.Form("HdnQuestionCount") = 0) thenLine 113:Line 114:
Dim objDataConn as ADODB.ConnectionLine 115: Dim objRSList as
ADODB.RecordSetLine 116: dim iRecordCount as integer

I've tried running gacutil.exe /I adodb, but get the following error:

Failure adding assembly to the cache: The system cannot find the file
specified.

Any suggestions would be appreciated.

Thanks.

Joe


--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

Feb 19 '06 #2

Joe,

While it may not make supersense this moment, ADODB has been utterly
abandoned in DotNet.

The only time one might use them, is to talk to some legacy code.

The "new kids on the block" are the
DataSet
IDataReader

Do a google for DataSet IDataReader ADODB and read up.
Here is a decent one.

http://www.simple-talk.com/2005/06/1...t-data-access/


"Joe Befumo" <jo*@befumo.com> wrote in message
news:43***********************@news.newsdemon.com. ..
I'm getting the following error in my application:

Compiler Error Message: BC30002: Type 'ADODB.Connection' is not defined.

Source Error:

Line 112: if(Request.Form("HdnQuestionCount") = 0) thenLine 113:Line 114:
Dim objDataConn as ADODB.ConnectionLine 115: Dim objRSList as
ADODB.RecordSetLine 116: dim iRecordCount as integer

I've tried running gacutil.exe /I adodb, but get the following error:

Failure adding assembly to the cache: The system cannot find the file
specified.

Any suggestions would be appreciated.

Thanks.

Joe


--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

Feb 19 '06 #3
Yeah, it was. I ultimately got it working, then learned about the better way
of doing things in Dot.Net, so I converted, successfully. Thanks.

Joe

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:02**********************************@microsof t.com...
Joe,
"ADODB.Connection" is classic ADO which you would normally use only with
classic ASP and VBScript. Is there any particular reason why you need to
do
this instead of using the ADO.NET managed providers?

Is this some sort of a converted project from Classic ASP?

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Joe Befumo" wrote:
I'm getting the following error in my application:

Compiler Error Message: BC30002: Type 'ADODB.Connection' is not defined.

Source Error:

Line 112: if(Request.Form("HdnQuestionCount") = 0) thenLine 113:Line
114:
Dim objDataConn as ADODB.ConnectionLine 115: Dim objRSList as
ADODB.RecordSetLine 116: dim iRecordCount as integer

I've tried running gacutil.exe /I adodb, but get the following error:

Failure adding assembly to the cache: The system cannot find the file
specified.

Any suggestions would be appreciated.

Thanks.

Joe


--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access


--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access
Feb 19 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jack | last post by:
Hi, I am trying to add a new record to a main page. This page is the processing page to a form. However, I am getting the following error message: Error Type: ADODB.Recordset (0x800A0BB9)...
6
by: Earl Anderson | last post by:
In A97 on WinXP, I'm trying to use a KB function to provide the next sequential number in a custom counter (a table with two fields-- and ). When I run it, I get the "User-defined type not...
1
by: PJ | last post by:
I'm getting an error message when posting information from my asp page to the database. This is the error message: DODB.Connection error '800a0e7c' Parameter object is improperly defined....
1
by: Omatase | last post by:
Here is my code: CDO.Message iMessage = new CDO.MessageClass(); string sFrom; string sDate; iMessage.DataSource.Open(bstrURLItem,null, ADODB.ConnectModeEnum.adModeRead,...
0
by: dmckenna | last post by:
I've been tasked to upgrade an old system and there's many different versions of VB code that uses MDAC to talk to MSSql. Do you know what the difference is between the two code versions? Is there...
1
by: mudasserrafiq | last post by:
I am using following asp file default.asp <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <META http-equiv=Content-Type content="text/html; charset=windows-1252"> <META content="0...
13
by: forrestgump | last post by:
I am currently trying to use the below VBA to import information into excel from access. This VBA is in the excle sheet:- Public Sub getrs() Dim adoconn As ADODB.Connection Dim adors As...
2
by: colesslow | last post by:
i have these asp files to edit a record in my sql server..but it can't be done. the error is Error Type: ADODB.Recordset (0x800A0E7D) The connection cannot be used to perform this operation. It...
1
by: shivasusan | last post by:
Hi Friends! Please Help me! How i can solve this error? Please explain me, what is the error and how to solve? Error Type: ADODB.Recordset (0x800A0E7D) The connection cannot be used to...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.