Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
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
Replies are listed 'Best First'.
Re^9: Debian DBD::ODBC select row by timestamp
by mje (Curate) 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 imbibing at the Monastery: (12)
As of 2015-07-08 04:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (94 votes), past polls