ActiveX component can't create object

[mikeld]

I am using eMbedded Visual Basic and trying to develop an app on a pda. I am using the following code in the "click" event of a button on a form. I have already added the ADO reference. All I want to do is connect to an Access Database, but I keep getting ActiveX component can't create object. Any help would be GREATLY appreciated!!!! Thanks in advance.


Private Sub Command1_Click()
Dim connDatabase
Set connDatabase = CreateObject("ADOCE.Connection.3.0&quot
connDatabase.ConnectionString = "data source = D:\Pocket_PC My Documents\pda.mdb"
connDatabase.Open


End Sub

 

[JohnYingling]

I am unfamiliar with CE or ADO but isn't that last parameter supposed to be an "ordinal" (whole number) entry point? ADOCE.Connection.3.0.

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[Guest_imported]

You probably need to set the provider. The default provider is to CEDB which connects to *.cdb. You'll need to look up the provider for Access.

I hope this helps.

Dena