eVB: Cannot connect to ADOCE
Try dropping the "data source =" from the ConnectionString statement and see
if that works. I.E.:
connDatabase.ConnectionString = "\physician.cdb"
Also make sure that "\physician.cdb" is the fully-qualified path (WinCE
doesn't understand relative paths).
>Thanks for the response. Still getting the same error. I tried opening
>the connection using the following code
>Private Sub Command1_Click()
>Set connDatabase = CreateObject("ADOCE.Connection.3.1")
>connDatabase.ConnectionString = "data source = \physician.cdb"
>What I am doing wrong......!!!!!
>> Try Opening the connection before creating the Recordset object. That
>> took care
>> of the problem on my system.
>> -----Original Message-----
>> I am trying to connect using ADOCE 3.1 on eVB.
>> I have an HP Jornanda 420 Palm-size PC (WinCE2.11). The reference to
>> ADOCE3.1 is added in eVB using Project -> References ->Microsoft CE
>> ADO Control 3.1
>> Getting the same error on Emulator Palm-size PC2.11
>> Dim objConnection 'Declare a variable for the connection
>> Dim objRecordset 'Declare a variable for the recordset
>> Set objConnection = CreateObject("ADOCE.Connection.3.1")
>> Set objRecordset = CreateObject("ADOCE.Recordset.3.1")
>> Application Error:
>> An Error was encountered while running this program. ActiveX
>> componenet can't create object: 'CreateObject'
>> Any help!!!!