I'm trying to connect to a remotely hosted Microsoft SQL Server database. I'm running PHP 4.3.10 on a shared linux host without mssql support enabled, so I'm having to try using ODBC. The database permissions are all good since I can access it fine using MS Excel on my home computer.
However, no matter what I try I always run up against the following error:
Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect
I've tried using the PHP odbc commands directly, and installing ADODB-lib and using that, but with the same result.
I'm using the following connect string:
I see this question a lot on the web, but none of the solutions seem to work. I'm beginning to suspect that it's not actually possible with my set-up.
Can anyone tell me if this is just a brick-wall that I'm banging my head against, that will eventually fall-down (albeit with a very bruised head), or is it a solid cliff-face that cannot fall.
ODBC DSN-less connection error
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users