David,
I don't know if this was answered for you but the open database command
has 5 fields, not 4. You are missing the 3rd. The first and third (I never
remember which is who as I always name them the same thing) are the local
odbc name in the .odbc.ini file such as [mybase] and the other is the name
of the database on the server.
Phillip Thomas
On Mon, 16 Oct 2006, David Gamey wrote:
> There seems to be an ODBC error under the covers. Turning on the logging, I
> get the following when I call dbtables on the connection:
>
> 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
