PDA

View Full Version : Issue with the Adodb (mssql database)


navanath
01-11-2008, 12:54 PM
Hi All,

I am using the amfphp 1.2.6 version. I am using the following code to retrieve the record set from the mssql database.

PHP Code:



$DB =ADONewConnection('odbc_mssql');
$dsn = "Driver={SQL Server};Server=localhost;Database=myDb;";
$DB->Connect($dsn,'sa','password');
$DB->SetFetchMode(ADODB_FETCH_ASSOC);

$query="SELECT * FROM users ";
$result = $DB->Execute($query);

if ($result === false) {
trigger_error("Error executing query");
}
else {
return $result->_queryID;
}


I am getting the following errors on the query browser

Warning: unpack() [function.unpack]: Type d: not enough input, need 8, have 0 in C:\wamp\projects\amfphp\amf-core\io\AMFDeserializer.php on line 453

I have done R&D on the amfphp class why is not working and find the following and found that issue is with the odbcAdapter.php file.

Please help me to solve this issue.

Thanks in advance.