{"id":1549,"date":"2018-01-19T19:22:58","date_gmt":"2018-01-19T19:22:58","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/odbc-socket-server\/"},"modified":"2018-01-19T19:24:52","modified_gmt":"2018-01-19T19:24:52","slug":"odbc-socket-server","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/odbc-socket-server\/","title":{"rendered":"ODBC Socket Server"},"content":{"rendered":"
\n
\n
By Tim Uckun<\/div>\n
on December 6, 2000<\/div>\n<\/p><\/div>\n
\n
\n
“System Administration: It’s a dirty job, but someone said I had to do it”<\/i><\/center>
\n
Seen on a T-shirt<\/center><\/div>\n
\nOne of the most commonly faced dilemmas of system administrators is making dissimilar
\noperating systems and tools work with each other. It is my hope that this article will
\nmake those system adminstrators’ jobs a little easier when it comes to making Access and PHP work
\ntogether. <\/div>\n
\nIf you want to use your Microsoft Access database with PHP you have a limited number of
\nmethods you can try. The most obvious one is to run PHP on Windows and use the ODBC
\nfunctions. This is not an acceptable solution to many people because it forces you to
\nuse IIS and NT as your web server environment. For those preferring other operating systems,
\nthe most popular choice is an ODBC to ODBC bridge as sold by Openlink
\n(http:\/\/www.openlinksw.com\/<\/a>) and easysoft
\n(http:\/\/www.easysoft.com\/<\/a>). Both of these products
\ncome with a limited version that you can download and use for free. I wanted a open source
\nalternative to these products and finally found what I was looking for in ODBCSocketServer
\n(http:\/\/odbc.linuxave.net\/<\/a>). This tutorial will take
\nyou through configuring your machines and using the socket server.<\/div>\n
\nIn order to accomplish this task, you are going to need two machines. One machine will have
\n the operating system of your choice, the web server of your choice and PHP on it. The other machine
\n will have Windows, MS Access, and ODBC on it. The socketserver on
\nthe Windows machine will look for connections on a TCP\/IP port, PHP will generate XML
\ncommands and send them to the socket server. The socket server will then execute the SQL
\nstatements in the commands and pass another XML document back to PHP. Finally, PHP will parse
\nthe XML document and manipulate the resulting recordset. Here is a simple diagram.<\/div>\n
\n
\n   MS-Access                                 Browser\n      |                                         |\n   ODBC\/ADO                                 www server\n      |                                         |\n socket serverPHP\n                      XML Data\n Windows Machine                          Linux Machine\n <\/pre>\n<\/div>\n
\nWhat is really interesting is that PHP does not need any database services compiled in only XML and
\nthe built in socket services are needed.<\/div>\n
\nOk, lets get started. I will be referring to the Linux machine as the client and the windows
\nmachine as the server for the rest of this document.<\/div>\n<\/div>\n
<\/p>\n
\n
1<\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/a> <\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div>\n
 Download: timuckun20001207.zip<\/a>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"
System Administration: It’s a dirty job, but someone said I had to do<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1549","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1549","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1549"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1549\/revisions"}],"predecessor-version":[{"id":2413,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1549\/revisions\/2413"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}