active x dll help user defined function not identified

I am trying to create an activex dll out of my project. So that I can then call it from an asp web page Here is an example of one of the functions.  When I try to compile it i get the error user defined type not defined
on the dim rs as adodb.recordset and on the dim cmd
actually on all the adodb stuff it bombs out.
Now when I use thios as a regular exe it is fine. I just coppied the coed over into an active x module. I thought that it be just fine. what do I not understand about it?
Can adodb be in the active x dll or not.
Or should the active x dll call the other project?

Public Function ship(ByVal numb As Integer, ByVal shipN As String, ByVal shipc As String, ByVal add1 As String, _
                     ByVal add2 As String, ByVal city As String, ByVal state As String, ByVal zip As String, ByVal country As String, _
                     ByVal amount As Integer, ByVal stroption As String)
Dim intNumbShip As Integer
Dim intupdateNumb As Integer
intupdateNumb = 0



   strShipName1 = shipN
   strCompName1 = shipc
   strAdd11 = add1
   strAdd12 = add2
   City1 = city
   strState1 = state
   intZip1 = zip
   strCountry1 = country
   strShipOption1 = stroption
   intshipAmount1 = amount

   


Dim rs As ADODB.Recordset
Dim cn As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "shipping", CONNECTIONSTRING, adOpenKeyset, adLockOptimistic, adCmdTable


   rs.AddNew Array("shipPerson", "ship_comp", "ship_Add1", "Ship_Add2", "ship_City", "ship_State", "ship_zip", "ship_Coountry", "ship_Amount", "ship_Option", "customer_ID"), _
                  Array(strShipName1, strCompName1, strAdd11, strAdd12, City1, strState1, intZip1, strCountry1, intshipAmount1, intshipAmount1, intOrderID)
   rs.Update
   rs.Close
   Set rs = Nothing

thanks for any help
shayne23dAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Erick37Commented:
From the Project->References menu make sure that your database reference is included ("Microsoft Activex Data Objects...").
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.