0

The driver is the latest from a month ago: 2014-SP2: 11.17.17, 64-bit. Windows is Server 2012.

I have limited options to test whether earlier versions of the driver would work or this version works on other systems. I also found no other resource on this version of Windows whether ODBC works outside of Stata (ODBC Data Sources does see the database, but there is no way to test or query it). I received little tech support about troubleshooting this error: A screen shot of how ODBC, called by Stata, does know about the database as set up, but crashes with the driver reporting error SQLSTATE=HY001

To be clear, I noticed that MonetDB.org instructs us to install both the 64-bit and the 32-bit ODBC driver. I did that. The following screenshot shows that the MonetDB server is running, and Windows sees both the 32-bit and 64-bit data sources I set up (I only changed the names of the database to ifn, the rest are the defaults of MonetDB). enter image description here

I understand this is not a coding issue, slightly off topic, though probably relevant for the DBA community.

1 Answer 1

1

They just released new server & driver packages (7/25/2014). I had the same issue with the old drivers but with the 7/25 release it is gone.

1
  • Also note that the issue was that Stata was passing a NULL string to the ODBC API call SQLTables and SQLColumns where the MonetDB driver wanted an empty string (""). Some other drivers need a NULL string passed in to work (Oracle being one) so StataCorp believed this was a driver bug, but they patched the problem in Stata too.
    – László
    Aug 19, 2014 at 15:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.