sorry ... one more thing ...

in my "Actual Results" section I forgot to remove the "or"'s ...

So of course the "or"'s are not part of the string which is returned by odbc_errormsg() ...

What does var_dump(odbc_error()) return after a valid query?

Output of var_dump(odbc_errormsg()) as follows:

string(146) "31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:"

string(122) "1:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:"

These are only two examples. I had to reproduce the error in a small script to generate these. That's why the variety is not that great like in our production environment where we currently use a dirty workaround.

Do not add comments to your own report, use this link:
http://bugs.php.net/bug.php?id=24244&edit=2

Actually I wanted to see the error id not the error message. So please tell me what is the output of:
var_dump(odbc_error())

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.

I thought I did have a problem running odbc_error() but it looks like it's been clean everytime but as you can see the errormsg seems to get random stuff.   I'll post to this bug if I see the problem again while useing odbc_error()


I've just ran into this problem myself.  it's with db2. the error is usually less frequent for me but sometimes it will happen many times in a row.

this is the code I used to get the random garbage.

$conn_id = odbc_connect("netmap","user","pass");
$err=odbc_errormsg($conn_id);
if($err) {
        var_dump(odbc_error());
        print ">".$err."<";
}


this is the output of an error.
>@\y????? 5Kbz????
>^o??????5Pl????? 0E[r?????/Nn??????+E`|????,@Uk?????!?^~?????? ";Up?



This also happens: I just added the var_dump(odbc_error())here: 

string(0) "" >My Company Ltd [SSL_SERVER_I_DN_CN] => zoop@lone.ath.cx [SSL_SERVER_I_DN_EMAILADDRESS] => zoop@lone.ath.cx [SSL_SERVER_M_SERIAL] => 05 [SSL_SERVER_V_START] => Oct 13 22:08:48 2004 GMT [SSL_SERVER_V_END] => Oct 13 22:08:48 2005 GMT [SSL_SERVER_M_VERSION] => 3 [GATEWAY_IN? 


this one is also odd it seems to be loading other php files and spitting them out here not sure how. this page wasn't being accessed when this error occured. this is an a line for another .php file on the system.

string(0) "" >r:cwa2.jar:. blueAuth ".escapeshellcmd($user)." ".escapeshellcmd($pass)." \"".escapeshellcmd($group) 3

Another:
string(0) "" >??

I now changed the script to be a connect of course first.:

var_dump(odbc_error());
$err=odbc_errormsg($conn_id);
if($err) {
        print ">".$err."<";
}

string(0) "" >??

Hi
I'm having the same problem with de lastest version of php on iseries 550.

The odbc_error function sometimes return ascii(001) and the odbc_errormsg returns bad string.

php version: 5.1.6 and lastest in cvs today.
OS: Windows XP lastest updates.

I know this is a old but but it still seems to be popping up in the latest versions (5.4.36-0+deb7u3) Jan 9th build Debain 7.8 OS, it seems to still be quite intermittent, the same functions will trigger one run but not the next, with the same input. The returned string is ether "?" (minus the quotes) or a non printing char.

@vaughng: Yes, quite old. Since this bug report seems to have lost its information, can you create a new one?

@requinix After more searching I think my issue is likely closely related to a poorly documented error in the the way my ODBC driver vendor returns information to SQLGetInfo function, as I think odbc_errormsg calls SQLGetInfo. So no error in the odbc_errormsg function. Thanks for looking at my mistaken post though.