[jifty-devel] Status of Jifty's ODBC support
Agent Zhang
agentzh at gmail.com
Tue Dec 12 22:59:11 EST 2006
On 12/12/06, Jesse Vincent <jesse at bestpractical.com> wrote:
>
>
> setenv DBI_TRACE=2 and try it again?
>
Here it is:
DBI 1.52-ithread default trace level set to 0x0/2 (pid 3884)
-> DBI->connect(dbi:ODBC:test, , ****)
-> DBI->install_driver(ODBC) for MSWin32 perl=5.008007 pid=3884
ruid=0 euid=0
install_driver: DBD::ODBC version 1.13 loaded from
E:/Perl/site/lib/DBD/ODBC.pm
<- install_driver= DBI::dr=HASH(0x35052c8)
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x35052c8)~0x3b4d2d0
'test' '' **** HASH(0x3b5461c)) thr#34774
SQLConnect 'test', ''
<- connect= DBI::db=HASH(0x3b4d354) at DBI.pm line 625
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x3b5464c)~INNER
'PrintError' 1) thr#34774
DBD::ODBC unsupported attribute passed (PrintError)
<- STORE= 1 at DBI.pm line 672
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x3b5464c)~INNER
'AutoCommit' 1) thr#34774
<- STORE= 1 at DBI.pm line 672
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x3b5464c)~INNER
'Username' '') thr#34774
DBD::ODBC unsupported attribute passed (Username)
<- STORE= 1 at DBI.pm line 675
<> FETCH= '' ('Username' from cache) at DBI.pm line 675
<- connect= DBI::db=HASH(0x3b4d354)
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x3b5464c)~INNER
'dbi_connect_closure' CODE(0x3b4d1e0)) thr#34774
DBD::ODBC unsupported attribute passed (dbi_connect_closure)
<- STORE= 1 at DBI.pm line 691
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x3b5464c)~INNER
'FetchHashKeyName' 'NAME_lc') thr#34774
DBD::ODBC unsupported attribute passed (FetchHashKeyName)
<- STORE= 1 at Handle.pm line 113
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x3b5464c)~INNER
'LongReadLen' '10000000') thr#34774
DBD::ODBC unsupported attribute passed (LongReadLen)
<- STORE= 1 at Handle.pm line 94
-> ping for DBD::ODBC::db (DBI::db=HASH(0x3b4d354)~0x3b5464c) thr#34774
Tables result 0 ()
build_results sql f93329848
SQLTables(,,NOXXTABLE,)
dbd_describe sql 93329848: num_fields=5
col 1: VARCHAR (12) len=255 disp=256, prec=255 scale=0
col 2: VARCHAR (12) len=128 disp=129, prec=128 scale=0
col 3: VARCHAR (12) len=128 disp=129, prec=128 scale=0
col 4: VARCHAR (12) len=128 disp=129, prec=128 scale=0
col 5: VARCHAR (12) len=254 disp=255, prec=254 scale=0
col 1: 'TABLE_CAT' sqltype=VARCHAR, ctype=SQL_C_CHAR,
maxlen=256, (dp = 0, cp = 0)
col 2: 'TABLE_SCHEM' sqltype=VARCHAR, ctype=SQL_C_CHAR,
maxlen=129, (dp = 256, cp = 10)
col 3: 'TABLE_NAME' sqltype=VARCHAR, ctype=SQL_C_CHAR,
maxlen=129, (dp = 388, cp = 22)
col 4: 'TABLE_TYPE' sqltype=VARCHAR, ctype=SQL_C_CHAR,
maxlen=129, (dp = 520, cp = 33)
col 5: 'REMARKS' sqltype=VARCHAR, ctype=SQL_C_CHAR, maxlen=255,
(dp = 652, cp = 44)
dbd_describe build_results #2...!
-> finish for DBD::ODBC::st (DBI::st=HASH(0x3b54784)~0x3b54bd4) thr#34774
<- finish= 1 at ODBC.pm line 210
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x3b54bd4)~INNER) thr#34774
<- DESTROY= undef at Metadata.pm line 60
<- ping= 1 at Metadata.pm line 60
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x3b4d354)~0x3b5464c
'SELECT * FROM _jifty_metadata WHERE data_key = ?') thr#34774
dbd_preparse scanned 1 distinct placeholders
SQLPrepare returned 0
dbd_st_prepare'd sql f93329848, ExecDirect=0
SELECT * FROM _jifty_metadata WHERE data_key = ?
<- prepare= DBI::st=HASH(0x3b54778) at Handle.pm line 445
-> execute for DBD::ODBC::st (DBI::st=HASH(0x3b54778)~0x3b550c0
'application_db_version') thr#34774
bind 1 <== 'application_db_version' (attribs: ), type 0
bind 1 <== 'application_db_version' (size 22/23/0, ptype 4, otype 1, sqltype 0)
bind 1: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=22.
dbd_st_execute (for hstmt 93329848 before)...
st_execute/SQLExecute error -1 recorded: [Microsoft][ODBC Microsoft
Access Driver] Microsoft Jet database engine can't find input table or
query '_jifty_metadata'。 Make sure it exists, and the spelling of its
name is correct. (SQL-42S02)(DBD: st_execute/SQLExecute err=-1)
!! ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_jifty_metadata'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' (err#0)
<- execute= undef at Handle.pm line 485
-> errstr in DBD::_::common for DBD::ODBC::db
(DBI::db=HASH(0x3b4d354)~0x3b5464c) thr#34774
ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_jifty_metadata'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' (err#0)
<- errstr= '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_jifty_metadata'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' at Handle.pm line 504
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x3b550c0)~INNER) thr#34774
ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_jifty_metadata'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' (err#0)
<- DESTROY= undef at Record.pm line 867
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x3b4d354)~0x3b5464c
'SELECT major, minor, rev FROM _db_version') thr#34774
SQLPrepare returned 0
dbd_st_prepare'd sql f93329848, ExecDirect=0
SELECT major, minor, rev FROM _db_version
<- prepare= DBI::st=HASH(0x3b5515c) at Handle.pm line 445
-> execute for DBD::ODBC::st (DBI::st=HASH(0x3b5515c)~0x3b1c1fc) thr#34774
dbd_st_execute (for hstmt 93329848 before)...
st_execute/SQLExecute error -1 recorded: [Microsoft][ODBC Microsoft
Access Driver] Microsoft Jet database engine can't find input table or
query '_db_version'。 Make sure it exists, and the spelling of its name
is correct. (SQL-42S02)(DBD: st_execute/SQLExecute err=-1)
!! ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_db_version'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' (err#0)
<- execute= undef at Handle.pm line 485
-> errstr for DBD::ODBC::db (DBI::db=HASH(0x3b4d354)~0x3b5464c) thr#34774
ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_db_version'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' (err#0)
<- errstr= '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_db_version'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' at Handle.pm line 504
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x3b1c1fc)~INNER) thr#34774
ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_db_version'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' (err#0)
<- DESTROY= undef at Handle.pm line 531
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x3b4d354)~0x3b5464c
'SELECT value FROM _jifty_metadata WHERE key =
'application_db_version'') thr#34774
SQLPrepare returned 0
dbd_st_prepare'd sql f93329848, ExecDirect=0
SELECT value FROM _jifty_metadata WHERE key = 'application_db_version'
<- prepare= DBI::st=HASH(0x3b55144) at Handle.pm line 445
-> execute for DBD::ODBC::st (DBI::st=HASH(0x3b55144)~0x3b54ee0) thr#34774
dbd_st_execute (for hstmt 93329848 before)...
st_execute/SQLExecute error -1 recorded: [Microsoft][ODBC Microsoft
Access Driver] Microsoft Jet database engine can't find input table or
query '_jifty_metadata'。 Make sure it exists, and the spelling of its
name is correct. (SQL-42S02)(DBD: st_execute/SQLExecute err=-1)
!! ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_jifty_metadata'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' (err#0)
<- execute= undef at Handle.pm line 485
-> errstr for DBD::ODBC::db (DBI::db=HASH(0x3b4d354)~0x3b5464c) thr#34774
ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_jifty_metadata'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' (err#0)
<- errstr= '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_jifty_metadata'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' at Handle.pm line 504
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x3b54ee0)~INNER) thr#34774
ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Microsoft
Jet database engine can't find input table or query '_jifty_metadata'。
Make sure it exists, and the spelling of its name is correct.
(SQL-42S02)(DBD: st_execute/SQLExecute err=-1)' (err#0)
<- DESTROY= undef at Handle.pm line 531
-> ping for DBD::ODBC::db (DBI::db=HASH(0x3b4d354)~0x3b5464c) thr#34774
Tables result 0 ()
build_results sql f93329848
SQLTables(,,NOXXTABLE,)
dbd_describe sql 93329848: num_fields=5
col 1: VARCHAR (12) len=255 disp=256, prec=255 scale=0
col 2: VARCHAR (12) len=128 disp=129, prec=128 scale=0
col 3: VARCHAR (12) len=128 disp=129, prec=128 scale=0
col 4: VARCHAR (12) len=128 disp=129, prec=128 scale=0
col 5: VARCHAR (12) len=254 disp=255, prec=254 scale=0
col 1: 'TABLE_CAT' sqltype=VARCHAR, ctype=SQL_C_CHAR,
maxlen=256, (dp = 0, cp = 0)
col 2: 'TABLE_SCHEM' sqltype=VARCHAR, ctype=SQL_C_CHAR,
maxlen=129, (dp = 256, cp = 10)
col 3: 'TABLE_NAME' sqltype=VARCHAR, ctype=SQL_C_CHAR,
maxlen=129, (dp = 388, cp = 22)
col 4: 'TABLE_TYPE' sqltype=VARCHAR, ctype=SQL_C_CHAR,
maxlen=129, (dp = 520, cp = 33)
col 5: 'REMARKS' sqltype=VARCHAR, ctype=SQL_C_CHAR, maxlen=255,
(dp = 652, cp = 44)
dbd_describe build_results #2...!
-> finish for DBD::ODBC::st (DBI::st=HASH(0x3b550cc)~0x3505a0c) thr#34774
<- finish= 1 at ODBC.pm line 210
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x3505a0c)~INNER) thr#34774
<- DESTROY= undef at Handle.pm line 105
<- ping= 1 at Handle.pm line 105
-> DBI->connect(dbi:ODBC:test, , ****)
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x35052c8)~0x3b4d2d0
'test' '' **** HASH(0x20c1fdc)) thr#34774
SQLConnect 'test', ''
<- connect= DBI::db=HASH(0x3b5515c) at DBI.pm line 625
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x20c200c)~INNER
'PrintError' 1) thr#34774
DBD::ODBC unsupported attribute passed (PrintError)
<- STORE= 1 at DBI.pm line 672
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x20c200c)~INNER
'AutoCommit' 1) thr#34774
<- STORE= 1 at DBI.pm line 672
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x20c200c)~INNER
'Username' '') thr#34774
DBD::ODBC unsupported attribute passed (Username)
<- STORE= 1 at DBI.pm line 675
<> FETCH= '' ('Username' from cache) at DBI.pm line 675
<- connect= DBI::db=HASH(0x3b5515c)
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x20c200c)~INNER
'dbi_connect_closure' CODE(0x3b550c0)) thr#34774
DBD::ODBC unsupported attribute passed (dbi_connect_closure)
<- STORE= 1 at DBI.pm line 691
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x20c200c)~INNER
'FetchHashKeyName' 'NAME_lc') thr#34774
DBD::ODBC unsupported attribute passed (FetchHashKeyName)
<- STORE= 1 at Handle.pm line 113
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x20c200c)~INNER
'LongReadLen' '10000000') thr#34774
DBD::ODBC unsupported attribute passed (LongReadLen)
<- STORE= 1 at Handle.pm line 94
-> disconnect for DBD::ODBC::db
(DBI::db=HASH(0x3b5515c)~0x20c200c) thr#34774
<- disconnect= 1 at Handle.pm line 313
-> disconnect for DBD::ODBC::db
(DBI::db=HASH(0x3b4d354)~0x3b5464c) thr#34774
<- disconnect= 1 at Handle.pm line 313
-> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x3b5464c)~INNER) thr#34774
<- DESTROY= undef at Handle.pm line 1034
-> ping for DBD::ODBC::db (DBI::db=HASH(0x3b5515c)~0x20c200c) thr#34774
More information about the jifty-devel
mailing list