Connect to Remote Database with ADOCE?

[riznick]

Is it possible to connect to a remote database with ADOCE? The SQLCE method is only a workaround, and i would like to be able to bypass it.

 

[nspl]

Hello,

I am developing a web application in Pocket PC using ASP and Pocket Access Database. Could anyone tell me the connection string to use in ASP to connect pocket access database.
I have used microsoft access driver name in the connection string while connecting from ASP to Microsoft Access Database on a Desktop PC.
Could anyone tell me the name of the Pocket Access Driver to use in the connection string in ASP on a Pocket PC. I would also appreciate if someone knows a way other than using Pocket Access Driver.

If possible, please help me at the earliest.

Thanks & Regards,
Neeraj Mirani

 

[impercepta]

I've had a heck of a time cracking a CDB file I ran across. I finally realized I could query it directly. Check out

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adoce31/html/ado30ref_82.asp.

This has the specifications for creating your ADOCE connections and recordsets.

Dim connDatabase
Set connDatabase = CreateObject(“ADOCE.Connection.3.1”)
connDatabase.ConnectionString = “data source = \MyDatabase.cdb”
connDatabase.Open


Now I've not had good luck getting my windows script host file (.VBS) to accept that (“ADOCE.Connection.3.1”) connection. Anyone have any advise on that?
Thanks!