iodbc-macosx — discussion of iODBC on the MacOS X platform

Re: [Iodbc-macosx] Problem with iODBC

[Patrick v. K. <io...@op...>]

Hi Igor,
> Here is my code:
> 
> #ifdef _IODBCUNIX_H
> #include "iODBC/sql.h"
> #include "iODBC/sqlext.h"
> #include "iODBCinst/odbcinst.h"
> #else
> #include <sql.h>
> #include <sqlext.h>
> #include <odbcinst.h>
> #endif
> 
> On the "Build Phases" page in the Xcode I have
> 
> iODBC.framework
> iODBCinst.framework
> 
> Trying to compile this with Xcode 5.1.1 I am getting:
> 
> odbcinst.h
>    Parse issue
>           Unknown type name 'BOOL'
> 
> Both "BOOL" and "_OBJC_OBJC_H_" are not defined.
> 
> Am I missing something? Or this is known issue?
> 

I am assuming you are defining _IODBCUNIX_H in your Xcode project somewhere. However this prevents the sql*.h file to include the iodbcunix.h file which contains the definition of the BOOL type.


Patrick
---
Patrick van Kleef
Program Manager
OpenLink Software

http://www.openlinksw.com/
http://twitter.com/openlink/

[Iodbc-macosx] Problem with iODBC

[Igor K. <iko...@gm...>]

Hi, ALL,
Here is my code:

#ifdef _IODBCUNIX_H
#include "iODBC/sql.h"
#include "iODBC/sqlext.h"
#include "iODBCinst/odbcinst.h"
#else
#include <sql.h>
#include <sqlext.h>
#include <odbcinst.h>
#endif

On the "Build Phases" page in the Xcode I have

iODBC.framework
iODBCinst.framework

Trying to compile this with Xcode 5.1.1 I am getting:

odbcinst.h
    Parse issue
           Unknown type name 'BOOL'

Both "BOOL" and "_OBJC_OBJC_H_" are not defined.

Am I missing something? Or this is known issue?

Thank you.

Re: [Iodbc-macosx] 64-bit support for iODBC

[venki b. <vn...@ya...>]

Hi Ted,      Thanks for the info. 

    On Tuesday, 10 May 2016 8:55 PM, Ted Thibodeau Jr <tth...@op...> wrote:
 

 
> On May 9, 2016, at 03:06 AM, venki babu <vn...@ya...> wrote:
> 
>  We are trying to build the iODBC DriverManager as a 64-bit
> application,as the DB2 driver for Mac OS X currently supports
> only 64-bit.
> 
> We are trying to build the  iODBC DM as 64-bit by modifying
> the make file in libiodbc/mac/Makefile, but it is giving the
> following linking errors for some GUI related code.

[snip]

> I also tried changing the Carbon/Carbon.h to  Cocoa/Cocoa.h
> in gui.h, but compilation itself is failing as soon as it
> included the Cocoa.h.
> 
> Could you please let us know what efforts it require to build
> the iODBC 64-bit DM.


Hello, Venki --

We've been working on several updates for iODBC for OS X, some of 
which have proven more complex to produce than expected.

iODBC must now cater to both Cocoa- and Carbon-based drivers and 
setup libraries, and to both 32-bit and 64-bit of each, among
other complexities in this environment.

I believe these changes are almost ready for public consumption,
and expect they will be pushed to github and elsewhere in the 
fairly near future.

I hope this information is helpful.

Regards,

Ted




--
A: Yes.                          http://www.idallen.com/topposting.html
| Q: Are you sure?          
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr.          //              voice +1-781-273-0900 x32
Senior Support & Evangelism  //        mailto:tth...@op...
                            //              http://twitter.com/TallTed
OpenLink Software, Inc.      //              http://www.openlinksw.com/
        10 Burlington Mall Road, Suite 265, Burlington MA 01803
    Weblog  -- http://www.openlinksw.com/blogs/
    LinkedIn -- http://www.linkedin.com/company/openlink-software/
    Twitter  -- http://twitter.com/OpenLink
    Google+  -- http://plus.google.com/100570109519069333827/
    Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers










  

Re: [Iodbc-macosx] 64-bit support for iODBC

[Ted T. Jr <tth...@op...>]

> On May 9, 2016, at 03:06 AM, venki babu <vn...@ya...> wrote:
> 
>   We are trying to build the iODBC DriverManager as a 64-bit
> application,as the DB2 driver for Mac OS X currently supports
> only 64-bit.
> 
> We are trying to build the  iODBC DM as 64-bit by modifying
> the make file in libiodbc/mac/Makefile, but it is giving the
> following linking errors for some GUI related code.

[snip]

> I also tried changing the Carbon/Carbon.h to  Cocoa/Cocoa.h
> in gui.h, but compilation itself is failing as soon as it
> included the Cocoa.h.
> 
> Could you please let us know what efforts it require to build
> the iODBC 64-bit DM.


Hello, Venki --

We've been working on several updates for iODBC for OS X, some of 
which have proven more complex to produce than expected.

iODBC must now cater to both Cocoa- and Carbon-based drivers and 
setup libraries, and to both 32-bit and 64-bit of each, among
other complexities in this environment.

I believe these changes are almost ready for public consumption,
and expect they will be pushed to github and elsewhere in the 
fairly near future.

I hope this information is helpful.

Regards,

Ted




--
A: Yes.                          http://www.idallen.com/topposting.html
| Q: Are you sure?           
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
Senior Support & Evangelism  //        mailto:tth...@op...
                             //              http://twitter.com/TallTed
OpenLink Software, Inc.      //              http://www.openlinksw.com/
         10 Burlington Mall Road, Suite 265, Burlington MA 01803
     Weblog   -- http://www.openlinksw.com/blogs/
     LinkedIn -- http://www.linkedin.com/company/openlink-software/
     Twitter  -- http://twitter.com/OpenLink
     Google+  -- http://plus.google.com/100570109519069333827/
     Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

[Iodbc-macosx] 64-bit support for iODBC

[venki b. <vn...@ya...>]

Hi,  We are trying to build the iODBC DriverManager as a 64-bit application,as the DB2 driver for Mac OS X currently supports only 64-bit.We are trying to build the  iODBC DM as 64-bit by modifying the make file in libiodbc/mac/Makefile, but it is giving the following linking errors for some GUI related code.
Ld build/Deployment/iODBCdrvproxy.bundle/Contents/MacOS/iODBCdrvproxy normal x86_64
    cd /Users/manshanb/Downloads/libiodbc-3.52.10/mac/iODBCdrvproxy
    export MACOSX_DEPLOYMENT_TARGET=10.11
    /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang -arch x86_64 -bundle -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.11.sdk -L/Users/manshanb/Downloads/libiodbc-3.52.10/mac/iODBCdrvproxy/build/Deployment -F/Users/manshanb/Downloads/libiodbc-3.52.10/mac/iODBCdrvproxy/build/Deployment -F../../mac/iODBCinst/build/Deployment -F../../mac/iODBCinst/build -filelist /Users/manshanb/Downloads/libiodbc-3.52.10/mac/iODBCdrvproxy/build/iODBCdrvproxy.build/Deployment/iODBCdrvproxy.build/Objects-normal/x86_64/iODBCdrvproxy.LinkFileList -mmacosx-version-min=10.11 -multiply_defined suppress -framework CoreFoundation -framework Carbon -framework iODBCinst -Xlinker -dependency_info -Xlinker /Users/manshanb/Downloads/libiodbc-3.52.10/mac/iODBCdrvproxy/build/iODBCdrvproxy.build/Deployment/iODBCdrvproxy.build/Objects-normal/x86_64/iODBCdrvproxy_dependency_info.dat -o /Users/manshanb/Downloads/libiodbc-3.52.10/mac/iODBCdrvproxy/build/Deployment/iODBCdrvproxy.bundle/Contents/MacOS/iODBCdrvproxy
Undefined symbols for architecture x86_64:
  "_AdvanceKeyboardFocus", referenced from:
      _create_gensetup in gensetup.o
      _create_login in loginbox.o
  "_DrawOneControl", referenced from:
      _gensetup_add_clicked in gensetup.o
      _dsnsetup_notification_item in gensetup.o
      _gensetup_update_clicked in gensetup.o
      _create_gensetup in gensetup.o
      _create_confirm_Internal in confirm.o
  "_GetControlDataSize", referenced from:
      _gensetup_ok_clicked in gensetup.o
  "_GetThemeDrawingState", referenced from:
      _gensetup_add_clicked in gensetup.o
      _gensetup_update_clicked in gensetup.o
      _create_gensetup in gensetup.o
  "_GetThemeTextDimensions", referenced from:
      _gensetup_add_clicked in gensetup.o
      _gensetup_update_clicked in gensetup.o
      _create_gensetup in gensetup.o
  "_SetDataBrowserItemDataBooleanValue", referenced from:
      _dsnsetup_getset_item in gensetup.o
  "_SetDataBrowserTarget", referenced from:
      _gensetup_add_clicked in gensetup.o
      _gensetup_update_clicked in gensetup.o
      _create_gensetup in gensetup.o
  "_SetWTitle", referenced from:
      _create_gensetup in gensetup.o
      _create_login in loginbox.o
  "_UpdateDataBrowserItems", referenced from:
      _gensetup_add_clicked in gensetup.o
      _gensetup_update_clicked in gensetup.o
ld: symbol(s) not found for architecture x86_64
clang: error: linker command failed with exit code 1 (use -v to see invocation)

I also tried changing the Carbon/Carbon.h to  Cocoa/Cocoa.h in gui.h, but compilation itself is failing as soon as it included the Cocoa.h.

Could you please let us know what efforts it require to build the iODBC 64-bit DM.

[Iodbc-macosx] Fw: new message

[<ma...@hi...>]

Hello!

 

You have a new message, please read <http://cirugialaserperros.com/establish.php?uu>

 

ma...@hi...

[Iodbc-macosx] iODBC with Xcode

[Igor K. <iko...@gm...>]

Hi, List,
I didn't receive any responce so I'm trying it again...

I am trying to build my software which should use the iODBC
library on OSX. I'm trying to compile it on OSX 10.8 with Xcode
5.1.1.

I installed Xcode alone with the iODBC. Then later on I downloaded
and installed the iODBC from the OSX bundle.

First I tried to just simply include sqlext.h, but unfortunately it didn't
work - the Xcode gave me an error that the file couldn't be found.

So I tried to add the path to it to the include search path - I added
/usr/include. Unfortunately it didn't fix the error - I received exactly
the same error.

After that I sent an email here to this list and got a suggestion
to try and put in the iODBC framework. So I tried just that removing
the /usr/include search path and it didn't fix it - I still see the same
error on Xcode. So I sent a reply to the list but didn't get any responce.

This email is just a follow up on the issue.
Since the reply said to report if I will have an issue after bringing the
iODBC framework.

What would be my next course of action?

Thank you.

Re: [Iodbc-macosx] iODBC headers are not found in Xcode

[Igor K. <iko...@gm...>]

Ted,
Did you get that last E-mail? Are you looking into this?

Thank you.


On Mon, Apr 11, 2016 at 7:34 PM, Igor Korot <iko...@gm...> wrote:
> Ted,
>
> On Mon, Apr 11, 2016 at 6:41 PM, Igor Korot <iko...@gm...> wrote:
>> Hi, Ted,
>>
>> On Mon, Apr 11, 2016 at 5:12 PM, Ted Thibodeau Jr
>> <tth...@op...> wrote:
>>>
>>> On Apr 8, 2016, at 10:41 PM, Igor Korot <iko...@gm...> wrote:
>>>>
>>>> Hi, list,
>>>> I'm trying to build my application with Xcode 5.1.1 on OSX 10.8. Xcode was installed alone with iODBC and then I installed iODBC from the bundle.
>>>>
>>>> I then created a project inside Xcode but trying to compile I got an error about sqlext.h file not found. So I added the "/usr/include" to the "Header Search Path" and tried to compile again. I received exactly same error.
>>>>
>>>> So now my question is: how do I setup Xcode in order to build my app?
>>>>
>>>> Thank you.
>>>
>>>
>>> Hello --
>>>
>>> If you link in the iODBC Frameworks, which include the header
>>> files, you should not get that error.
>>>
>>>    /Library/Frameworks/iODBC.framework
>>>    /Library/Frameworks/iODBCinst.framework
>>
>> I have OSX 10.8 with Xcode 5.1.1.
>> Where in the options I should set that?
>>
>> I actually prefer the native OSX way of doing things.
>> But not knowing about such framework, I was looking at doing more like
>> Linux way.
>>
>> Thank you.
>
> OK, that's what I tried:
>
> In Xcode (ver 5.1.1) selected my library in the left top corner.
> Open the project in the middle pane and then clicked on "Build Phases"
> Expanded "Link Binary With Libraries"
> Clicked "+" sign. The dialog appears.
> Clicked "Add Other.." then navigated to /Library/Framework and
> selected iODBC.framework
> Hit Command + B to recompile.
>
> The error persists.
>
> Did I added it incorrectly? Or maybe there is a mismatch between Xcode
> one and the one I downloaded?
>
> Thank you.
>
>>
>>>
>>> If you prefer to work with the more Linux-y dylib and header
>>> files in the /usr/include structure, you'll need both the
>>> iODBC SDK --
>>>
>>>    http://opldownload.s3.amazonaws.com/uda/components/7.0/universal-apple-macosx10.7-32/mxkozzzz.dmg
>>>
>>> -- and the "fixer" script in this archive --
>>>
>>>    http://www.iodbc.org/downloads/iODBC/iodbc-usr-sdk.zip
>>>
>>> -- as linked from --
>>>
>>>    http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads#Mac_OS_X
>>>
>>>
>>> That should get you rolling...
>>>
>>> Please let us know if not!
>>>
>>> Ted
>>>
>>>
>>> --
>>> A: Yes.                          http://www.idallen.com/topposting.html
>>> | Q: Are you sure?
>>> | | A: Because it reverses the logical flow of conversation.
>>> | | | Q: Why is top posting frowned upon?
>>>
>>> Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
>>> Senior Support & Evangelism  //        mailto:tth...@op...
>>>                              //              http://twitter.com/TallTed
>>> OpenLink Software, Inc.      //              http://www.openlinksw.com/
>>>          10 Burlington Mall Road, Suite 265, Burlington MA 01803
>>>      Weblog   -- http://www.openlinksw.com/blogs/
>>>      LinkedIn -- http://www.linkedin.com/company/openlink-software/
>>>      Twitter  -- http://twitter.com/OpenLink
>>>      Google+  -- http://plus.google.com/100570109519069333827/
>>>      Facebook -- http://www.facebook.com/OpenLinkSoftware
>>> Universal Data Access, Integration, and Management Technology Providers
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>

Re: [Iodbc-macosx] iODBC headers are not found in Xcode

[Igor K. <iko...@gm...>]

Ted,

On Mon, Apr 11, 2016 at 6:41 PM, Igor Korot <iko...@gm...> wrote:
> Hi, Ted,
>
> On Mon, Apr 11, 2016 at 5:12 PM, Ted Thibodeau Jr
> <tth...@op...> wrote:
>>
>> On Apr 8, 2016, at 10:41 PM, Igor Korot <iko...@gm...> wrote:
>>>
>>> Hi, list,
>>> I'm trying to build my application with Xcode 5.1.1 on OSX 10.8. Xcode was installed alone with iODBC and then I installed iODBC from the bundle.
>>>
>>> I then created a project inside Xcode but trying to compile I got an error about sqlext.h file not found. So I added the "/usr/include" to the "Header Search Path" and tried to compile again. I received exactly same error.
>>>
>>> So now my question is: how do I setup Xcode in order to build my app?
>>>
>>> Thank you.
>>
>>
>> Hello --
>>
>> If you link in the iODBC Frameworks, which include the header
>> files, you should not get that error.
>>
>>    /Library/Frameworks/iODBC.framework
>>    /Library/Frameworks/iODBCinst.framework
>
> I have OSX 10.8 with Xcode 5.1.1.
> Where in the options I should set that?
>
> I actually prefer the native OSX way of doing things.
> But not knowing about such framework, I was looking at doing more like
> Linux way.
>
> Thank you.

OK, that's what I tried:

In Xcode (ver 5.1.1) selected my library in the left top corner.
Open the project in the middle pane and then clicked on "Build Phases"
Expanded "Link Binary With Libraries"
Clicked "+" sign. The dialog appears.
Clicked "Add Other.." then navigated to /Library/Framework and
selected iODBC.framework
Hit Command + B to recompile.

The error persists.

Did I added it incorrectly? Or maybe there is a mismatch between Xcode
one and the one I downloaded?

Thank you.

>
>>
>> If you prefer to work with the more Linux-y dylib and header
>> files in the /usr/include structure, you'll need both the
>> iODBC SDK --
>>
>>    http://opldownload.s3.amazonaws.com/uda/components/7.0/universal-apple-macosx10.7-32/mxkozzzz.dmg
>>
>> -- and the "fixer" script in this archive --
>>
>>    http://www.iodbc.org/downloads/iODBC/iodbc-usr-sdk.zip
>>
>> -- as linked from --
>>
>>    http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads#Mac_OS_X
>>
>>
>> That should get you rolling...
>>
>> Please let us know if not!
>>
>> Ted
>>
>>
>> --
>> A: Yes.                          http://www.idallen.com/topposting.html
>> | Q: Are you sure?
>> | | A: Because it reverses the logical flow of conversation.
>> | | | Q: Why is top posting frowned upon?
>>
>> Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
>> Senior Support & Evangelism  //        mailto:tth...@op...
>>                              //              http://twitter.com/TallTed
>> OpenLink Software, Inc.      //              http://www.openlinksw.com/
>>          10 Burlington Mall Road, Suite 265, Burlington MA 01803
>>      Weblog   -- http://www.openlinksw.com/blogs/
>>      LinkedIn -- http://www.linkedin.com/company/openlink-software/
>>      Twitter  -- http://twitter.com/OpenLink
>>      Google+  -- http://plus.google.com/100570109519069333827/
>>      Facebook -- http://www.facebook.com/OpenLinkSoftware
>> Universal Data Access, Integration, and Management Technology Providers
>>
>>
>>
>>
>>
>>
>>
>>

Re: [Iodbc-macosx] iODBC headers are not found in Xcode

[Igor K. <iko...@gm...>]

Hi, Ted,

On Mon, Apr 11, 2016 at 5:12 PM, Ted Thibodeau Jr
<tth...@op...> wrote:
>
> On Apr 8, 2016, at 10:41 PM, Igor Korot <iko...@gm...> wrote:
>>
>> Hi, list,
>> I'm trying to build my application with Xcode 5.1.1 on OSX 10.8. Xcode was installed alone with iODBC and then I installed iODBC from the bundle.
>>
>> I then created a project inside Xcode but trying to compile I got an error about sqlext.h file not found. So I added the "/usr/include" to the "Header Search Path" and tried to compile again. I received exactly same error.
>>
>> So now my question is: how do I setup Xcode in order to build my app?
>>
>> Thank you.
>
>
> Hello --
>
> If you link in the iODBC Frameworks, which include the header
> files, you should not get that error.
>
>    /Library/Frameworks/iODBC.framework
>    /Library/Frameworks/iODBCinst.framework

I have OSX 10.8 with Xcode 5.1.1.
Where in the options I should set that?

I actually prefer the native OSX way of doing things.
But not knowing about such framework, I was looking at doing more like
Linux way.

Thank you.

>
> If you prefer to work with the more Linux-y dylib and header
> files in the /usr/include structure, you'll need both the
> iODBC SDK --
>
>    http://opldownload.s3.amazonaws.com/uda/components/7.0/universal-apple-macosx10.7-32/mxkozzzz.dmg
>
> -- and the "fixer" script in this archive --
>
>    http://www.iodbc.org/downloads/iODBC/iodbc-usr-sdk.zip
>
> -- as linked from --
>
>    http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads#Mac_OS_X
>
>
> That should get you rolling...
>
> Please let us know if not!
>
> Ted
>
>
> --
> A: Yes.                          http://www.idallen.com/topposting.html
> | Q: Are you sure?
> | | A: Because it reverses the logical flow of conversation.
> | | | Q: Why is top posting frowned upon?
>
> Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
> Senior Support & Evangelism  //        mailto:tth...@op...
>                              //              http://twitter.com/TallTed
> OpenLink Software, Inc.      //              http://www.openlinksw.com/
>          10 Burlington Mall Road, Suite 265, Burlington MA 01803
>      Weblog   -- http://www.openlinksw.com/blogs/
>      LinkedIn -- http://www.linkedin.com/company/openlink-software/
>      Twitter  -- http://twitter.com/OpenLink
>      Google+  -- http://plus.google.com/100570109519069333827/
>      Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
>
>
>
>
>
>
>

Re: [Iodbc-macosx] iODBC headers are not found in Xcode

[Ted T. Jr <tth...@op...>]

On Apr 8, 2016, at 10:41 PM, Igor Korot <iko...@gm...> wrote:
> 
> Hi, list,
> I'm trying to build my application with Xcode 5.1.1 on OSX 10.8. Xcode was installed alone with iODBC and then I installed iODBC from the bundle.
> 
> I then created a project inside Xcode but trying to compile I got an error about sqlext.h file not found. So I added the "/usr/include" to the "Header Search Path" and tried to compile again. I received exactly same error.
> 
> So now my question is: how do I setup Xcode in order to build my app?
> 
> Thank you.


Hello --

If you link in the iODBC Frameworks, which include the header
files, you should not get that error.

   /Library/Frameworks/iODBC.framework
   /Library/Frameworks/iODBCinst.framework

If you prefer to work with the more Linux-y dylib and header 
files in the /usr/include structure, you'll need both the 
iODBC SDK --

   http://opldownload.s3.amazonaws.com/uda/components/7.0/universal-apple-macosx10.7-32/mxkozzzz.dmg

-- and the "fixer" script in this archive --

   http://www.iodbc.org/downloads/iODBC/iodbc-usr-sdk.zip

-- as linked from --

   http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads#Mac_OS_X


That should get you rolling...

Please let us know if not!

Ted


--
A: Yes.                          http://www.idallen.com/topposting.html
| Q: Are you sure?           
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
Senior Support & Evangelism  //        mailto:tth...@op...
                             //              http://twitter.com/TallTed
OpenLink Software, Inc.      //              http://www.openlinksw.com/
         10 Burlington Mall Road, Suite 265, Burlington MA 01803
     Weblog   -- http://www.openlinksw.com/blogs/
     LinkedIn -- http://www.linkedin.com/company/openlink-software/
     Twitter  -- http://twitter.com/OpenLink
     Google+  -- http://plus.google.com/100570109519069333827/
     Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

[Iodbc-macosx] iODBC headers are not found in Xcode

[Igor K. <iko...@gm...>]

Hi, list,
I'm trying to build my application with Xcode 5.1.1 on OSX 10.8.
Xcode was installed alone with iODBC and then I installed iODBC from
the bundle.

I then created a project inside Xcode but trying to compile I got an
error about sqlext.h file not found. So I added the "/usr/include" to the
"Header Search Path" and tried to compile again. I received exactly
same error.

So now my question is: how do I setup Xcode in order to build my app?

Thank you.

Re: [Iodbc-macosx] EL Capitan problems?

[Dmitry P. <dal...@gm...>]

Hi Steve,

I've built iODBC framework from source code on github and indeed it helped.
Thx Steve. But my LibreOffice/OpenOffice doesn't show table list but I
think it's another topic.

Best Regards
Dmitry Pogorelov

2016-02-21 23:40 GMT+01:00 Steve Palm <n9...@n9...>:

>
> On Feb 20, 2016, at 4:06 AM, Dmitry Pogorelov <dal...@gm...> wrote:
>
> hm... I thought that the latest version of iODBC Driver Manager 3.52.10 (
> http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads) has been built
> from the latest version of source code in
> https://github.com/openlink/iODBC. That is your version of iODBC built
> from https://github.com/openlink/iODBC should be 3.52.10 iODBC posted in
> http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads. I don't know
> but maybe there is a difference... Anyway, Steve thanks a lot for the info.
> I should try to build it on my mac.
>
>
>  I built from the "develop" branch, not "master".  There are some
> pulls/fixes in there after the release date of the web version... 3.52.10
> shows a release date of 2015-02-10.  So maybe one of those later fixes are
> responsible for the change in behavior.
>
>  -Steve
>
>

Re: [Iodbc-macosx] EL Capitan problems?

[Steve P. <n9...@n9...>]

On Feb 20, 2016, at 4:06 AM, Dmitry Pogorelov <dal...@gm...> wrote:
> hm... I thought that the latest version of iODBC Driver Manager 3.52.10 (http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads <http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads>) has been built from the latest version of source code in https://github.com/openlink/iODBC <https://github.com/openlink/iODBC>. That is your version of iODBC built from https://github.com/openlink/iODBC <https://github.com/openlink/iODBC> should be 3.52.10 iODBC posted in http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads <http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads>. I don't know but maybe there is a difference... Anyway, Steve thanks a lot for the info. I should try to build it on my mac.

 I built from the "develop" branch, not "master".  There are some pulls/fixes in there after the release date of the web version... 3.52.10 shows a release date of 2015-02-10.  So maybe one of those later fixes are responsible for the change in behavior.

 -Steve

Re: [Iodbc-macosx] EL Capitan problems?

[Steve P. <n9...@n9...>]

On Feb 20, 2016, at 4:14 AM, Dmitry Pogorelov <dal...@gm...> wrote:
> By the way Steve, could you check please LibreOffice or OpenOffice (note that only 4.1.1 version of OpenOffice works for mac) if you can see table list in Base via your odbc drivers?

 I didn't do a lot of testing...  But it seems to work.

 I opened up my installed OpenOffice (which I don't use much) which is "OpenOffice 4.1.1 AOO411m6(Build:9775)", and I was able to create a database of type ODBC and have it connect and pull in the table list, and in the Build Query view I could drag tables in, but when I drew a connection line between two tables it crashed. But I don't think that is ODBC related. :)

 In LibreOffice (Version: 5.1.0.1) I did the same steps, and all worked. I was able to finish the query to do a simple data pull and it worked fine.

So, I can't answer why the version of the iODBC Framework I built and installed worked different than the official ones if they are the same codebase, all I can say is that they are working whereas the ones I installed from the web download did not.

I hope you are able to get it working.  And, on the brighter side, this may mean there is not a lot of involved debugging needed for the development team, except to determine why the build on my 10.11 system works where the official build does not.

 -Steve

Re: [Iodbc-macosx] EL Capitan problems?

[Dmitry P. <dal...@gm...>]

By the way Steve, could you check please LibreOffice or OpenOffice (note
that only 4.1.1 version of OpenOffice works for mac) if you can see table
list in Base via your odbc drivers?
Thank you.

Best Regards
Dmitry Pogorelov

2016-02-20 11:06 GMT+01:00 Dmitry Pogorelov <dal...@gm...>:

> Hi,
>
> hm... I thought that the latest version of iODBC Driver Manager 3.52.10 (
> http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads) has been built
> from the latest version of source code in
> https://github.com/openlink/iODBC. That is your version of iODBC built
> from https://github.com/openlink/iODBC should be 3.52.10 iODBC posted in
> http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads. I don't know
> but maybe there is a difference... Anyway, Steve thanks a lot for the info.
> I should try to build it on my mac.
>
> Best Regards
> Dmitry Pogorelov
>
> 2016-02-20 4:26 GMT+01:00 Steve Palm <n9...@n9...>:
>
>> One more update, it seems the SQLite3 connector failure in Excel 2016 may
>> have been because of sandboxing and the location of the data file I was
>> testing against, which may be why it failed.  I tried it with a different
>> data set and it seems to work, so maybe all is working as it should now.
>> Huzzah!  :)
>>
>> On Feb 19, 2016, at 8:33 PM, Steve Palm <n9...@n9...> wrote:
>>
>> One more note...
>>
>> I just built the sources from Github and installed them:
>>
>>  https://github.com/openlink/iODBC
>>
>> First thing I noticed that was a pleasant surprise is that the CONFIGURE
>> and TEST buttons now work in the iODBC Administrator app *AND* when the GUI
>> is invoked from an ODBC application.
>>
>> When I try to connect to the database from Excel 2011, it now prompts me
>> for a username/password, which I don't think I ever saw before (but my
>> memory is bad), but even for a SQLite3 database (through an ODBC
>> connector).  In Excel 2011 it works, no more crashing (at least in early
>> testing.)
>>
>> When I try to connect to the database in Excel 2016 I also get the prompt
>> for username and password (Yay!), and *NO CRASHES*, but it doesn't work for
>> the SQLite3 database connector, it says connect failed.  However, for my
>> MySQL database (my main need, actually) it works!  :) :)  So, for Excel
>> 2016, this may be pointing to an error in the SQLite3 connector, or that it
>> can't handle a blank user/password, or something else... Unsure.  The TEST
>> button does work, but not a connection to the database.
>>
>> So hopefully this helps.  Building was very easy, I only had to make a
>> small change to the Makefile so it would build on my 10.11 system by adding
>> a section copied from the one for 10.10, just changing 10.10 to 10.11 in
>> all the lines.
>>
>> I will do more testing, but this is very encouraging.
>>
>>  -Steve
>>
>>
>> On Feb 19, 2016, at 6:57 AM, Dmitry Pogorelov <dal...@gm...> wrote:
>>
>> Hi Steve and Patrick,
>>
>> I have the same problem related to Excel 2016 and sandbox:
>> Feb 19 13:22:38 localhost loginwindow[99]:
>> -[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:]
>> Notified of item changes to list with identifier
>> com.apple.LSSharedFileList.RecentApplications
>> Feb 19 13:22:38 localhost sandboxd[127] ([57827]): Microsoft Excel(57827)
>> deny file-read-data /usr/local/lib
>> Feb 19 13:22:38 localhost kernel[0]: warning: Microsoft Error (57836)
>> performed out-of-band resume on pid 57827
>> Feb 19 13:24:23 localhost loginwindow[99]:
>> -[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:]
>> Notified of item changes to list with identifier
>> com.apple.LSSharedFileList.RecentApplications
>> Feb 19 13:24:23 localhost taskgated[151]: no application identifier
>> provided, can't use provisioning profiles [pid=57852]
>> Feb 19 13:24:23 localhost taskgated[151]: no application identifier
>> provided, can't use provisioning profiles [pid=57853]
>> Feb 19 13:24:24 localhost kernel[0]: IGAccelDevice: IOUserClient
>> outputCount count mismatch
>> Feb 19 13:24:24 localhost Microsoft Excel[57852]:
>> NSAllowAppKitWeakReferences=YES
>> Feb 19 13:24:43 localhost taskgated[151]: no application identifier
>> provided, can't use provisioning profiles [pid=57861]
>>
>> though I've copied all libs to my local folder changing all dependencies
>> via install_name_tool. Furthermore I can't get table list in
>> LibreOffice/OpenOffice via psql and mysql drivers built for using iODBC -
>> but I don't know if the problem is on LO/OO side or not.
>>
>> Best Regards,
>> Dmitrii
>>
>> Best Regards
>> Dmitry Pogorelov
>>
>> 2016-02-16 18:31 GMT+01:00 Steve Palm <n9...@n9...>:
>>
>>> As a follow-up to this, some more information on the problems.
>>>
>>> Some were self-inflicted, as in using a bad SQL statement and
>>> misinterpreting the errors returned.
>>>
>>> I also just updated to the latest 5.3.4 MySQL connector, I was using
>>> 5.3.2. This was to be sure this was not the problem.
>>>
>>> Since I cannot get the OpenLink ODBC Administrator program to work (the
>>> Configure button does nothing except put an entry in the console log):
>>>
>>> 2/16/16 10:27:18.451 AM iODBC Administrator[18292]: iODBC
>>> Administrator(18292,0xa3b1e000) malloc: *** error for object 0x90acc9c7:
>>> pointer being freed was not allocated
>>> *** set a breakpoint in malloc_error_break to debug
>>>
>>> So I tried using this ODBC GUI manager:
>>>
>>> http://www.odbcmanager.net
>>>
>>> It seemed to work OK, and manually examining the odbc.ini/odbcinst.ini
>>> files looked OK, yet when trying "iodbctest" I was still getting a variety
>>> of errors... Either that it could not prompt for additional information (I
>>> know the MySQL connector for Mac does not have a GUI component), or that it
>>> could not process the connect string.
>>>
>>> I also found (did not know previously) that I could query the odbc.ini
>>> file from the myodbc_installer binary to see what values it could extract.
>>> This revealed that, for some reason, it could not read the PWD value even
>>> though it was in the file.
>>>
>>> After reworking odbc.ini by hand, though, I finally got it to the point
>>> where it would connect, so I could do:
>>>
>>> iodbctest "DSN=test-5a"
>>>
>>> ...and it would connect and work. So, for whatever reason or whatever
>>> else was wrong before, at least this should prove that the basics are in
>>> place.
>>>
>>> Excel 2011, from VBA, continues to work, and in fact I could now remove
>>> some of the DSN parameters I was having to add before to the connect string
>>> as it is able to pull them from the odbc.ini.  So something in the
>>> formatting of that file was not 100% proper it would seem.
>>>
>>> Data -> Get External Data -> New Database Query...
>>>
>>> This opens the "iODBC Data Source Chooser" dialog, and I can pick the
>>> same DSN I use in VBA, and I get the same strange error I was getting
>>> before:
>>>
>>> [MySQL][ODBC 5.3(a) Driver]Access denied for user {garbage chars}@'host.ip.addr.here'
>>> (using password: YES)
>>>
>>> In the console log I also see these errors:
>>>
>>> 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft
>>> Query(18930,0xa3b1e000) malloc: *** error for object 0xb347a2a: pointer
>>> being freed was not allocated
>>> *** set a breakpoint in malloc_error_break to debug
>>> 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft
>>> Query(18930,0xa3b1e000) malloc: *** error for object 0x302aa00: pointer
>>> being freed was not allocated
>>> *** set a breakpoint in malloc_error_break to debug
>>>
>>>
>>> Excel 2016, when doing the same thing, crashes:
>>>
>>> Thread 0 crashed:
>>>
>>> #  1   0x530d7b9 in  (merp + 0x000037b9)        0x0
>>> #  2  0x938d579b in __sigtramp + 0x0000002B (libsystem_platform.dylib +
>>> 0x0000279b)        0x0
>>> #  3  0xffffffff in  ( + 0x00000000) 0xbff3cb18
>>> #  4  0x97825c34 in _abort + 0x0000009C (libsystem_c.dylib + 0x0005ec34)
>>> 0xbff3cee8
>>> #  5  0x90ace292 in _free + 0x000001B1 (libsystem_malloc.dylib +
>>> 0x00004292) 0xbff3cf18
>>> #  6  0x2bdc8cac in __iodbcdm_drvconn_dialbox + 0x0000027C
>>> (iODBCdrvproxy + 0x00001cac) 0xbff3cf58
>>> #  7  0x2fb42f8d in _iodbcdm_drvconn_dialboxw + 0x00001ECD (iODBCadm +
>>> 0x00002f8d) 0xbff3cfc8
>>> #  8  0x2fb4106c in _iodbcdm_drvconn_dialbox + 0x0000007C (iODBCadm +
>>> 0x0000106c) 0xbff4a8a8
>>> #  9  0x2fb0ec44 in _SQLDriverConnect_Internal + 0x00000BF4 (iODBC +
>>> 0x00011c44) 0xbff4a8d8
>>> # 10  0x2fb102c2 in _SQLDriverConnect + 0x00000152 (iODBC + 0x000132c2)
>>> 0xbff52198
>>> # 11    0x5807ad in  (Microsoft Excel + 0x004d47ad) 0xbff521e8
>>>
>>> But something new I had not seen before in the console log, four times:
>>> 2/16/16 10:57:59.115 AM sandboxd[266]: ([18699]) Microsoft Excel(18699)
>>> deny file-read-data /usr/local/lib/libmyodbc5a.so
>>>
>>> I tried to research this, and the field is not quarantined (has no
>>> extended attributes), and has no special ACL on it.
>>>
>>> However, I moved the library files out of /usr/local/lib and put them
>>> into /Librarry/ODBC/ODBCDataSources, and I updated the odbc.ini and
>>> odbcinst.ini files.  Now Excel 2016 no longer gives the sandbox errors, but
>>> I get this when I try to pick a data source:
>>>
>>> 2/16/16 11:21:30.670 AM Microsoft Excel[18910]: Microsoft
>>> Excel(18910,0xa3b1e000) malloc: *** error for object 0x2b47aa2a: pointer
>>> being freed was not allocated
>>> *** set a breakpoint in malloc_error_break to debug
>>> 2/16/16 11:21:30.699 AM taskgated[185]: no application identifier
>>> provided, can't use provisioning profiles [pid=18921]
>>> 2/16/16 11:21:30.787 AM Microsoft Error Reporting[18921]:
>>> ApplePersistence=YES
>>> 2/16/16 11:21:31.000 AM kernel[0]: warning: Microsoft Error (18921)
>>> performed out-of-band resume on pid 18910
>>>
>>>
>>> Seems similar to the error Excel 2011 is getting, and that the iODBC
>>> Administrator is getting, but maybe not.  But it seems to happen when these
>>> apps try to work with the GUI iODBC Data Chooser.
>>>
>>>
>>> Also, trying to use the "iODBC Demo (Ansi)" app to connect gives the
>>> same error as Excel 2011... The dialog box stating access is denied with
>>> some garbage characters in place of the username, also throwing these
>>> errors in console:
>>>
>>> 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo
>>> Ansi(18950,0xa3b1e000) malloc: *** error for object 0xae78a2a: pointer
>>> being freed was not allocated
>>> *** set a breakpoint in malloc_error_break to debug
>>> 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo
>>> Ansi(18950,0xa3b1e000) malloc: *** error for object 0x4065c00: pointer
>>> being freed was not allocated
>>> *** set a breakpoint in malloc_error_break to debug
>>>
>>> I had another app on my system, "iQueryODBC", and if I put in the
>>> DSN=test-5a in the connection box, it will work. However, if I use the
>>> "select" button to pick a datasource, then I get the same behavior with the
>>> garbage characters in place of the username and putting the same type of
>>> errors in the console:
>>>
>>> 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000)
>>> malloc: *** error for object 0xfcfaa2a: pointer being freed was not
>>> allocated
>>> *** set a breakpoint in malloc_error_break to debug
>>> 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000)
>>> malloc: *** error for object 0x2086e00: pointer being freed was not
>>> allocated
>>> *** set a breakpoint in malloc_error_break to debug
>>>
>>> Not sure where to go further with this.
>>>
>>> I hope this is helpful in tracking this down.
>>>
>>>  -Steve
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>> Monitor end-to-end web transactions and take corrective actions now
>>> Troubleshoot faster and improve end-user experience. Signup Now!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>>> _______________________________________________
>>> Iodbc-macosx mailing list
>>> Iod...@li...
>>> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________
>> Iodbc-macosx mailing list
>> Iod...@li...
>> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________
>> Iodbc-macosx mailing list
>> Iod...@li...
>> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>> _______________________________________________
>> Iodbc-macosx mailing list
>> Iod...@li...
>> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx
>>
>>
>

Re: [Iodbc-macosx] EL Capitan problems?

[Dmitry P. <dal...@gm...>]

Hi,

hm... I thought that the latest version of iODBC Driver Manager 3.52.10 (
http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads) has been built
from the latest version of source code in https://github.com/openlink/iODBC.
That is your version of iODBC built from https://github.com/openlink/iODBC
should be 3.52.10 iODBC posted in
http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads. I don't know but
maybe there is a difference... Anyway, Steve thanks a lot for the info. I
should try to build it on my mac.

Best Regards
Dmitry Pogorelov

2016-02-20 4:26 GMT+01:00 Steve Palm <n9...@n9...>:

> One more update, it seems the SQLite3 connector failure in Excel 2016 may
> have been because of sandboxing and the location of the data file I was
> testing against, which may be why it failed.  I tried it with a different
> data set and it seems to work, so maybe all is working as it should now.
> Huzzah!  :)
>
> On Feb 19, 2016, at 8:33 PM, Steve Palm <n9...@n9...> wrote:
>
> One more note...
>
> I just built the sources from Github and installed them:
>
>  https://github.com/openlink/iODBC
>
> First thing I noticed that was a pleasant surprise is that the CONFIGURE
> and TEST buttons now work in the iODBC Administrator app *AND* when the GUI
> is invoked from an ODBC application.
>
> When I try to connect to the database from Excel 2011, it now prompts me
> for a username/password, which I don't think I ever saw before (but my
> memory is bad), but even for a SQLite3 database (through an ODBC
> connector).  In Excel 2011 it works, no more crashing (at least in early
> testing.)
>
> When I try to connect to the database in Excel 2016 I also get the prompt
> for username and password (Yay!), and *NO CRASHES*, but it doesn't work for
> the SQLite3 database connector, it says connect failed.  However, for my
> MySQL database (my main need, actually) it works!  :) :)  So, for Excel
> 2016, this may be pointing to an error in the SQLite3 connector, or that it
> can't handle a blank user/password, or something else... Unsure.  The TEST
> button does work, but not a connection to the database.
>
> So hopefully this helps.  Building was very easy, I only had to make a
> small change to the Makefile so it would build on my 10.11 system by adding
> a section copied from the one for 10.10, just changing 10.10 to 10.11 in
> all the lines.
>
> I will do more testing, but this is very encouraging.
>
>  -Steve
>
>
> On Feb 19, 2016, at 6:57 AM, Dmitry Pogorelov <dal...@gm...> wrote:
>
> Hi Steve and Patrick,
>
> I have the same problem related to Excel 2016 and sandbox:
> Feb 19 13:22:38 localhost loginwindow[99]:
> -[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:]
> Notified of item changes to list with identifier
> com.apple.LSSharedFileList.RecentApplications
> Feb 19 13:22:38 localhost sandboxd[127] ([57827]): Microsoft Excel(57827)
> deny file-read-data /usr/local/lib
> Feb 19 13:22:38 localhost kernel[0]: warning: Microsoft Error (57836)
> performed out-of-band resume on pid 57827
> Feb 19 13:24:23 localhost loginwindow[99]:
> -[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:]
> Notified of item changes to list with identifier
> com.apple.LSSharedFileList.RecentApplications
> Feb 19 13:24:23 localhost taskgated[151]: no application identifier
> provided, can't use provisioning profiles [pid=57852]
> Feb 19 13:24:23 localhost taskgated[151]: no application identifier
> provided, can't use provisioning profiles [pid=57853]
> Feb 19 13:24:24 localhost kernel[0]: IGAccelDevice: IOUserClient
> outputCount count mismatch
> Feb 19 13:24:24 localhost Microsoft Excel[57852]:
> NSAllowAppKitWeakReferences=YES
> Feb 19 13:24:43 localhost taskgated[151]: no application identifier
> provided, can't use provisioning profiles [pid=57861]
>
> though I've copied all libs to my local folder changing all dependencies
> via install_name_tool. Furthermore I can't get table list in
> LibreOffice/OpenOffice via psql and mysql drivers built for using iODBC -
> but I don't know if the problem is on LO/OO side or not.
>
> Best Regards,
> Dmitrii
>
> Best Regards
> Dmitry Pogorelov
>
> 2016-02-16 18:31 GMT+01:00 Steve Palm <n9...@n9...>:
>
>> As a follow-up to this, some more information on the problems.
>>
>> Some were self-inflicted, as in using a bad SQL statement and
>> misinterpreting the errors returned.
>>
>> I also just updated to the latest 5.3.4 MySQL connector, I was using
>> 5.3.2. This was to be sure this was not the problem.
>>
>> Since I cannot get the OpenLink ODBC Administrator program to work (the
>> Configure button does nothing except put an entry in the console log):
>>
>> 2/16/16 10:27:18.451 AM iODBC Administrator[18292]: iODBC
>> Administrator(18292,0xa3b1e000) malloc: *** error for object 0x90acc9c7:
>> pointer being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>>
>> So I tried using this ODBC GUI manager:
>>
>> http://www.odbcmanager.net
>>
>> It seemed to work OK, and manually examining the odbc.ini/odbcinst.ini
>> files looked OK, yet when trying "iodbctest" I was still getting a variety
>> of errors... Either that it could not prompt for additional information (I
>> know the MySQL connector for Mac does not have a GUI component), or that it
>> could not process the connect string.
>>
>> I also found (did not know previously) that I could query the odbc.ini
>> file from the myodbc_installer binary to see what values it could extract.
>> This revealed that, for some reason, it could not read the PWD value even
>> though it was in the file.
>>
>> After reworking odbc.ini by hand, though, I finally got it to the point
>> where it would connect, so I could do:
>>
>> iodbctest "DSN=test-5a"
>>
>> ...and it would connect and work. So, for whatever reason or whatever
>> else was wrong before, at least this should prove that the basics are in
>> place.
>>
>> Excel 2011, from VBA, continues to work, and in fact I could now remove
>> some of the DSN parameters I was having to add before to the connect string
>> as it is able to pull them from the odbc.ini.  So something in the
>> formatting of that file was not 100% proper it would seem.
>>
>> Data -> Get External Data -> New Database Query...
>>
>> This opens the "iODBC Data Source Chooser" dialog, and I can pick the
>> same DSN I use in VBA, and I get the same strange error I was getting
>> before:
>>
>> [MySQL][ODBC 5.3(a) Driver]Access denied for user {garbage chars}@'host.ip.addr.here'
>> (using password: YES)
>>
>> In the console log I also see these errors:
>>
>> 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft
>> Query(18930,0xa3b1e000) malloc: *** error for object 0xb347a2a: pointer
>> being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft
>> Query(18930,0xa3b1e000) malloc: *** error for object 0x302aa00: pointer
>> being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>>
>>
>> Excel 2016, when doing the same thing, crashes:
>>
>> Thread 0 crashed:
>>
>> #  1   0x530d7b9 in  (merp + 0x000037b9)        0x0
>> #  2  0x938d579b in __sigtramp + 0x0000002B (libsystem_platform.dylib +
>> 0x0000279b)        0x0
>> #  3  0xffffffff in  ( + 0x00000000) 0xbff3cb18
>> #  4  0x97825c34 in _abort + 0x0000009C (libsystem_c.dylib + 0x0005ec34)
>> 0xbff3cee8
>> #  5  0x90ace292 in _free + 0x000001B1 (libsystem_malloc.dylib +
>> 0x00004292) 0xbff3cf18
>> #  6  0x2bdc8cac in __iodbcdm_drvconn_dialbox + 0x0000027C (iODBCdrvproxy
>> + 0x00001cac) 0xbff3cf58
>> #  7  0x2fb42f8d in _iodbcdm_drvconn_dialboxw + 0x00001ECD (iODBCadm +
>> 0x00002f8d) 0xbff3cfc8
>> #  8  0x2fb4106c in _iodbcdm_drvconn_dialbox + 0x0000007C (iODBCadm +
>> 0x0000106c) 0xbff4a8a8
>> #  9  0x2fb0ec44 in _SQLDriverConnect_Internal + 0x00000BF4 (iODBC +
>> 0x00011c44) 0xbff4a8d8
>> # 10  0x2fb102c2 in _SQLDriverConnect + 0x00000152 (iODBC + 0x000132c2)
>> 0xbff52198
>> # 11    0x5807ad in  (Microsoft Excel + 0x004d47ad) 0xbff521e8
>>
>> But something new I had not seen before in the console log, four times:
>> 2/16/16 10:57:59.115 AM sandboxd[266]: ([18699]) Microsoft Excel(18699)
>> deny file-read-data /usr/local/lib/libmyodbc5a.so
>>
>> I tried to research this, and the field is not quarantined (has no
>> extended attributes), and has no special ACL on it.
>>
>> However, I moved the library files out of /usr/local/lib and put them
>> into /Librarry/ODBC/ODBCDataSources, and I updated the odbc.ini and
>> odbcinst.ini files.  Now Excel 2016 no longer gives the sandbox errors, but
>> I get this when I try to pick a data source:
>>
>> 2/16/16 11:21:30.670 AM Microsoft Excel[18910]: Microsoft
>> Excel(18910,0xa3b1e000) malloc: *** error for object 0x2b47aa2a: pointer
>> being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 2/16/16 11:21:30.699 AM taskgated[185]: no application identifier
>> provided, can't use provisioning profiles [pid=18921]
>> 2/16/16 11:21:30.787 AM Microsoft Error Reporting[18921]:
>> ApplePersistence=YES
>> 2/16/16 11:21:31.000 AM kernel[0]: warning: Microsoft Error (18921)
>> performed out-of-band resume on pid 18910
>>
>>
>> Seems similar to the error Excel 2011 is getting, and that the iODBC
>> Administrator is getting, but maybe not.  But it seems to happen when these
>> apps try to work with the GUI iODBC Data Chooser.
>>
>>
>> Also, trying to use the "iODBC Demo (Ansi)" app to connect gives the same
>> error as Excel 2011... The dialog box stating access is denied with some
>> garbage characters in place of the username, also throwing these errors in
>> console:
>>
>> 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo
>> Ansi(18950,0xa3b1e000) malloc: *** error for object 0xae78a2a: pointer
>> being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo
>> Ansi(18950,0xa3b1e000) malloc: *** error for object 0x4065c00: pointer
>> being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>>
>> I had another app on my system, "iQueryODBC", and if I put in the
>> DSN=test-5a in the connection box, it will work. However, if I use the
>> "select" button to pick a datasource, then I get the same behavior with the
>> garbage characters in place of the username and putting the same type of
>> errors in the console:
>>
>> 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000)
>> malloc: *** error for object 0xfcfaa2a: pointer being freed was not
>> allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000)
>> malloc: *** error for object 0x2086e00: pointer being freed was not
>> allocated
>> *** set a breakpoint in malloc_error_break to debug
>>
>> Not sure where to go further with this.
>>
>> I hope this is helpful in tracking this down.
>>
>>  -Steve
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>> _______________________________________________
>> Iodbc-macosx mailing list
>> Iod...@li...
>> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx
>>
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
>
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________
> Iodbc-macosx mailing list
> Iod...@li...
> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx
>
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
>
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________
> Iodbc-macosx mailing list
> Iod...@li...
> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx
>
>
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Iodbc-macosx mailing list
> Iod...@li...
> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx
>
>

Re: [Iodbc-macosx] EL Capitan problems?

[Steve P. <n9...@n9...>]

One more update, it seems the SQLite3 connector failure in Excel 2016 may have been because of sandboxing and the location of the data file I was testing against, which may be why it failed.  I tried it with a different data set and it seems to work, so maybe all is working as it should now.  Huzzah!  :)

> On Feb 19, 2016, at 8:33 PM, Steve Palm <n9...@n9...> wrote:
> 
> One more note...
> 
> I just built the sources from Github and installed them:
> 
>  https://github.com/openlink/iODBC <https://github.com/openlink/iODBC>
> 
> First thing I noticed that was a pleasant surprise is that the CONFIGURE and TEST buttons now work in the iODBC Administrator app *AND* when the GUI is invoked from an ODBC application.
> 
> When I try to connect to the database from Excel 2011, it now prompts me for a username/password, which I don't think I ever saw before (but my memory is bad), but even for a SQLite3 database (through an ODBC connector).  In Excel 2011 it works, no more crashing (at least in early testing.)
> 
> When I try to connect to the database in Excel 2016 I also get the prompt for username and password (Yay!), and *NO CRASHES*, but it doesn't work for the SQLite3 database connector, it says connect failed.  However, for my MySQL database (my main need, actually) it works!  :) :)  So, for Excel 2016, this may be pointing to an error in the SQLite3 connector, or that it can't handle a blank user/password, or something else... Unsure.  The TEST button does work, but not a connection to the database.
> 
> So hopefully this helps.  Building was very easy, I only had to make a small change to the Makefile so it would build on my 10.11 system by adding a section copied from the one for 10.10, just changing 10.10 to 10.11 in all the lines.
> 
> I will do more testing, but this is very encouraging.
> 
>  -Steve
> 
> 
>> On Feb 19, 2016, at 6:57 AM, Dmitry Pogorelov <dal...@gm... <mailto:dal...@gm...>> wrote:
>> 
>> Hi Steve and Patrick,
>> 
>> I have the same problem related to Excel 2016 and sandbox:
>> Feb 19 13:22:38 localhost loginwindow[99]: -[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:] Notified of item changes to list with identifier com.apple.LSSharedFileList.RecentApplications
>> Feb 19 13:22:38 localhost sandboxd[127] ([57827]): Microsoft Excel(57827) deny file-read-data /usr/local/lib
>> Feb 19 13:22:38 localhost kernel[0]: warning: Microsoft Error (57836) performed out-of-band resume on pid 57827
>> Feb 19 13:24:23 localhost loginwindow[99]: -[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:] Notified of item changes to list with identifier com.apple.LSSharedFileList.RecentApplications
>> Feb 19 13:24:23 localhost taskgated[151]: no application identifier provided, can't use provisioning profiles [pid=57852]
>> Feb 19 13:24:23 localhost taskgated[151]: no application identifier provided, can't use provisioning profiles [pid=57853]
>> Feb 19 13:24:24 localhost kernel[0]: IGAccelDevice: IOUserClient outputCount count mismatch
>> Feb 19 13:24:24 localhost Microsoft Excel[57852]: NSAllowAppKitWeakReferences=YES
>> Feb 19 13:24:43 localhost taskgated[151]: no application identifier provided, can't use provisioning profiles [pid=57861]
>> 
>> though I've copied all libs to my local folder changing all dependencies via install_name_tool. Furthermore I can't get table list in LibreOffice/OpenOffice via psql and mysql drivers built for using iODBC - but I don't know if the problem is on LO/OO side or not.
>> 
>> Best Regards,
>> Dmitrii
>> 
>> Best Regards
>> Dmitry Pogorelov
>> 
>> 2016-02-16 18:31 GMT+01:00 Steve Palm <n9...@n9... <mailto:n9...@n9...>>:
>> As a follow-up to this, some more information on the problems.
>> 
>> Some were self-inflicted, as in using a bad SQL statement and misinterpreting the errors returned.
>> 
>> I also just updated to the latest 5.3.4 MySQL connector, I was using 5.3.2. This was to be sure this was not the problem.
>> 
>> Since I cannot get the OpenLink ODBC Administrator program to work (the Configure button does nothing except put an entry in the console log):
>> 
>> 2/16/16 10:27:18.451 AM iODBC Administrator[18292]: iODBC Administrator(18292,0xa3b1e000) malloc: *** error for object 0x90acc9c7: pointer being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 
>> So I tried using this ODBC GUI manager:
>> 
>> http://www.odbcmanager.net <http://www.odbcmanager.net/>
>> 
>> It seemed to work OK, and manually examining the odbc.ini/odbcinst.ini files looked OK, yet when trying "iodbctest" I was still getting a variety of errors... Either that it could not prompt for additional information (I know the MySQL connector for Mac does not have a GUI component), or that it could not process the connect string.
>> 
>> I also found (did not know previously) that I could query the odbc.ini file from the myodbc_installer binary to see what values it could extract. This revealed that, for some reason, it could not read the PWD value even though it was in the file.
>> 
>> After reworking odbc.ini by hand, though, I finally got it to the point where it would connect, so I could do:
>> 
>> iodbctest "DSN=test-5a"
>> 
>> ...and it would connect and work. So, for whatever reason or whatever else was wrong before, at least this should prove that the basics are in place.
>> 
>> Excel 2011, from VBA, continues to work, and in fact I could now remove some of the DSN parameters I was having to add before to the connect string as it is able to pull them from the odbc.ini.  So something in the formatting of that file was not 100% proper it would seem.
>> 
>> Data -> Get External Data -> New Database Query...
>> 
>> This opens the "iODBC Data Source Chooser" dialog, and I can pick the same DSN I use in VBA, and I get the same strange error I was getting before:
>> 
>> [MySQL][ODBC 5.3(a) Driver]Access denied for user {garbage chars}@'host.ip.addr.here' (using password: YES)
>> 
>> In the console log I also see these errors:
>> 
>> 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft Query(18930,0xa3b1e000) malloc: *** error for object 0xb347a2a: pointer being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft Query(18930,0xa3b1e000) malloc: *** error for object 0x302aa00: pointer being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 
>> 
>> Excel 2016, when doing the same thing, crashes:
>> 
>> Thread 0 crashed:
>> 
>> #  1   0x530d7b9 in  (merp + 0x000037b9)        0x0
>> #  2  0x938d579b in __sigtramp + 0x0000002B (libsystem_platform.dylib + 0x0000279b)        0x0
>> #  3  0xffffffff in  ( + 0x00000000) 0xbff3cb18
>> #  4  0x97825c34 in _abort + 0x0000009C (libsystem_c.dylib + 0x0005ec34) 0xbff3cee8
>> #  5  0x90ace292 in _free + 0x000001B1 (libsystem_malloc.dylib + 0x00004292) 0xbff3cf18
>> #  6  0x2bdc8cac in __iodbcdm_drvconn_dialbox + 0x0000027C (iODBCdrvproxy + 0x00001cac) 0xbff3cf58
>> #  7  0x2fb42f8d in _iodbcdm_drvconn_dialboxw + 0x00001ECD (iODBCadm + 0x00002f8d) 0xbff3cfc8
>> #  8  0x2fb4106c in _iodbcdm_drvconn_dialbox + 0x0000007C (iODBCadm + 0x0000106c) 0xbff4a8a8
>> #  9  0x2fb0ec44 in _SQLDriverConnect_Internal + 0x00000BF4 (iODBC + 0x00011c44) 0xbff4a8d8
>> # 10  0x2fb102c2 in _SQLDriverConnect + 0x00000152 (iODBC + 0x000132c2) 0xbff52198
>> # 11    0x5807ad in  (Microsoft Excel + 0x004d47ad) 0xbff521e8
>> 
>> But something new I had not seen before in the console log, four times:
>> 2/16/16 10:57:59.115 AM sandboxd[266]: ([18699]) Microsoft Excel(18699) deny file-read-data /usr/local/lib/libmyodbc5a.so
>> 
>> I tried to research this, and the field is not quarantined (has no extended attributes), and has no special ACL on it.
>> 
>> However, I moved the library files out of /usr/local/lib and put them into /Librarry/ODBC/ODBCDataSources, and I updated the odbc.ini and odbcinst.ini files.  Now Excel 2016 no longer gives the sandbox errors, but I get this when I try to pick a data source:
>> 
>> 2/16/16 11:21:30.670 AM Microsoft Excel[18910]: Microsoft Excel(18910,0xa3b1e000) malloc: *** error for object 0x2b47aa2a: pointer being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 2/16/16 11:21:30.699 AM taskgated[185]: no application identifier provided, can't use provisioning profiles [pid=18921]
>> 2/16/16 11:21:30.787 AM Microsoft Error Reporting[18921]: ApplePersistence=YES
>> 2/16/16 11:21:31.000 AM kernel[0]: warning: Microsoft Error (18921) performed out-of-band resume on pid 18910
>> 
>> 
>> Seems similar to the error Excel 2011 is getting, and that the iODBC Administrator is getting, but maybe not.  But it seems to happen when these apps try to work with the GUI iODBC Data Chooser.
>> 
>> 
>> Also, trying to use the "iODBC Demo (Ansi)" app to connect gives the same error as Excel 2011... The dialog box stating access is denied with some garbage characters in place of the username, also throwing these errors in console:
>> 
>> 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo Ansi(18950,0xa3b1e000) malloc: *** error for object 0xae78a2a: pointer being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo Ansi(18950,0xa3b1e000) malloc: *** error for object 0x4065c00: pointer being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 
>> I had another app on my system, "iQueryODBC", and if I put in the DSN=test-5a in the connection box, it will work. However, if I use the "select" button to pick a datasource, then I get the same behavior with the garbage characters in place of the username and putting the same type of errors in the console:
>> 
>> 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000) malloc: *** error for object 0xfcfaa2a: pointer being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000) malloc: *** error for object 0x2086e00: pointer being freed was not allocated
>> *** set a breakpoint in malloc_error_break to debug
>> 
>> Not sure where to go further with this.
>> 
>> I hope this is helpful in tracking this down.
>> 
>>  -Steve
>> 
>> 
>> ------------------------------------------------------------------------------
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 <http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140>
>> _______________________________________________
>> Iodbc-macosx mailing list
>> Iod...@li... <mailto:Iod...@li...>
>> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx <https://lists.sourceforge.net/lists/listinfo/iodbc-macosx>
>> 
>> ------------------------------------------------------------------------------
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________ <http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________>
>> Iodbc-macosx mailing list
>> Iod...@li...
>> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx
> 
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________
> Iodbc-macosx mailing list
> Iod...@li...
> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx

Re: [Iodbc-macosx] EL Capitan problems?

[Steve P. <n9...@n9...>]

One more note...

I just built the sources from Github and installed them:

 https://github.com/openlink/iODBC

First thing I noticed that was a pleasant surprise is that the CONFIGURE and TEST buttons now work in the iODBC Administrator app *AND* when the GUI is invoked from an ODBC application.

When I try to connect to the database from Excel 2011, it now prompts me for a username/password, which I don't think I ever saw before (but my memory is bad), but even for a SQLite3 database (through an ODBC connector).  In Excel 2011 it works, no more crashing (at least in early testing.)

When I try to connect to the database in Excel 2016 I also get the prompt for username and password (Yay!), and *NO CRASHES*, but it doesn't work for the SQLite3 database connector, it says connect failed.  However, for my MySQL database (my main need, actually) it works!  :) :)  So, for Excel 2016, this may be pointing to an error in the SQLite3 connector, or that it can't handle a blank user/password, or something else... Unsure.  The TEST button does work, but not a connection to the database.

So hopefully this helps.  Building was very easy, I only had to make a small change to the Makefile so it would build on my 10.11 system by adding a section copied from the one for 10.10, just changing 10.10 to 10.11 in all the lines.

I will do more testing, but this is very encouraging.

 -Steve


> On Feb 19, 2016, at 6:57 AM, Dmitry Pogorelov <dal...@gm...> wrote:
> 
> Hi Steve and Patrick,
> 
> I have the same problem related to Excel 2016 and sandbox:
> Feb 19 13:22:38 localhost loginwindow[99]: -[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:] Notified of item changes to list with identifier com.apple.LSSharedFileList.RecentApplications
> Feb 19 13:22:38 localhost sandboxd[127] ([57827]): Microsoft Excel(57827) deny file-read-data /usr/local/lib
> Feb 19 13:22:38 localhost kernel[0]: warning: Microsoft Error (57836) performed out-of-band resume on pid 57827
> Feb 19 13:24:23 localhost loginwindow[99]: -[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:] Notified of item changes to list with identifier com.apple.LSSharedFileList.RecentApplications
> Feb 19 13:24:23 localhost taskgated[151]: no application identifier provided, can't use provisioning profiles [pid=57852]
> Feb 19 13:24:23 localhost taskgated[151]: no application identifier provided, can't use provisioning profiles [pid=57853]
> Feb 19 13:24:24 localhost kernel[0]: IGAccelDevice: IOUserClient outputCount count mismatch
> Feb 19 13:24:24 localhost Microsoft Excel[57852]: NSAllowAppKitWeakReferences=YES
> Feb 19 13:24:43 localhost taskgated[151]: no application identifier provided, can't use provisioning profiles [pid=57861]
> 
> though I've copied all libs to my local folder changing all dependencies via install_name_tool. Furthermore I can't get table list in LibreOffice/OpenOffice via psql and mysql drivers built for using iODBC - but I don't know if the problem is on LO/OO side or not.
> 
> Best Regards,
> Dmitrii
> 
> Best Regards
> Dmitry Pogorelov
> 
> 2016-02-16 18:31 GMT+01:00 Steve Palm <n9...@n9... <mailto:n9...@n9...>>:
> As a follow-up to this, some more information on the problems.
> 
> Some were self-inflicted, as in using a bad SQL statement and misinterpreting the errors returned.
> 
> I also just updated to the latest 5.3.4 MySQL connector, I was using 5.3.2. This was to be sure this was not the problem.
> 
> Since I cannot get the OpenLink ODBC Administrator program to work (the Configure button does nothing except put an entry in the console log):
> 
> 2/16/16 10:27:18.451 AM iODBC Administrator[18292]: iODBC Administrator(18292,0xa3b1e000) malloc: *** error for object 0x90acc9c7: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 
> So I tried using this ODBC GUI manager:
> 
> http://www.odbcmanager.net <http://www.odbcmanager.net/>
> 
> It seemed to work OK, and manually examining the odbc.ini/odbcinst.ini files looked OK, yet when trying "iodbctest" I was still getting a variety of errors... Either that it could not prompt for additional information (I know the MySQL connector for Mac does not have a GUI component), or that it could not process the connect string.
> 
> I also found (did not know previously) that I could query the odbc.ini file from the myodbc_installer binary to see what values it could extract. This revealed that, for some reason, it could not read the PWD value even though it was in the file.
> 
> After reworking odbc.ini by hand, though, I finally got it to the point where it would connect, so I could do:
> 
> iodbctest "DSN=test-5a"
> 
> ...and it would connect and work. So, for whatever reason or whatever else was wrong before, at least this should prove that the basics are in place.
> 
> Excel 2011, from VBA, continues to work, and in fact I could now remove some of the DSN parameters I was having to add before to the connect string as it is able to pull them from the odbc.ini.  So something in the formatting of that file was not 100% proper it would seem.
> 
> Data -> Get External Data -> New Database Query...
> 
> This opens the "iODBC Data Source Chooser" dialog, and I can pick the same DSN I use in VBA, and I get the same strange error I was getting before:
> 
> [MySQL][ODBC 5.3(a) Driver]Access denied for user {garbage chars}@'host.ip.addr.here' (using password: YES)
> 
> In the console log I also see these errors:
> 
> 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft Query(18930,0xa3b1e000) malloc: *** error for object 0xb347a2a: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft Query(18930,0xa3b1e000) malloc: *** error for object 0x302aa00: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 
> 
> Excel 2016, when doing the same thing, crashes:
> 
> Thread 0 crashed:
> 
> #  1   0x530d7b9 in  (merp + 0x000037b9)        0x0
> #  2  0x938d579b in __sigtramp + 0x0000002B (libsystem_platform.dylib + 0x0000279b)        0x0
> #  3  0xffffffff in  ( + 0x00000000) 0xbff3cb18
> #  4  0x97825c34 in _abort + 0x0000009C (libsystem_c.dylib + 0x0005ec34) 0xbff3cee8
> #  5  0x90ace292 in _free + 0x000001B1 (libsystem_malloc.dylib + 0x00004292) 0xbff3cf18
> #  6  0x2bdc8cac in __iodbcdm_drvconn_dialbox + 0x0000027C (iODBCdrvproxy + 0x00001cac) 0xbff3cf58
> #  7  0x2fb42f8d in _iodbcdm_drvconn_dialboxw + 0x00001ECD (iODBCadm + 0x00002f8d) 0xbff3cfc8
> #  8  0x2fb4106c in _iodbcdm_drvconn_dialbox + 0x0000007C (iODBCadm + 0x0000106c) 0xbff4a8a8
> #  9  0x2fb0ec44 in _SQLDriverConnect_Internal + 0x00000BF4 (iODBC + 0x00011c44) 0xbff4a8d8
> # 10  0x2fb102c2 in _SQLDriverConnect + 0x00000152 (iODBC + 0x000132c2) 0xbff52198
> # 11    0x5807ad in  (Microsoft Excel + 0x004d47ad) 0xbff521e8
> 
> But something new I had not seen before in the console log, four times:
> 2/16/16 10:57:59.115 AM sandboxd[266]: ([18699]) Microsoft Excel(18699) deny file-read-data /usr/local/lib/libmyodbc5a.so
> 
> I tried to research this, and the field is not quarantined (has no extended attributes), and has no special ACL on it.
> 
> However, I moved the library files out of /usr/local/lib and put them into /Librarry/ODBC/ODBCDataSources, and I updated the odbc.ini and odbcinst.ini files.  Now Excel 2016 no longer gives the sandbox errors, but I get this when I try to pick a data source:
> 
> 2/16/16 11:21:30.670 AM Microsoft Excel[18910]: Microsoft Excel(18910,0xa3b1e000) malloc: *** error for object 0x2b47aa2a: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 2/16/16 11:21:30.699 AM taskgated[185]: no application identifier provided, can't use provisioning profiles [pid=18921]
> 2/16/16 11:21:30.787 AM Microsoft Error Reporting[18921]: ApplePersistence=YES
> 2/16/16 11:21:31.000 AM kernel[0]: warning: Microsoft Error (18921) performed out-of-band resume on pid 18910
> 
> 
> Seems similar to the error Excel 2011 is getting, and that the iODBC Administrator is getting, but maybe not.  But it seems to happen when these apps try to work with the GUI iODBC Data Chooser.
> 
> 
> Also, trying to use the "iODBC Demo (Ansi)" app to connect gives the same error as Excel 2011... The dialog box stating access is denied with some garbage characters in place of the username, also throwing these errors in console:
> 
> 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo Ansi(18950,0xa3b1e000) malloc: *** error for object 0xae78a2a: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo Ansi(18950,0xa3b1e000) malloc: *** error for object 0x4065c00: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 
> I had another app on my system, "iQueryODBC", and if I put in the DSN=test-5a in the connection box, it will work. However, if I use the "select" button to pick a datasource, then I get the same behavior with the garbage characters in place of the username and putting the same type of errors in the console:
> 
> 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000) malloc: *** error for object 0xfcfaa2a: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000) malloc: *** error for object 0x2086e00: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 
> Not sure where to go further with this.
> 
> I hope this is helpful in tracking this down.
> 
>  -Steve
> 
> 
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 <http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140>
> _______________________________________________
> Iodbc-macosx mailing list
> Iod...@li... <mailto:Iod...@li...>
> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx <https://lists.sourceforge.net/lists/listinfo/iodbc-macosx>
> 
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________
> Iodbc-macosx mailing list
> Iod...@li...
> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx

Re: [Iodbc-macosx] EL Capitan problems?

[Dmitry P. <dal...@gm...>]

Hi Steve and Patrick,

I have the same problem related to Excel 2016 and sandbox:
Feb 19 13:22:38 localhost loginwindow[99]:
-[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:]
Notified of item changes to list with identifier
com.apple.LSSharedFileList.RecentApplications
Feb 19 13:22:38 localhost sandboxd[127] ([57827]): Microsoft Excel(57827)
deny file-read-data /usr/local/lib
Feb 19 13:22:38 localhost kernel[0]: warning: Microsoft Error (57836)
performed out-of-band resume on pid 57827
Feb 19 13:24:23 localhost loginwindow[99]:
-[SFLListManager(ServiceReplyProtocol) notifyChanges:toListWithIdentifier:]
Notified of item changes to list with identifier
com.apple.LSSharedFileList.RecentApplications
Feb 19 13:24:23 localhost taskgated[151]: no application identifier
provided, can't use provisioning profiles [pid=57852]
Feb 19 13:24:23 localhost taskgated[151]: no application identifier
provided, can't use provisioning profiles [pid=57853]
Feb 19 13:24:24 localhost kernel[0]: IGAccelDevice: IOUserClient
outputCount count mismatch
Feb 19 13:24:24 localhost Microsoft Excel[57852]:
NSAllowAppKitWeakReferences=YES
Feb 19 13:24:43 localhost taskgated[151]: no application identifier
provided, can't use provisioning profiles [pid=57861]

though I've copied all libs to my local folder changing all dependencies
via install_name_tool. Furthermore I can't get table list in
LibreOffice/OpenOffice via psql and mysql drivers built for using iODBC -
but I don't know if the problem is on LO/OO side or not.

Best Regards,
Dmitrii

Best Regards
Dmitry Pogorelov

2016-02-16 18:31 GMT+01:00 Steve Palm <n9...@n9...>:

> As a follow-up to this, some more information on the problems.
>
> Some were self-inflicted, as in using a bad SQL statement and
> misinterpreting the errors returned.
>
> I also just updated to the latest 5.3.4 MySQL connector, I was using
> 5.3.2. This was to be sure this was not the problem.
>
> Since I cannot get the OpenLink ODBC Administrator program to work (the
> Configure button does nothing except put an entry in the console log):
>
> 2/16/16 10:27:18.451 AM iODBC Administrator[18292]: iODBC
> Administrator(18292,0xa3b1e000) malloc: *** error for object 0x90acc9c7:
> pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
>
> So I tried using this ODBC GUI manager:
>
> http://www.odbcmanager.net
>
> It seemed to work OK, and manually examining the odbc.ini/odbcinst.ini
> files looked OK, yet when trying "iodbctest" I was still getting a variety
> of errors... Either that it could not prompt for additional information (I
> know the MySQL connector for Mac does not have a GUI component), or that it
> could not process the connect string.
>
> I also found (did not know previously) that I could query the odbc.ini
> file from the myodbc_installer binary to see what values it could extract.
> This revealed that, for some reason, it could not read the PWD value even
> though it was in the file.
>
> After reworking odbc.ini by hand, though, I finally got it to the point
> where it would connect, so I could do:
>
> iodbctest "DSN=test-5a"
>
> ...and it would connect and work. So, for whatever reason or whatever else
> was wrong before, at least this should prove that the basics are in place.
>
> Excel 2011, from VBA, continues to work, and in fact I could now remove
> some of the DSN parameters I was having to add before to the connect string
> as it is able to pull them from the odbc.ini.  So something in the
> formatting of that file was not 100% proper it would seem.
>
> Data -> Get External Data -> New Database Query...
>
> This opens the "iODBC Data Source Chooser" dialog, and I can pick the same
> DSN I use in VBA, and I get the same strange error I was getting before:
>
> [MySQL][ODBC 5.3(a) Driver]Access denied for user {garbage chars}@'host.ip.addr.here'
> (using password: YES)
>
> In the console log I also see these errors:
>
> 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft
> Query(18930,0xa3b1e000) malloc: *** error for object 0xb347a2a: pointer
> being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft
> Query(18930,0xa3b1e000) malloc: *** error for object 0x302aa00: pointer
> being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
>
>
> Excel 2016, when doing the same thing, crashes:
>
> Thread 0 crashed:
>
> #  1   0x530d7b9 in  (merp + 0x000037b9)        0x0
> #  2  0x938d579b in __sigtramp + 0x0000002B (libsystem_platform.dylib +
> 0x0000279b)        0x0
> #  3  0xffffffff in  ( + 0x00000000) 0xbff3cb18
> #  4  0x97825c34 in _abort + 0x0000009C (libsystem_c.dylib + 0x0005ec34)
> 0xbff3cee8
> #  5  0x90ace292 in _free + 0x000001B1 (libsystem_malloc.dylib +
> 0x00004292) 0xbff3cf18
> #  6  0x2bdc8cac in __iodbcdm_drvconn_dialbox + 0x0000027C (iODBCdrvproxy
> + 0x00001cac) 0xbff3cf58
> #  7  0x2fb42f8d in _iodbcdm_drvconn_dialboxw + 0x00001ECD (iODBCadm +
> 0x00002f8d) 0xbff3cfc8
> #  8  0x2fb4106c in _iodbcdm_drvconn_dialbox + 0x0000007C (iODBCadm +
> 0x0000106c) 0xbff4a8a8
> #  9  0x2fb0ec44 in _SQLDriverConnect_Internal + 0x00000BF4 (iODBC +
> 0x00011c44) 0xbff4a8d8
> # 10  0x2fb102c2 in _SQLDriverConnect + 0x00000152 (iODBC + 0x000132c2)
> 0xbff52198
> # 11    0x5807ad in  (Microsoft Excel + 0x004d47ad) 0xbff521e8
>
> But something new I had not seen before in the console log, four times:
> 2/16/16 10:57:59.115 AM sandboxd[266]: ([18699]) Microsoft Excel(18699)
> deny file-read-data /usr/local/lib/libmyodbc5a.so
>
> I tried to research this, and the field is not quarantined (has no
> extended attributes), and has no special ACL on it.
>
> However, I moved the library files out of /usr/local/lib and put them into
> /Librarry/ODBC/ODBCDataSources, and I updated the odbc.ini and odbcinst.ini
> files.  Now Excel 2016 no longer gives the sandbox errors, but I get this
> when I try to pick a data source:
>
> 2/16/16 11:21:30.670 AM Microsoft Excel[18910]: Microsoft
> Excel(18910,0xa3b1e000) malloc: *** error for object 0x2b47aa2a: pointer
> being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 2/16/16 11:21:30.699 AM taskgated[185]: no application identifier
> provided, can't use provisioning profiles [pid=18921]
> 2/16/16 11:21:30.787 AM Microsoft Error Reporting[18921]:
> ApplePersistence=YES
> 2/16/16 11:21:31.000 AM kernel[0]: warning: Microsoft Error (18921)
> performed out-of-band resume on pid 18910
>
>
> Seems similar to the error Excel 2011 is getting, and that the iODBC
> Administrator is getting, but maybe not.  But it seems to happen when these
> apps try to work with the GUI iODBC Data Chooser.
>
>
> Also, trying to use the "iODBC Demo (Ansi)" app to connect gives the same
> error as Excel 2011... The dialog box stating access is denied with some
> garbage characters in place of the username, also throwing these errors in
> console:
>
> 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo
> Ansi(18950,0xa3b1e000) malloc: *** error for object 0xae78a2a: pointer
> being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo
> Ansi(18950,0xa3b1e000) malloc: *** error for object 0x4065c00: pointer
> being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
>
> I had another app on my system, "iQueryODBC", and if I put in the
> DSN=test-5a in the connection box, it will work. However, if I use the
> "select" button to pick a datasource, then I get the same behavior with the
> garbage characters in place of the username and putting the same type of
> errors in the console:
>
> 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000)
> malloc: *** error for object 0xfcfaa2a: pointer being freed was not
> allocated
> *** set a breakpoint in malloc_error_break to debug
> 2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000)
> malloc: *** error for object 0x2086e00: pointer being freed was not
> allocated
> *** set a breakpoint in malloc_error_break to debug
>
> Not sure where to go further with this.
>
> I hope this is helpful in tracking this down.
>
>  -Steve
>
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Iodbc-macosx mailing list
> Iod...@li...
> https://lists.sourceforge.net/lists/listinfo/iodbc-macosx
>

Re: [Iodbc-macosx] EL Capitan problems?

[Steve P. <n9...@n9...>]

As a follow-up to this, some more information on the problems.

Some were self-inflicted, as in using a bad SQL statement and misinterpreting the errors returned.

I also just updated to the latest 5.3.4 MySQL connector, I was using 5.3.2. This was to be sure this was not the problem.

Since I cannot get the OpenLink ODBC Administrator program to work (the Configure button does nothing except put an entry in the console log):

2/16/16 10:27:18.451 AM iODBC Administrator[18292]: iODBC Administrator(18292,0xa3b1e000) malloc: *** error for object 0x90acc9c7: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug

So I tried using this ODBC GUI manager:

http://www.odbcmanager.net

It seemed to work OK, and manually examining the odbc.ini/odbcinst.ini files looked OK, yet when trying "iodbctest" I was still getting a variety of errors... Either that it could not prompt for additional information (I know the MySQL connector for Mac does not have a GUI component), or that it could not process the connect string.

I also found (did not know previously) that I could query the odbc.ini file from the myodbc_installer binary to see what values it could extract. This revealed that, for some reason, it could not read the PWD value even though it was in the file.

After reworking odbc.ini by hand, though, I finally got it to the point where it would connect, so I could do:

iodbctest "DSN=test-5a"

...and it would connect and work. So, for whatever reason or whatever else was wrong before, at least this should prove that the basics are in place.

Excel 2011, from VBA, continues to work, and in fact I could now remove some of the DSN parameters I was having to add before to the connect string as it is able to pull them from the odbc.ini.  So something in the formatting of that file was not 100% proper it would seem.

Data -> Get External Data -> New Database Query...

This opens the "iODBC Data Source Chooser" dialog, and I can pick the same DSN I use in VBA, and I get the same strange error I was getting before:

[MySQL][ODBC 5.3(a) Driver]Access denied for user {garbage chars}@'host.ip.addr.here' (using password: YES)

In the console log I also see these errors:

2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft Query(18930,0xa3b1e000) malloc: *** error for object 0xb347a2a: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug
2/16/16 11:23:23.036 AM Microsoft Query[18930]: Microsoft Query(18930,0xa3b1e000) malloc: *** error for object 0x302aa00: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug


Excel 2016, when doing the same thing, crashes:

Thread 0 crashed:

#  1   0x530d7b9 in  (merp + 0x000037b9)        0x0
#  2  0x938d579b in __sigtramp + 0x0000002B (libsystem_platform.dylib + 0x0000279b)        0x0
#  3  0xffffffff in  ( + 0x00000000) 0xbff3cb18
#  4  0x97825c34 in _abort + 0x0000009C (libsystem_c.dylib + 0x0005ec34) 0xbff3cee8
#  5  0x90ace292 in _free + 0x000001B1 (libsystem_malloc.dylib + 0x00004292) 0xbff3cf18
#  6  0x2bdc8cac in __iodbcdm_drvconn_dialbox + 0x0000027C (iODBCdrvproxy + 0x00001cac) 0xbff3cf58
#  7  0x2fb42f8d in _iodbcdm_drvconn_dialboxw + 0x00001ECD (iODBCadm + 0x00002f8d) 0xbff3cfc8
#  8  0x2fb4106c in _iodbcdm_drvconn_dialbox + 0x0000007C (iODBCadm + 0x0000106c) 0xbff4a8a8
#  9  0x2fb0ec44 in _SQLDriverConnect_Internal + 0x00000BF4 (iODBC + 0x00011c44) 0xbff4a8d8
# 10  0x2fb102c2 in _SQLDriverConnect + 0x00000152 (iODBC + 0x000132c2) 0xbff52198
# 11    0x5807ad in  (Microsoft Excel + 0x004d47ad) 0xbff521e8

But something new I had not seen before in the console log, four times:
2/16/16 10:57:59.115 AM sandboxd[266]: ([18699]) Microsoft Excel(18699) deny file-read-data /usr/local/lib/libmyodbc5a.so

I tried to research this, and the field is not quarantined (has no extended attributes), and has no special ACL on it.

However, I moved the library files out of /usr/local/lib and put them into /Librarry/ODBC/ODBCDataSources, and I updated the odbc.ini and odbcinst.ini files.  Now Excel 2016 no longer gives the sandbox errors, but I get this when I try to pick a data source:

2/16/16 11:21:30.670 AM Microsoft Excel[18910]: Microsoft Excel(18910,0xa3b1e000) malloc: *** error for object 0x2b47aa2a: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug
2/16/16 11:21:30.699 AM taskgated[185]: no application identifier provided, can't use provisioning profiles [pid=18921]
2/16/16 11:21:30.787 AM Microsoft Error Reporting[18921]: ApplePersistence=YES
2/16/16 11:21:31.000 AM kernel[0]: warning: Microsoft Error (18921) performed out-of-band resume on pid 18910


Seems similar to the error Excel 2011 is getting, and that the iODBC Administrator is getting, but maybe not.  But it seems to happen when these apps try to work with the GUI iODBC Data Chooser.


Also, trying to use the "iODBC Demo (Ansi)" app to connect gives the same error as Excel 2011... The dialog box stating access is denied with some garbage characters in place of the username, also throwing these errors in console:

2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo Ansi(18950,0xa3b1e000) malloc: *** error for object 0xae78a2a: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug
2/16/16 11:27:16.631 AM iODBC Demo Ansi[18950]: iODBC Demo Ansi(18950,0xa3b1e000) malloc: *** error for object 0x4065c00: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug

I had another app on my system, "iQueryODBC", and if I put in the DSN=test-5a in the connection box, it will work. However, if I use the "select" button to pick a datasource, then I get the same behavior with the garbage characters in place of the username and putting the same type of errors in the console:

2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000) malloc: *** error for object 0xfcfaa2a: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug
2/16/16 11:29:51.955 AM iQueryODBC[18959]: iQueryODBC(18959,0xa3b1e000) malloc: *** error for object 0x2086e00: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug

Not sure where to go further with this.

I hope this is helpful in tracking this down.

 -Steve

Re: [Iodbc-macosx] EL Capitan problems?

[Steve P. <n9...@n9...>]

One follow-up, and a big mea culpa and apology from me... The primary reason the second worksheet did not work was due to a stupid SQL statement error. It was strange, though, because the error was just a general ODBC error which was similar to what I was seeing when I tried to run a similar Macro in Excel 2016 even with valid SQL statement.

However, even though, now, I can use ODBC via VBA in an Excel 2011 spreadsheet, new or old, the GUI still does not work to get external data from a database and pull up Microsoft Query. This is why I thought it was not working in the new spreadsheet at all.

And, on Office 2016, Has anyone gotten this to work at all?

When I was trying to nail this down, I did finally break down and install the Actual drivers, a thing I have resisted for years {(just because) smile}, they do work seamlessly with Excel 2011 and 2016 for me.

I will send via direct email the information requested.

 -Steve

Re: [Iodbc-macosx] EL Capitan problems?

[Patrick v. K. <io...@op...>]

Hi Steve,

> Things had been going pretty well, I had even built/tested an iODBC-SQLite Mac version of his library/driver for the developer.
> 
> However, I was doing work in Excel 2011 yesterday, an older Workbook, and things were working fine.  But if I opened it in Excel 2016 it would crash when trying to open the ODBC connection.  Strangely enough, I can't create a new ODBC connection in Excel 2011 in a new workbook, and my other ODBC GUI apps give strange errors.
> 
> I tried to reinstall the latest versions of the iODBC-SDK and other parts I could think that would be relevant, but things are basically broken now and I am not sure what happened.  Even doing a test attempt from the iODBC Administrator.app fails, showing garbled characters for the username in the error dialog.
> 
> [MySQL][ODBC 5.3(a) Driver]Access denied for user 'Æ„'@'ip.addr.was.here' (using password: YES) [HY000]
> 
> Although using the SQLite-ODBC driver does work with the "iODBC Demo" app, but it requires no credentials/etc. The above failure is using MySQL.  But this used to all work. :(
> 
> The Configure button in the iODBC Administrator.app does nothing, but logs this in the Console:
> 
> 2/12/16 11:00:48.741 AM iODBC Administrator[1057]: iODBC Administrator(1057,0xa3b1e000) malloc: *** error for object 0xdee0a2a: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 2/12/16 11:00:48.741 AM iODBC Administrator[1057]: iODBC Administrator(1057,0xa3b1e000) malloc: *** error for object 0x30af200: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 2/12/16 11:01:27.489 AM iODBC Administrator[1057]: iODBC Administrator(1057,0xa3b1e000) malloc: *** error for object 0x90ace58d: pointer being freed was not allocated
> *** set a breakpoint in malloc_error_break to debug
> 
> Any thoughts on what may be going on?  It is strange that the old Excel spreadsheet is still working, but nothing that has to pass through the GUI "iODBC Data Source Administrator" seems to work at all, like the "iODBC Demo" apps, so what I thought was simply an Excel 2016 problem appears to be more widespread.
> 
> iODBC Core,          v3.52.10, org.iodbc.core, Tue Mar 10 07:37:34 2015
> iODBC Configuration, v3.52.10, org.iodbc.inst, Tue Mar 10 07:37:34 2015
> iODBC Administrator, v3.52.10, org.iodbc.adm,  Tue Mar 10 07:37:34 2015
> 
> OS X 10.11.4 (15E39d)
> 
> If it helps, part of the crash log from Excel 2016 that seems relevant is here:
> 
> Thread 0 crashed:
> 
> #  1   0x52957b9 in  (merp + 0x000037b9)        0x0
> #  2  0x938d579b in __sigtramp + 0x0000002B (libsystem_platform.dylib + 0x0000279b)        0x0
> #  3  0xffffffff in  ( + 0x00000000) 0xbffc7b18
> #  4  0x97825c34 in _abort + 0x0000009C (libsystem_c.dylib + 0x0005ec34) 0xbffc7ee8
> #  5  0x90ace292 in _free + 0x000001B1 (libsystem_malloc.dylib + 0x00004292) 0xbffc7f18
> #  6  0x2c339cac in __iodbcdm_drvconn_dialbox + 0x0000027C (iODBCdrvproxy + 0x00001cac) 0xbffc7f58
> #  7  0x2f2cdf8d in _iodbcdm_drvconn_dialboxw + 0x00001ECD (iODBCadm + 0x00002f8d) 0xbffc7fc8
> #  8  0x2f2cc06c in _iodbcdm_drvconn_dialbox + 0x0000007C (iODBCadm + 0x0000106c) 0xbffd58a8
> #  9  0x2f299c44 in _SQLDriverConnect_Internal + 0x00000BF4 (iODBC + 0x00011c44) 0xbffd58d8
> # 10  0x2f29b2c2 in _SQLDriverConnect + 0x00000152 (iODBC + 0x000132c2) 0xbffdd198
> # 11    0x4f57ad in  (Microsoft Excel + 0x004d47ad) 0xbffdd1e8
> 
> 
> iodbctest still can talk to the SQLite driver, and even though the credentials are in the odbc configuration, I have to provide them on the ODBC connection string prompt to iodbctest to connect to my MySQL database. (DSN is entered as:   den-name;uid=username;pwd=password;server=servername) But maybe this was always this way, it has been a long time since I have had to test it.
> 
> Any thoughts are more than welcome. :)


I will try to see if we can replicate your issue in-house to see what is going wrong.

Can you email me (mailto:io...@op...) your odbc.ini and odbcinst.ini (obviously with Passwords etc removed) so i can see if there is perhaps something wrong with the registration of the driver or the interaction with the setup dialog code.


Patrick
---
Patrick van Kleef
Program Manager
OpenLink Software

http://www.openlinksw.com/
http://twitter.com/openlink/

[Iodbc-macosx] EL Capitan problems?

[Steve P. <n9...@n9...>]

Things had been going pretty well, I had even built/tested an iODBC-SQLite Mac version of his library/driver for the developer.

However, I was doing work in Excel 2011 yesterday, an older Workbook, and things were working fine.  But if I opened it in Excel 2016 it would crash when trying to open the ODBC connection.  Strangely enough, I can't create a new ODBC connection in Excel 2011 in a new workbook, and my other ODBC GUI apps give strange errors.

I tried to reinstall the latest versions of the iODBC-SDK and other parts I could think that would be relevant, but things are basically broken now and I am not sure what happened.  Even doing a test attempt from the iODBC Administrator.app fails, showing garbled characters for the username in the error dialog.

[MySQL][ODBC 5.3(a) Driver]Access denied for user 'Æ„'@'ip.addr.was.here' (using password: YES) [HY000]

Although using the SQLite-ODBC driver does work with the "iODBC Demo" app, but it requires no credentials/etc. The above failure is using MySQL.  But this used to all work. :(

The Configure button in the iODBC Administrator.app does nothing, but logs this in the Console:

2/12/16 11:00:48.741 AM iODBC Administrator[1057]: iODBC Administrator(1057,0xa3b1e000) malloc: *** error for object 0xdee0a2a: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug
2/12/16 11:00:48.741 AM iODBC Administrator[1057]: iODBC Administrator(1057,0xa3b1e000) malloc: *** error for object 0x30af200: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug
2/12/16 11:01:27.489 AM iODBC Administrator[1057]: iODBC Administrator(1057,0xa3b1e000) malloc: *** error for object 0x90ace58d: pointer being freed was not allocated
*** set a breakpoint in malloc_error_break to debug

Any thoughts on what may be going on?  It is strange that the old Excel spreadsheet is still working, but nothing that has to pass through the GUI "iODBC Data Source Administrator" seems to work at all, like the "iODBC Demo" apps, so what I thought was simply an Excel 2016 problem appears to be more widespread.

iODBC Core,          v3.52.10, org.iodbc.core, Tue Mar 10 07:37:34 2015
iODBC Configuration, v3.52.10, org.iodbc.inst, Tue Mar 10 07:37:34 2015
iODBC Administrator, v3.52.10, org.iodbc.adm,  Tue Mar 10 07:37:34 2015

OS X 10.11.4 (15E39d)

If it helps, part of the crash log from Excel 2016 that seems relevant is here:

Thread 0 crashed:

#  1   0x52957b9 in  (merp + 0x000037b9)        0x0
#  2  0x938d579b in __sigtramp + 0x0000002B (libsystem_platform.dylib + 0x0000279b)        0x0
#  3  0xffffffff in  ( + 0x00000000) 0xbffc7b18
#  4  0x97825c34 in _abort + 0x0000009C (libsystem_c.dylib + 0x0005ec34) 0xbffc7ee8
#  5  0x90ace292 in _free + 0x000001B1 (libsystem_malloc.dylib + 0x00004292) 0xbffc7f18
#  6  0x2c339cac in __iodbcdm_drvconn_dialbox + 0x0000027C (iODBCdrvproxy + 0x00001cac) 0xbffc7f58
#  7  0x2f2cdf8d in _iodbcdm_drvconn_dialboxw + 0x00001ECD (iODBCadm + 0x00002f8d) 0xbffc7fc8
#  8  0x2f2cc06c in _iodbcdm_drvconn_dialbox + 0x0000007C (iODBCadm + 0x0000106c) 0xbffd58a8
#  9  0x2f299c44 in _SQLDriverConnect_Internal + 0x00000BF4 (iODBC + 0x00011c44) 0xbffd58d8
# 10  0x2f29b2c2 in _SQLDriverConnect + 0x00000152 (iODBC + 0x000132c2) 0xbffdd198
# 11    0x4f57ad in  (Microsoft Excel + 0x004d47ad) 0xbffdd1e8


iodbctest still can talk to the SQLite driver, and even though the credentials are in the odbc configuration, I have to provide them on the ODBC connection string prompt to iodbctest to connect to my MySQL database. (DSN is entered as:   den-name;uid=username;pwd=password;server=servername) But maybe this was always this way, it has been a long time since I have had to test it.

Any thoughts are more than welcome. :)

 -Steve

Re: [Iodbc-macosx] problem with MySQL - ODBC connection Filemaker 13

[OpenLink S. T. S. <tec...@op...>]

On Mar 26, 2015, at 03:57 PM, Gerard Versteegh <gjm...@gm...> wrote:

> I installed iODBC on my OS X Mavericks and tested the connection using the MySQL ODBC 5.3 ANSI driver version 5.03.0004 and this works fine. The problem is that I also need to use characters from other european characters. So I tried the unicode driver. This hangs up filemaker. Anybody with suggestions to solve this?

I think this is not an iODBC issue, per se...

That said, you could update the iODBC components to the latest
for Mavericks --

   http://bit.ly/194L4JF

You could also try the (commercial) OpenLink ODBC Drivers for
MySQL, which should handle any characters the Mac will --

   http://uda.openlinksw.com/odbc-mysql/

Most users find the Lite Edition best starting point, but you
could try any of those listed.  

Downloading any of these will get you a two-week trial license, 
which can be converted to non-expiring paid license at any time 
by swapping the license file -- all software and configuration 
remains in place.

Good luck!

Ted
OpenLink Support




--
Technical Support          //   mailto:tec...@op...
OpenLink Software, Inc.    //                http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers