Our EMR software uses Advantage Database SQL server as its database and I'm creating various PHP projects which require interaction with this database.
What is the best approach to connecting and working with Advantage DB SQL and PHP? I'd like to connect on a read-only level to prevent any data wrong-doing with insurance/patient/provider records.
Note: I connect to other databases using PDO drivers. Is there an Advantage DB driver for PDO that I'm unaware of?
Server info:
PHP, Windows 2008, IIS 7
PHP PDO support is slated for release in v11.0 of Advantage later this summer. It is listed on our user voice feature request site here: PDO feature request.
You can view our PHP documentation online on our developer zone website here: PHP Documentation.
On the features page for the product, they list an ODBC connector under the "Servers & Clients" section.
It happens that PDO can speak ODBC. This is probably your best bet.
They also have a separate PHP extension, however they're hiding it being a registration wall and the documentation does not seem to be public. Whether it includes a PDO driver is not stated.
{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://img.manongdao.com/sparkler-677774__340.jpg', '推荐 太酷不给撩 的文章《PHP PDO Connect to Advantage Database SQL Server》','https://www.manongdao.com/article-917914.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}