odbc_test_2 714-ea4 EXIT SQLFetch with return code -1 (SQL_ERROR)
HSTMT 00381FA0
DIAG [22005] [Microsoft][ODBC Excel Driver]Invalid character value for cast specification on column number 4 (TABLE_TYPE) (39)
This appears to be the same for both the MS-Excel and MS-Excel-Treiber drivers.
David
David Gamey <[EMAIL PROTECTED]> wrote:
I was experimenting with the ODBC support and ran into unexpected trouble. The function dbtables doesn't appear to work as I understand it. I'm wondering if this is an ODBC or Unicon issue. So before I start digging, has anyone seen this before or can offer other insight?
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
------------------------------------------------------------------------- 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
