2009/12/15 Philip Thompson <philthath...@gmail.com>:
> On Dec 14, 2009, at 8:47 PM, James McLean wrote:
>> On Tue, Dec 15, 2009 at 10:03 AM, Philip Thompson
>> <philthath...@gmail.com> wrote:
>>> My head hurts from hitting it on my desk all day, so I thought I'd turn to 
>>> a fresher set of eyes. The issue I'm having is getting PHP to connect ODBC. 
>>> I can get it to work using isql from the command line. Can you verify my 
>>> settings....:
>> [snipped]
>>> I've tried the above DSNs and many other versions of it ad nauseum. The 
>>> specific error I'm getting is... "[unixODBC][Driver Manager]Data source 
>>> name not found, and no default driver specified." I really have searched 
>>> high and low for a solution, but to no avail. Any thoughts?
>> Why not just use the built in MySQL libraries or PDO?
> Oh, that would be "my" preference. However, the database that I really need 
> to connect to is an MSSQL one and the allowed connection type is ODBC. I was 
> just testing first with a MySQL connection to get it working (I don't have 
> the MSSQL credentials yet). Turned out I was VERY close with my solution, 
> which a coworker figured out this morning. The [ODBC Data Sources] entry for 
> MySQL needed to specified correctly in /etc/odbc.ini.
> [ODBC Data Sources]
> [MySQL]
> Description...
> Driver...
> I could have sworn I tried that, but who knows....
> Thank you!
> ~Philip
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

You can use a DNS-string too ...

odbc_pconnect("Driver={SQL Server Native Client
$s_User, $s_Pswd, SQL_CUR_USE_DRIVER);

Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to