iODBC Driver Manager support

[iotaaxel]

I am trying to connect to a sqlite3 database to query a table. In my project, the connection string gives me the error 'Diagnostics returned error for record number 2. Record numbers have to be at least 1.'

I decided to download the crate individually to see if I could run test examples and figure out what is wrong with my code. None of the tests pass.

My output is below:
cargo_test_output.txt

Also, is there a list of dependencies need for this repo? I got a linker error until I used "brew install libiodbc".

[Koka]

Actually, I've never tried this crate with iodbc, but should work too.
Can you please add more details on your environment?

Failing tests can be related not only to the crate itself, but also to environment, ODBC driver manager or driver and datasource setup.

The only native dependence of this crate is odbc driver manager. It should be already installed on Windows and for Linux and Mac you need to install it manually (like UnixODBC or iodbc)

[Koka]

Also looks like you're calling get_diag_rec(2) somewhere while having only one diagnostic record, I quickly looked at the sources of this crate and it always does get_diag_rec(1), so this should be called manually somewhere in your code. Thats the reason why you have 'Diagnostics returned error for record number 2. Record numbers have to be at least 1' error

[iotaaxel]

I am using rustc 1.28.0-nightly (e3bf634e0 2018-06-28) now on a Mac. I am also using Homebrew 1.6.9.

Thank you, I was able to get successful results by downloading the iODBC Driver Manager , running "brew install sqliteodbc", and set up dsn files.

Also, it appears your tests are hardcoded , so that may be why cargo test fails for me.

[ccakes]

Just an additional datapoint - on macOS 10.12 linking against libiodbc results in all tests failing, removed that and retried with unixodbc and all works fine.

I didn't try installing iODBC Driver Manager like OP did though.

[iotaaxel]

I removed iODBC Driver Manager and now only have unixodbc. Thank you @ccakes

[Koka]

So looks like iODBC doesn't work well with this crate. I'm renaming this issue to iODBC Driver Manager support request