I am working on modifying an existing script that is used to open and modify a dbase4 file. The Problems that I am coming into are twofold. one I would like to be able to use this script file on both widows desktop and windows mobile. the "varset()" command for the desktop version is as follows:

Sub VarSet()
set cnn=CreateObject("ADODB.Connection")
set rs=CreateObject("ADODB.Recordset")

I know the adodb object is for the desktop odbc driver for dbase files, and have that set properly for the system dsn. I need to know what I would set that to for the windows mobile platform.

thanks

I have this problem also with mobile devices using Windows CE

simply for the reason that if you are using visual basic, the libraries must be there also including the frameworks.

unfortunately, most OEM manufaturer chops down the libraries alot and sometimes gives you headaches.

Got 2 mobile devices, both can support databases but no libraries for vb to use them well. the manufacturer remove them anyway. leaves me doing stuff in encrypted text file / emulated database.

then provide a fetching program in other pc to send those data in a real database after the device was docked.

--------

Still a stupid idea for some manufacturers to give you a database engine without libraries to connect to them using your created program. one thing more is the stupid idea to provide you with 1-2Mb installers for the libraries for some devices that have 3MB shared memory/flash disk for the OS files, memory files and for the library files..

---------

anyway, for some big companies, this already addressed by prodiving a harddisk..