Jump to content


Photo

ODBC DSN-less connection error


  • Please log in to reply
1 reply to this topic

#1 henry

henry
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 06 March 2006 - 10:20 PM

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:

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

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

#2 henry

henry
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 08 March 2006 - 07:14 PM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users