On 6/24/04 8:53 AM, "Diego Tiscornia" diegobt@hotmail.com wrote:
Hi ben, sorry I didn't answer before. Yes, you are right about the typo :/ thx Yes I think you got the FFi part working (for odbc, if you get that error) When you I got ODBCError, I debugged it and found out that the ODBCConnection object hadn't got an open connection, which meant it couldn't establish one, as my connection string was ok, (dsn, usr, pwd) it turned out the problem was with iodbc and/or odbc.ini. What does the debugger tell you?
By the way, I couldn't get the iodbc that shipped with mi mac to work, so I got bored and installed unixodbc from the fink distro, made that work and everything worked fine.
hope this helps!
Hi Diego,
Thanks for your reply. If I remember correctly, I did have something similar to what you say: the driver had allocated handles correctly but couldn't run SQLConnect. The connection string seemed to be correct.
I tried creating the connection using a plain C program, and it failed there too. The nearest I could tell, the FreeTDS library was having trouble dynamically loading the iodbc libraries that it needed.
Following a tip on another mailing list, I tried using the FreeTDS library as the ODBC library directly, rather than going through iodbc, as its interface is the same for at least many things. (That is to say, I made the symlink to the FreeTDS library file instead of to the iodbc one.)
This worked fine! (... at least for the few things I've tried.)
I don't think I need a driver manager right now, but if I do, I may try unixodbc - thanks for the tip.
I hope this helps anyone else trying to get this kind of thing working.
Thanks again for your installation notes and help!
Regards, Ben Schroeder