Connection to Access database with Mobile 6.5

CamKenny — Thu, 22 Mar 2012 14:48:34 GMT

I have an ArcPAD application that was developed back in 7.x that is programmed using vb. I use a connection string to connect to the access database to store my attributes. Connection was done using ADO and worked quite well, both for the full windows install and also the CE versions (back in the day).

Here is the connection string(s):

' Windows 95/98/NT/2000
   Case 1, 2

    Set objConnection = CreateObject("ADODB.Connection")
    objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDataPath & "AgCapture-CPEd.mdb"
    Set rstLandOwnerTbl = CreateObject("ADODB.recordset")

   ' Windows CE
   Case 3
    Set objConnection = CreateObject("ADOCE.Connection.3.1")
    objConnection.Open strDataPath & "AgCapture-CPEd.cdb"
    Set rstLandOwnerTbl = CreateObject("ADOCE.recordset.3.1")

Can someone please help me out to setup a connection string using much the same technology but for Windows Mobile 6.5?

Re: Connection to Access database with Mobile 6.5

DeniseKing — Fri, 23 Mar 2012 12:08:39 GMT

Cam, what version of ArcPad are you using now?

Denise

Re: Connection to Access database with Mobile 6.5

CamKenny — Fri, 23 Mar 2012 15:41:24 GMT

I am currently using 7.0.1 but also have 10 and the windows connection works with 7 all the way to 10 on both xp and windows 7

I am not committed to using ado but it is what I know right now 🙂

topic Connection to Access database with Mobile 6.5 in ArcPad Questions

Connection to Access database with Mobile 6.5

Re: Connection to Access database with Mobile 6.5

Re: Connection to Access database with Mobile 6.5