ODBC DSN-less connection error

[henry]

Hi all,

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:

[i][b]Warning:[/b] odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect[/i]

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]"Driver={SQL Server};Server=hostname.com;Database=database_name;"[/i]

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.

cheers,

henry

[henry]

I guess nobody can help here then.

I'll let you all know what the problem was if I ever get it to work, but I'm running out of options.

thanks.