{"id":1415,"date":"2018-01-19T19:22:49","date_gmt":"2018-01-19T19:22:49","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/interfacing-with-ms-access-page-3\/"},"modified":"2018-01-19T19:24:46","modified_gmt":"2018-01-19T19:24:46","slug":"interfacing-with-ms-access-page-3","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/interfacing-with-ms-access-page-3\/","title":{"rendered":"Interfacing with MS Access Page 3"},"content":{"rendered":"
\n
\n
By Siddharth Venkatesan<\/div>\n
on July 30, 2000<\/div>\n<\/p><\/div>\n
\n

Setting Up The ODBC Connection<\/h2>\n
\nI previously mentioned Leo West and its from this page that I found out how to
\ncreate an ODBC link. To create an ODBC link, open up Control Panel<\/b> and
\nfrom within control panel, open up ODBC<\/b>. The icon for this looks like this:<\/div>\n
\u00a0
\"DBC<\/div>\n

\u00a0<\/p>\n

\nWhen you open this up, you end up with a screen like this:\n<\/div>\n

\u00a0<\/p>\n

\n\"picture<\/div>\n

\u00a0<\/p>\n

\nSelect the System DSN<\/b> tab. If you havent done any work with user defined DSN’s,
\nthis should be empty. Select the Add<\/b> button. You will get a screen which looks
\nlike this:<\/div>\n

\u00a0<\/p>\n

\n\"Create<\/div>\n

\u00a0<\/p>\n

\nSelect the Microsoft Access driver. Click on the finish<\/b> button. You will
\nnow see this screen:<\/div>\n

\u00a0<\/p>\n

\n\"ODBC<\/div>\n
\nIn the Data Source Name text field, enter a name which you wont forget, as this
\nwill be the way you will call your database. For the purposes of this tute, enter
\n‘WebTute’. The description text field is for your purposes as you may want to
\nmanage your DSN connections later.<\/div>\n
\nFinally, select the Select<\/b> button. From this menu, choose the Access
\ndatabase you initially created.<\/div>\n
\nAnd that’s it! your ODBC connction is done! Now to interface with it.\n<\/div>\n<\/div>\n

<\/p>\n

\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
| <\/div>\n
5<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

By Siddharth Venkatesan on July 30, 2000 Setting Up The ODBC Connection I previously mentioned Leo West and its from this page that I found out how to create an ODBC link. To create an ODBC link, open up Control Panel and from within control panel, open up ODBC. The… <\/a><\/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-1415","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1415","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=1415"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1415\/revisions"}],"predecessor-version":[{"id":2221,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1415\/revisions\/2221"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}