StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POiODBC error trying to connect to MS SQL Server in PHP with unixODBC/FreeTDS
text
Body
copied!<p>I am trying to connect to a remote MS SQL Server db from PHP on Mac (eventually on an Ubuntu server( with FreeTDS and unixODBC, but even though I seem to have everything set up properly, I'm getting iODBC errors, and I'm not sure how to get around them.</p> <p>I'm using MacPorts, so my config is:</p> <p>/opt/local/etc/freetds.conf::</p> <pre><code>[bti_db] host = 123.45.67.89 (IP address changed to protect the innocent) port = 14333 tds version = 8.0 </code></pre> <p>/opt/local/etc/odbcinst.ini:</p> <pre><code>[FreeTDS] Description = TDS Driver (Sybase/MSSQL) Driver = /opt/local/lib/libtdsodbc.so Setup = /opt/local/lib/libtdsS.so FileUsage = 1 </code></pre> <p>/opt/local/etc/odbc.ini:</p> <pre><code>[bti_dsn] Driver = FreeTDS Description = My Database Trace = no Servername = bti_db Database = btidata </code></pre> <p>However, whenever I try to connect with odbc_connect() using the 'bti_dsn'</p> <pre><code>$conn = odbc_connect('bti_dsn;, $user, $pw); </code></pre> <p>I get this error:</p> <p>Warning: odbc_connect() [function.odbc-connect]: SQL error: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, SQL state IM002 in SQLConnect</p> <p>In the ODBC section my phpinfo(), I see ODBC Library defined as iodbc, and PHP is compiled with '--with-iodbc=/usr', so I'm guessing that config is my problem. How can I get around this so that it uses unixODBC/FreeTDS I have set up?</p> <p>Thanks.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload