I have a Linux webserver and a MS Windows 2000 server running MS SQL Server 2000 database server. I read the article on PHP Builder that specifically addressed this connectivity issue and how to setup a linux server to connect to a MS SQL server. Currently I have unixODBC installed and have tried FreeTDS, however, I can't use FreeTDS since I need ODBC connectivity for reasons I won't go into (FreeTDS's ODBC support is quite immature currently). The author of this PHP Builder article claims that he was able to get the Inline TDS driver working properly using unixODBC as the driver manager (http://www.phpbuilder.com/columns/alberto20000919.php3?page=5), however, I have yet to be able to do this. I believe I have my odbc.ini file setup correctly:
[freeodbc]
Driver = /usr/local/lib/odbc-i02.so
Server = ip_of_server
Port = 1433
User =
Pass =
Database = testdb
Majorver = 4.2
Minorver = 0
Packetsize = 4096
ConnectTimeout = 30
QueryTimeout = 60
LongQueryTimeout = 20
When I run isql (sql application that came with unixODBC) to test out my connection, I get this error:
$ isql freeodbc
Bus error
I have played with this a bit (trying different isql options as well as just about every variation of odbc.ini configuration that I could think of), but no luck yet. I was hoping that the author of this article (or anyone, please) could describe what they did to set this up properly. Is it possible that I have a bad .so file or something?
If anyone has set this up with the Inline TDS driver please just post something here. Also, if anyone has any other solution for ODBC access between linux and MS SQL server, I'm open to suggestions (although non-commercial solutions are much more welcome 🙂). TIA for any help...
