[ic] Convert access.gdbm to mysql

Neil Hambleton interchange-users@icdevgroup.org
Mon May 12 23:10:01 2003


> I would recommend something like:
>
> Database  access access .txt    __SQLDSN__
>
> ifdef SQLUSER
> Database  access  USER         __SQLUSER__
> endif
>
> ifdef SQLPASS
> Database  access     PASS         __SQLPASS__
> endif
>
> Database  access     DEFAULT_TYPE text
> Database  access     COLUMN_DEF   "username=varchar(32) NOT NULL PRIMARY
KEY"
> Database  access     COLUMN_DEF   "password=varchar(64)"
> Database  access     COLUMN_DEF   "label=varchar(128)"
> Database  access     COLUMN_DEF   "name=varchar(64)"
> Database  access     COLUMN_DEF   "last_login=varchar(32)"
> Database  access     COLUMN_DEF   "super=varchar(3)"
>
> --
> Mike Heins
> Perusion -- Expert Interchange Consulting    http://www.perusion.com/
> phone +1.513.523.7621      <mike@perusion.com>


Thanks a lot Mike. I've just tried that and it all looks fine.

Thanks again, both for this suggestion and for all your hard work on
Interchange,
Neil