Re: Access Database

From: Date: Tue, 26 Dec 2000 23:28:10 +0000
Subject: Re: Access Database
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-31889@lists.php.net to get a copy of this message
Hi Jaime: > Is posible connect php pages with access database?.. > Sorry for the question i'm beginner in php. 1) Go to the ODBC control panel: Start Menu | Settings | Control Panel | ODBC 2) Click the "System DSN" tab. 3) Click Add 4) Double click "Microsoft Access Driver (*.mdb)" 5) In the "Data Source Name" make up a name for the database you want to use. 6) In the "Database" section: a) If the databaes you want to use already exists, click "Select" and hunt it down. b) If the database DOES NOT YET EXIST, click "Create" and follow the instructions. 7) If that database is password protected, click the "Advanced" button and enter the info there. You're set to go. When connecting to this database in your PHP scripts, use the name you made up in Step 5 as the "DSN" inside the odbc_connect() statements. Once you have a System DSN set up, check out my SQL Solution scripts. It simplifies the PHP / MS Access (or any ODBC reliant database) integration process. http://www.analysisandsolutions.com/code/sql/ Enjoy, --Dan -- PHP scripts that make your job easier http://www.analysisandsolutions.com/code/ SQL Solution | Layout Solution | Form Solution T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Ave, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409

« previous php.general (#31889) next »