I gather that you are refering to the low level call to open the odbc connection rather than the call at the Unicon soure level. (The documentation of the Unicon call to open only shows 4 parameter.)
I haven't had time to delve under the covers yet. But this could be helpful.
Thanks,
David
Phillip <[EMAIL PROTECTED]> wrote:
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
