Hi, seem to have a upper/lower case problem.
defined a virtual table as follows
mysqlconn='Driver={MySQL ODBC 5.1 Driver};';
+'Server=10.231.92.232;';
+'Database=protodata;';
+'User=proto;';
+'Password=proto;'
open database odbcdev
create virtualtable t1 alias 't1' connstr mysqlconn as select * from protodata.t1
close database
From console
open database odbcdev
list tables
use t1
close database
I get
Tables in Database: odbcdev
Name Path Type
------------------- ------------------------------------------------------------ --------------------
+ t1 /opt/lianja/data/odbcdev/t1.dbf VirtualTable
| connstr 'Driver={MySQL ODBC 5.1 Driver};Server=10.231.92.232;Database=protodata;Us er=proto;Password=proto;'
| alias 't1'
| as select * from protodata.t1
and from use t1
Wed Jul 31 12:05:05 2013
**** Lianja error ****
use 't1'
^
File 'T1' does not exis
Lianja runs on Centos 6.4 64bit and an ODBC import from Lianja runs successfully.
Regards
Bookmarks