Delphi FireDac (32bit): [FireDAC][Phys][ODBC][Elevate Software][ElevateDB] ElevateDB Error #403 Data source is read-only. Delphi dbGo (32bit): [Elevate Software][ElevateDB] ElevateDB Error #403 Data source is read-only. PHP 8 (64bit): Warning: odbc_exec(): SQL error: [Elevate Software][ElevateDB] ElevateDB Error #403 Data source is read-only, SQL state in SQLExecDirect
<?php class ODBCTest { private $_Connection; //holds the ODBC connection function __construct() { } function __destruct() { $this->CloseConnection(false); } private function GetConnection() { $dbtype="odbc"; $cursr="SQL_CUR_DEFAULT"; $dsn="<dsn>"; $usr="<user>"; $pwd="<password>"; $this->_Connection = odbc_connect($dsn, $usr, $pwd); if ($this->_Connection == false) { echo 'NO ODBC Connection'; die; } } public function TestUpdate() { $this->GetConnection(); $_query = "update code set onhand = onhand where stockcode = 'zz44'"; odbc_exec($this->_Connection, $_query); echo odbc_errormsg($this->_Connection); } private function CloseConnection($do_die) { if ($this->_Connection != false) { odbc_close($this->_Connection); } if ($do_die == true) { $this->_Connection = false; die; } } } $obj = new ODBCTest(); $obj->TestUpdate();
Warning: odbc_exec(): SQL error: [Elevate Software][ElevateDB] ElevateDB Error #403 Data source is read-only, SQL state
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add millennium@1000years.com to your trusted senders list in your email software.