I'm bootstrapping myself through the entire ODBC stack it seems, but I do feel I am making some progress - I hope. I now have copies of MySQL, Firebird and SQLite db's and ODBC drivers on my machine and I'm trying to get all the way through to the final stage of a successful connection. Now I'm running into a new error.Setup: MacAir, 10.7.4, latest iODBC (I guess, comes installed, right?), latest ODBC Manager. DBs installed and can be accessed from the command line tools for each of the systems.For easy testing, I'm using Excel's MS Query UI. Selecting any of my DSN's in MS Query and pressing the Test button results in this error dialog:iODBCDriver ManagerSpecified driver could not be loadedthen when that is dismissed another appears:iODBCDriver Managerdlopen(/usr/local/lib/libmyodbc5.so, 6): no suitable image found.
![]()
The sources for the iODBC Driver Manager are available as a tarball on SourceForge or by checkout from Github; you can also read the ChangeLog. Mac OS X This package contains iODBC as a Framework plus the GUI iODBC Administrator.app, and includes full 64-bit support at all levels, as required by Microsoft Office 2016 (v15.25+) and various other newer tools. IODBC Driver Manager, Administrator, SDK for Mac. Carbon applications linked with iODBC CFM Bridge can be run in Mac OS X boot environment, Mac OS 9 boot environment, or Classic environment of.
![]()
Did find: /usr/local/lib/lobmyodbc5.so: mach-o, but wrong architectureOk, so perhaps MS Query is 32 and the driver is 64, or vice versa. I don't.really.
know how to check the MS stuff, but I do know how to check the libs:Maurys-MacBook-Air-2:lib maury$ lipo -info libmyodbc5.soNon-fat file: libmyodbc5.so is architecture: x8664Ok, so maybe Query is 32 and Connect/ODBC is 64? Let's lipo another driver.Maurys-MacBook-Air-2:lib maury$ lipo -info libfbclient.dylibArchitectures in the fat file: libfbclient.dylib are: i386 x8664Ok, this one should work, right? Nope, same error.
Ok, one last try.Maurys-MacBook-Air-2:lib maury$ lipo -i /usr/lib/libsqlite3odbc-0.83.dylibNon-fat file: /usr/lib/libsqlite3odbc-0.83.dylib is architecture: i386Ok this is pure 32-bit, let's see.HY000connect failedOh, OK, that's different, but still no luck.If anyone has a tool that's pure 32 and/or 64 bit that goes through the iODBC driver stack, I'd like to give it a try. In the meantime, am I even reading the error message correct? It doesn't.really. say. On 04:48 PM, Maury Markowitz wrote: to your odbc.ini / $ODBCINI file to show how the application's behaving. Is there a similar setting on the Mac side?
This sounds.very. interesting.Yes - you should be able to enable tracing using the iODBCAdministrator, or you can find the file variously in:$ODBCINI - if you've exported an environment variable to find it/Library/ODBC/odbc.ini/Library/ODBC/odbc.ini/.odbc.iniHTH,Tim-Tim HaynesProduct Development ConsultantOpenLink Software. On 2012-04-24, at 5:48 AM, Tim Haynes wrote: more obvious things is: if you're using a hostname to access the remote end, does DNS respond rapidly? What if you use its IP# instead?I am using the IP, sorry:-) Actually that was by accident, it was on the far side of the VPN so I simply pinged it and used that IP.
If it's quick enough with the db running locally, then it's unlikely toHerein lies the rub - the machine in question is locked down tight, and I don't have the admin password. As a result, i can't install.anything. so I haven't been able to set up the ODBC connection. The driver is not visible in the User DSN tab so I'm sunk for now.
I'm working on this. 850 rows of 20 columns is not huge, unless you've got blobs in there.char, int and float! As a rule, RDMBSs run quickest when you let the engine do most of the computation and just pull back the rows required.For sure, and in this case even the largest table is perhaps 100 kB of text being sent back.But it really seems to be that 'setup delay'. I can see the outbound channel lighting up, but.very. little data going through it.
to your odbc.ini / $ODBCINI file to show how the application's behaving.Is there a similar setting on the Mac side? This sounds.very. interesting. On 04:43 PM, Maury Markowitz wrote: I am a data integration guy and silo-breaker. In the past I used SQL Server/ODBC, MS Access, a fast LAN and running on a Windows box. Now I am attempting to learn all of this over again using Firebird/iODBC, Excel, a SSL/VPN internet connection, and a Mac.
Apparently, I'm a glutton for punishment. I am running simple queries against a relatively small database - the db is perhaps 400 MB, and the queries return a few hundred rows. On the PC/SQLS/LAN this would be instantaneous, but the Mac/FB/WAN, performance is fairly slow. I'm trying to understand the reasons for this.
I have tried the same basic query using two front-ends, iODBC Demo using OpenLink's driver, and RazorSQL using JDBC and Firebird's native driver. In both cases the performance is about equal, which.may. suggest that the local machine and/or drivers are not an issue. Likewise, I have tried this both from work and home, on two very fast machines and connections, and again the performance seems about the same. I have noticed something that I believe is the root cause, but I don't know what it is.
I'll pick the most obvious case: 'select. from part'. The table has about 850 rows and about 20 columns. The last time I ran it (just now) it took about 75 seconds end-to-end.
During this time the outbound channel was slowly ticking up at about 1 kbps. Then.poof., back comes the table. Razor's diagnostics reports that the query took 1.5 seconds! Now it's possible this is an indexing or similar DB problem. However, the same basic problem effects all queries to one degree or another. The total end-to-end time is seconds, the query time is about 1 second, and the difference is this period where the local machine dribbles out data to the server. So, it.appears.
to suggest there is some sort of handshaking going on before the query hits the server. What this is, and why this would be different times for different queries, is a mystery to me. Is anyone familiar with this?There's a lot of things that could potentially happen in 75s. One of themore obvious things is: if you're using a hostname to access the remoteend, does DNS respond rapidly? What if you use its IP# instead?If it's quick enough with the db running locally, then it's unlikely tobe the db at fault - optimising indexes, while certainly useful, may bepremature with negligible gain in the face of those 75 seconds.850 rows of 20 columns is not huge, unless you've got blobs in there.As a rule, RDMBSs run quickest when you let the engine do most of thecomputation and just pull back the rows required.
For example, if you'vegot a query with two tables joined by a field, from which you only wantsome of the results, the worst thing an application could do is select.from each table, compute the join and filter itself - pulling all thedata across the network with no scope for optimisation. Attachments:Hi, Maury -On Apr 20, 2012, at 02:13 PM, Maury Markowitz wrote: I've varied between non-user and guru with ODBC on the PC side of things, but I've finally managed to go all-Mac and now I'm trying to pick up again over here. I've got a particular database running under Firebird (which I'm new to) on a 'cloud server' we access using a VPN.
I downloaded iODBC and a demo version of the OpenLink driver, and I'm starting to play about a bit and get a feeling for the system. So I have a few questions: iODBC Demo would be handy, if I had a real SQL editor - it can't even handle whitespace. Can someone recommend an OSX native simple query interface I might try?
I tried SyBrowser X, but it has some problems so it's not really usable for me. My only real need is a full editing window/pane, and it might be nice to have a DDL reader so I can lookup tables and columns. Beyond that my needs are limited!You may find our HTML5-based ODBC Explorer suits you. I am a data integration guy and silo-breaker. In the past I used SQL Server/ODBC, MS Access, a fast LAN and running on a Windows box. Now I am attempting to learn all of this over again using Firebird/iODBC, Excel, a SSL/VPN internet connection, and a Mac.Apparently, I'm a glutton for punishment.I am running simple queries against a relatively small database - the db is perhaps 400 MB, and the queries return a few hundred rows.
On the PC/SQLS/LAN this would be instantaneous, but the Mac/FB/WAN, performance is fairly slow. I'm trying to understand the reasons for this.I have tried the same basic query using two front-ends, iODBC Demo using OpenLink's driver, and RazorSQL using JDBC and Firebird's native driver.
In both cases the performance is about equal, which.may. suggest that the local machine and/or drivers are not an issue. Likewise, I have tried this both from work and home, on two very fast machines and connections, and again the performance seems about the same.I have noticed something that I believe is the root cause, but I don't know what it is.I'll pick the most obvious case: 'select. from part'. The table has about 850 rows and about 20 columns. The last time I ran it (just now) it took about 75 seconds end-to-end. During this time the outbound channel was slowly ticking up at about 1 kbps.
Then.poof., back comes the table. Razor's diagnostics reports that the query took 1.5 seconds!Now it's possible this is an indexing or similar DB problem. However, the same basic problem effects all queries to one degree or another. The total end-to-end time is seconds, the query time is about 1 second, and the difference is this period where the local machine dribbles out data to the server.So, it.appears. to suggest there is some sort of handshaking going on before the query hits the server.
What this is, and why this would be different times for different queries, is a mystery to me.Is anyone familiar with this?Thanks for any advice! On 07:13 PM, Maury Markowitz wrote: I've varied between non-user and guru with ODBC on the PC side of things, but I've finally managed to go all-Mac and now I'm trying to pick up again over here. I've got a particular database running under Firebird (which I'm new to) on a 'cloud server' we access using a VPN. I downloaded iODBC and a demo version of the OpenLink driver, and I'm starting to play about a bit and get a feeling for the system. So I have a few questions: iODBC Demo would be handy, if I had a real SQL editor - it can't even handle whitespace.
Can someone recommend an OSX native simple query interface I might try? I tried SyBrowser X, but it has some problems so it's not really usable for me. My only real need is a full editing window/pane, and it might be nice to have a DDL reader so I can lookup tables and columns.
Beyond that my needs are limited!How about OpenOffice? That will allow you to link to existing databases,via ODBC amongst other things. The next question is just business: what is the relationship, if any, between iODBC and OpenLink?OpenLink own, write and maintain iODBC as an open-source project.HTH,Tim-Tim HaynesProduct Development ConsultantOpenLink Software. I've varied between non-user and guru with ODBC on the PC side of things, but I've finally managed to go all-Mac and now I'm trying to pick up again over here.I've got a particular database running under Firebird (which I'm new to) on a 'cloud server' we access using a VPN.
I downloaded iODBC and a demo version of the OpenLink driver, and I'm starting to play about a bit and get a feeling for the system. So I have a few questions:iODBC Demo would be handy, if I had a real SQL editor - it can't even handle whitespace. Can someone recommend an OSX native simple query interface I might try? I tried SyBrowser X, but it has some problems so it's not really usable for me. My only real need is a full editing window/pane, and it might be nice to have a DDL reader so I can lookup tables and columns.
Beyond that my needs are limited!The next question is just business: what is the relationship, if any, between iODBC and OpenLink? Hi, Donato -On May 13, 2011, at 12:27 PM, Donato Azevedo wrote: Good'ay gentlemen, I have been trying, unsuccessfuly, to use the iodbctest application to test a connection to a firebird databse. Using the graphical tool (iODBC Demo) I am able to connect, and thus, I suppose the problem is from where the iodbctest is reading its config, and how do I point it to the same configuration the iODBC demo uses (the one configured using the iODBC administrator) I suppose iODBC was installed in a non standard location and I can't really find it. Not even where the installed openlink driver is installed. Thanks mates!If you start iODBC Test with the double-clickable script,/Applications/iODBC/iODBC Test.command, it should work justas /Applications/iODBC/iODBC Demo.app.Note that OpenLink Software produces iODBC as well as the driveryou're apparently working with.iODBC is bundled into Mac OS X by Apple, though they still shipa long-outdated version, and they only bundle dylibs.You can get the latest version, which will not replace the Apple-bundled dylibs by default, but will install both dylibs andFrameworks, here. Attachments:Good'ay gentlemen,I have been trying, unsuccessfuly, to use the iodbctest application to testa connection to a firebird databse. Using the graphical tool (iODBC Demo) Iam able to connect, and thus, I suppose the problem is from where theiodbctest is reading its config, and how do I point it to the sameconfiguration the iODBC demo uses (the one configured using the iODBCadministrator)I suppose iODBC was installed in a non standard location and I can't reallyfind it.
Not even where the installed openlink driver is installed.Thanks mates!-Donato Azevedo. Attachments:I had the same problem. It seems there is some incompatibility with the latest version of libidobc.2.dylib. You might want to install the bug-fix package iodbc-usr-sdk.zip and give that a try. If this does not work, then I think you will have to reinstall Snow Leopard.
I was lucky since Time Machine is backing up my disk and I recovered all the libiodbc. files that way. Works fine now, though, I've not tested odbc yet.Another way is to forget the internal web server and install MAMP.Stephen. Attachments:Hi,I installed the iODBC Manager on Mac OS X (10.6) and now I cannot launch theApache.
I get the following error log:31.1.2011 12.00.13 org.apache.httpd907 httpd: Syntax error on line115 of /private/etc/apache2/httpd.conf: Cannot load/usr/libexec/apache2/libphp5.so into server:dlopen(/usr/libexec/apache2/libphp5.so, 10): Symbol not found:GetPrivateProfileStringn Referenced from: /usr/lib/libiodbc.2.dylibnExpected in: flat namespacen31.1.2011 12.00.13 com.apple.launchd1 (org.apache.httpd907) Exitedwith exit code: 131.1.2011 12.00.13 com.apple.launchd1 (org.apache.httpd) Throttlingrespawn: Will start in 10 secondsCan anyone know how to fix this?BR,Ville. Hi, Steven -On Dec 2, 2010, at 06:07 PM, Steven Bade wrote: I installed the iodbc drivers on Mac OSX 10.6, and the test applications connect to the database fine. However when the internal web server starts i now get httpd: Syntax error on line 115 of /private/etc/apache2/httpd.conf: Cannot load /usr/libexec/apache2/libphp5.so into server: dlopen(/usr/libexec/apache2/libphp5.so, 10): Symbol not found: GetPrivateProfileStringn Referenced from: /usr/lib/libiodbc.2.dylibn Expected in: flat namespacen in syslog.
Anyone have any idea how to fix this, or what to change so that the iodbc functions don't get loaded?I'm not sure what you mean by 'the iodbc drivers.' IODBC is thedriver manager; ODBC drivers may be built with the iODBC SDK, butthis does not make them 'iODBC drivers'. Can you provide moreinformation about the drivers you are using?Please confirm that you have installed the update to iODBC 3.52.7for Mac OS X, available here.
I installed the iodbc drivers on Mac OSX 10.6, and the test applicationsconnect to the database fine. However when the internal web serverstarts i now gethttpd: Syntax error on line 115 of /private/etc/apache2/httpd.conf:Cannot load /usr/libexec/apache2/libphp5.so into server:dlopen(/usr/libexec/apache2/libphp5.so, 10): Symbol not found:GetPrivateProfileStringn Referenced from: /usr/lib/libiodbc.2.dylibnExpected in: flat namespacenin syslog. Anyone have any idea how to fix this, or what to change sothat the iodbc functions don't get loaded? Hi Tom,The reason the header file cannot be found is because, you should specify the top directory of iODBC in your configuration optins from where the required 'lib' and 'include' directories will then be located for use ie-with-iodbc=/usr/local/iODBCThe 'mach-o but wrong architecture' error you are getting trying to test your FreeTDS ODBC driver with the iODBC Administrator is probably because the iODBC Administrator is a 32bit Intel or ppc application and your FreeTDS library is probably 64bit Intel and hence the binary formats do not match. Attachments:Hugh -Again, I really appreciate your help.I did install iodbc using the dmg package from the iodbc downloads pageI am trying a different track.
Attachments:Hi Tom,You mention having installed a latest iODBC OSX patch from the Web site, is this the one from the iODBC Web site to take you up to version 3.52.7 ie?What is your current version of the iODBC Driver Manager in /usr/lib, which can be obtained by running the command:$ sudo strings /usr/lib/libiodbc.2.dylib grep 3.52Password:3.52.7$Best RegardsHugh WilliamsProfessional ServicesOpenLink SoftwareWeb:Support:Forums:Twitter:On 18 Aug 2010, at 20:21, Tom Hoen wrote: Hugh – Thank you for your response. It must be something in ruby-odbc then, as I am using that Gem. I will take a look at the Gem build routine to see if it can be changed to point to the appropriate library. Tom From: Hugh Williams mailto:hwilliams@. Sent: Wednesday, August 18, 2010 1:32 PM To: Tom Hoen Cc: iodbc-macosx@. Subject: Re: Iodbc-macosx lazy symbol binding failed: Symbol not found: InitiODBC error.
Any help would be greatly appreciated Hi Tom, I note the symbol not found error you report still references /usr/lib/libiodbc2.dylib, which is the location of the Apple bundle iODBC Driver Manager, alhtough you indicated having downloaded the latest iODBC from the web site, by which I presume you mean? Attachments:Hugh - Thank you for your response.It must be something in ruby-odbc then, as I am using that Gem. I will takea look at the Gem build routine to see if it can be changed to point to theappropriate library.TomFrom: Hugh Williams mailto:[email protected]: Wednesday, August 18, 2010 1:32 PMTo: Tom HoenCc: [email protected]: Re: Iodbc-macosx lazy symbol binding failed: Symbol not found:InitiODBC error. Any help would be greatly appreciatedHi Tom,I note the symbol not found error you report still references/usr/lib/libiodbc2.dylib, which is the location of the Apple bundle iODBCDriver Manager, alhtough you indicated having downloaded the latest iODBCfrom the web site, by which I presume you mean? Attachments:Hi Tom,I note the symbol not found error you report still references /usr/lib/libiodbc2.dylib, which is the location of the Apple bundle iODBC Driver Manager, alhtough you indicated having downloaded the latest iODBC from the web site, by which I presume you mean?
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |