PHP & ODBC

[technode]

I have set up an ODBC driver to a MySQL DB. Excel can connect and retreive data from the DB via this ODBC DSN. However when I write a php script to access the DSN I get:

Warning: odbc_connect() [function.odbc-connect]: SQL error: , SQL state 00000 in SQLConnect in C:Program FilesApache Software FoundationApache2.2htdocsODBCtestingODBCconnect.php on line 9

Line 9 is the call to the password. Excel does not use us username or password to connect to the ODBC, the ODBC has the user & pass for the MySL DB.

[code]$DSN=‘WebTrends Testing DSN’;
$DSNuser=‘connerys’;
$DSNpass=‘29080’;
$conn=odbc_connect(“WebTrendsDSNtest2”,"","");

if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql=“SELECT Browsers_0.Browser, Browsers_0.Visits, Browsers_0.TimePeriod, Browsers_0.StartDate, Browsers_0.EndDate
FROM Browsers Browsers_0
WHERE (Browsers_0.TimePeriod=‘2008.m03’)
ORDER BY Browsers_0.Visits DESC, Browsers_0.Browser DESC”;
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit(“Error in SQL”);}
echo “

”;
echo “”;
echo “”;
while (odbc_fetch_row($rs))
{
$compname=odbc_result($rs,“Browsers_0.Browser”);
$conname=odbc_result($rs,“Browsers_0.Visits”);
echo “”;
echo “”;
}

//close ODBC
odbc_close($conn);
echo “

Browsers_0.Browser	Browsers_0.Visits
$Browsers_0.Browser	$Browsers_0.Visits

”;[/code]

Thanks in advance for your help.

[peg110]

If it’s a MySQL DB Server, why are you using ODBC? or even DSN’s for that fact.

mysql_connect

mysql_select_db and mysql_query
or
mysql_db_query

Then

mysql_fetch_XXXX (assoc, array, etc…)

[technode]

It is a proprietary DB (that is a MySQL, but you can’t connect to the stored procedures and data that way). ODBC is the only way to pull the data out.

[Zyppora]

According to this bug page it’s possible that using the latest stable version of PHP might provide a solution to this issue. What’s your PHP version?