Beefy Boxes and Bandwidth Generously Provided by pair Networks Frank
Keep It Simple, Stupid
 
PerlMonks  

Re^8: Debian DBD::ODBC select row by timestamp

by alexx_sh (Novice)
on Jul 24, 2012 at 12:20 UTC ( #983387=note: print w/ replies, xml ) Need Help??


in reply to Re^7: Debian DBD::ODBC select row by timestamp
in thread Debian DBD::ODBC select row by timestamp

Yes i check script. And i can't undestand why it dosn't work. How enable debug output in unixodbc?

So if i edit script:

SELECT val from buf WHERE (dd_mm_yyyy= {ts '2012-07-22 00:00:00'})

i have output like this

Calling mdb_test_sarg on unknown type. Add code to mdb_test_sarg() fo +r type 8 Calling mdb_test_sarg on unknown type. Add code to mdb_test_sarg() fo +r type 8 JSON-------------------JSON {"date":[[""],[""]]}

I think it's driver error libmdbodbc.

Seemed it don't work properly.


Comment on Re^8: Debian DBD::ODBC select row by timestamp
Select or Download Code
Re^9: Debian DBD::ODBC select row by timestamp
by mje (Deacon) on Jul 24, 2012 at 14:14 UTC

    Ah, you are using mdbtools. Might have been useful to state that up front. In my experience mdbtools is not very good and the only alternative I know is not free.

    To enabled logging in unixODBC edit your odbcinst.ini file (find it with odbcinst -j) and add:

    [ODBC] Trace=yes TraceFile=/tmp/unixodbc.log

    to the top of it.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://983387]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (15)
As of 2014-04-24 11:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (565 votes), past polls