PHP with file dsn

Anon

Hey Techies,
Can anyone help me connect any access database with file or user dsn.(System dsn works fine.)
I have to access a remote database. I dont know how to go about it.
Basic application will have application(PHP) on one server and database(MS-Access) on some different server.
!! F1 !! F1 !! F1 !! F1 !! F1 !! F1
BHUSHAN

bretticus

yikes! Do you really wanna use MS-Access or do you have a choice?

I did find this link, however:

http://www.phpbuilder.com/columns/siddarth20000228.php3

Anon

Hi ,
The link given my you is already referred by us and it talks about connecting to ACCESS Db on the same server. As Bhushan has already explained our PHP application is on one server (e.g. www.xyz.com ) and the Access Db will be on another server (e.g. www.abc.com)

Can someone help ?? 🙁

!! F1 !! F1 !! F1 !! F1 !! F1 !! F1

bretticus

You might try a DSN-less connection string :

provided you have a netbios share

$dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=\myServer\myShare\myPath\myDb.mdb;Uid=admin;Pwd=;";

odbc_connect ( $dsn, "", "");

If your php parsing server is *NIX you might install or configure Samba.

I don't know if you can connect via ip address, I doubt it.

Again, do you have to use Access? I would just get WIN version of MySQL.