ODBC - windows 2000 issues - please help!!!

anotherocd

Maybe someone else has had this problem. I am running windows 2000 professional - I have setup SYSTEM DSNs in order to access an ODBC data source. The DSNs seem to respond to programs such as EXCEL, MS Query, etc... but when I try to run PHP code, I get no responce. Mainly, I have narrowed it down to this code ...

$conn = odbc_connect($resource,$user,$pass);
$ID = odbc_exec($conn, $string);

...here, I get a valid handle for $conn, but when I attempt to use it in odbc_exec(), I never get a valid $ID handle. Any input is helpful - thanks in advance.

Darrin

Tracer

What is your exact error message?

Most of the time with win2K and ODBC the problem is that the web server service user needs to have privileges added in order to connect to the network share where the oDBC database is located.

Try starting the apache service as an administrator, if your code then works, you will know it's a privelege problem on the user somewhere...

anotherocd

I'm note getting an errror message, I just don't get a valid value for my $ID variable using this code ...

$conn = odbc_connect($resource,$user,$pass);
$ID = odbc_exec($conn, $string);

I have error reprorting turned on so I should see errors if there was a syntax and/or symantic error. I am the admin on this particular machine, so everything should have privledges. Like I noted before, the DSNs seem to respond to other apps (i.e. Excel, MSQuery, etc.).

Does anyone know a definitive reason (other than the one I can find in the PHP manual) why odbc_exec() would not return a resource handle??? $conn is definitely a valid connection, so $string must the culperate, right? But wouldn't I get a warning or error if something was wrong with my query??? Any help thanks!

anotherocd

tsinka

Hi,

depending on the database you use you might need to specify a cursor type, e.g.

$conn = odbc_connect($resource,$user,$pass,
                                     SQL_CUR_USE_ODBC); 
$ID = odbc_exec($conn, $string);