I do have the ODBC user data source Microsoft Access Driver (*.mdb) in place. A vb script successfully uses "Microsoft.Jet.OLEDB.4.0" as the provider...
Here's the test kix script. Function.udf contains the db udf collection (i.e. dbconnopen(),dbrecordopen(), etc.). The swinv.mdb exists with table and fields declared, as described above, with no records in it.
code:
call "function.udf"
$previousstate = SetOption( "WrapAtEOL", "ON" )
$objconn=dbconnopen('provider=microsoft.jet.oledb.4.0;data source=c:\program files\kixtart\kixdatabase\swinv.mdb')
? "objconn: @error @serror"
$recordset=dbrecordsetopen($objconn,"select * from inventory")
? "recordset: @error @serror"
;$retcode=dbrecordsetclose($recordset)
;$retcode=dbconnclose($objconn)
;? "retcode: @error @serror"
_________________________
We all live in a Yellow Subroutine...