mssql select query hang

[cpusl]

Hi guys,

 

I am currently doing a project that connects to a mssql server and we finally got this sucker connected using a dsn and odbc_connect. I have the ability to call odbc_data_source and all other functions that query the server but I am having an issue with odbc_exec hanging. When I construct the query wrong, I get back a result saying that the query is wrong eg. table doesn't exist, error at from line 2, etc... However, any query that I do hangs. Even extremely simple ones get a timeout. I simplified it into a simple code base to show you an example:

 

 

$username = "blah";

$password = "blah2";

 

$connection = odbc_connect('myDSN', $username, $password);

 

$results = odbc_exec($connection,'Select TOP 1 firstnamemi from crname;');

 

odbc_close($connection);

 

running this code gets me the hourglass and after about 30 secs or so, a timeout message in the browser.

 

Any ideas?