Re: [mdb-dev] Using mdbtools odbc to connect to an mdb on a windows box?

[<br...@br...>]

Hi,

In order to access a database file on another server you must have a
drive mapping to that server, either over SMB (windows file sharing)
or NFS or someother mechanism.  Access does not listen on a server
port like, say, SQL Server or Oracle do.

Brian

On Thu, 15 Apr 2004 07:58:02 +0000, nv...@pa... wrote:

>=20
> Hi. I'm using a PHP script to pull data out of an access database
> which is located on a remote windows 98SE machine. The file is on
> D:\shared\share\test.mdb.
>=20
> My configuration on Linux (Redhat 9.0)
> odbc.ini
>=20
> This is my odbc.ini
>=20
> [test]
> Description =3D Microsoft Access Database
> Driver =3D MDBToolsODBC
> Database =3D /home/nvs/test.mdb
> Servername =3D 127.0.0.1
> UserName =3D
> Password =3D
> port =3D 5432
> [test2]
> Description =3D Microsoft Access Database
> Driver =3D MDBToolsODBC
> Database =3DD:\shared\share\test.mdb
> Servername =3D (ip of win machine)
> UserName =3D
> Password =3D
> port =3D 5432
>=20
>=20
> The first database works, the PHP script returns the data. However,
> the second one produces the following error:
> Warning: SQL error: UODB4=B2=F3@=B8=CE=FF=BF=9B=CA=F1@ =80 , SQL state 00=
000 in
SQLConnect
> in /var/www/html/mdb.php on line 3
>=20
>=20
> Looking for this problem on the net has found me a few people with
the
> same issue, but no sollution. I am rather confused on how to set the
> database option for the second database. Do I use the entire path,
> like above, or do start from the shared directory? Do I need to
escape
> backslashes? Any help would be appreciated.
>=20
> Greetings,
> Niki Van Strydonck
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&op=3Dclick
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev