Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

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.

share|improve this answer
    
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 at 15:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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