search

JuliaDatabases / ODBC.jl

An ODBC interface for the Julia programming language
https://odbc.juliadatabases.org/stable
Other
106 stars 62 forks source link

ODBC not working with DataFrames v0.18+ #235

Closed non-Jedi closed 5 years ago

non-Jedi commented 5 years ago

The following code works with DataFrames 0.17.1 but not with 0.18+. I assume this is because DataFrames no longer depends on DataStreams.

  using DataFrames
  import ODBC
  const dsn = ODBC.DSN("DRIVER=OracleODBC;DBQ=redacted;UID=redacted;PWD=redacted;DSN=redacted")
  const query = """
      SELECT x.RESULT_NUMBER, x.SAMPLED_DATE, x.NAME, x.NUMERIC_ENTRY, x.TEST_NUMBER FROM REDACTED.SAMPLES x
          WHERE x.SAMPLED_DATE BETWEEN TIMESTAMP '2018-01-01 00:00:00' AND TIMESTAMP '2019-01-01 00:00:00' AND
          x.SAMPLING_POINT IN ('REDACTED', 'REDACTED');
  """
  data = ODBC.query(dsn, query)
non-Jedi commented 5 years ago

I just tried in a new environment (to get the traceback I lost the first time), and I was unable to reproduce this error. I will open again if it reoccurs.