Connecting To access with php

digitak · 03-08-2009, 10:22 AM

hi !

how can i connect to access database and select,insert,update,delete from that ?

help me please

Sakakuchi · 03-08-2009, 07:16 PM

Not that I ever tried it, cause I think access simply sucks

, but as far as I know you must make and dsn ->pointing to the db.

then you connect like:

PHP Code:


			
$connect = odbc_connect('DSN-NAME','USERNAME','PASSWORD');

think thats a way....

digitak · 03-09-2009, 06:40 AM

what is dsn ? :D
and how about select ,insert and ... ?

Sakakuchi · 03-09-2009, 08:23 AM

DSN:
http://en.wikipedia.org/wiki/Database_Source_Name

Creating a DSN under Windows XP:
Create a DSN under Windows...
(just google for other M$ Versions.)

Then you can use normal SQL-queries, maybe they differ from Mysql a little (Think to have heard something like this??!). Just google a bit for that syntax, should be pretty much the same