I'd set up an ODBC connection for a test spreadsheet using the ODBC sources DSN, Excel Drivers. The open worked but I could not get a list of the tables(worksheets) in the workbook. I'm running this on XP/Pro and Office 2003. A sample and output are below:
-------
link ximage
procedure main(arglist)
dbn := "ODBC_Tests" #
write(&version)
dbf := open(dbn,"o","","") | stop("Unable to open db ",dbn)
write("getting table info:")
write(ximage(dbdriver(dbf)))
write(ximage(dbproduct(dbf)))
write(ximage(dbtables(dbf)))
close(dbf)
end
-------
Unicon Version 11.3 (beta). June 23, 2005
getting table info:
R__1 := ()
R__1.name := "odbcjt32.dll"
R__1.ver := "04.00.6304"
R__1.odbcver := "03.51"
R__1.connections := 0
R__1.statements := ""
R__1.dsn := "ODBC_Tests"
R__1 := ()
R__1.name := "EXCEL"
R__1.ver := "08.00.0000"
L2 := list(0)
-----
Thanks,
David
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Unicon-group mailing list Unicon-group@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/unicon-group
