please help: .mdb access problem {Scanned}

[Siki Zoltan]

Hi Hedwig,

I'm not sure that Access databases are supported direcly. Try to use odbc 
connection. Create a Data Source Name (DSN) using Control panel, and 
refere to that DSN and table name instead of the mdb file. 

Zoltan

On Mon, 8 May 2006, Hedwig Matl wrote:

> Hello and thanks for your reply!
> 
> I edited the path for my message. I use the absolute path, which looks 
> like this (I also tried relative paths):
> 
> ---
> CONNECTIONTYPE OGR
> CONNECTION "c:\ms4w\apps\test2\mdb\Abtenau.mdb"
> ---
> 
> This is the error I get when I try to open the file with ogrinfo:
> 
> ---
> C:\>ogrinfo c:\ms4w\apps\test2\mdb\Abtenau.mdb
> FAILURE:
> Unable to open datasource `c:\ms4w\apps\test2\mdb\Abtenau.mdb' with the 
> following drivers.
>    -> ESRI Shapefile
>    -> MapInfo File
>    -> UK .NTF
>    -> SDTS
>    -> TIGER
>    -> S57
>    -> DGN
>    -> VRT
>    -> AVCBin
>    -> REC
>    -> Memory
>    -> CSV
>    -> GML
>    -> ODBC
>    -> PostgreSQL
>    -> MySQL
> ---
> 
> Thanks a lot for your help
> Hedwig
> 
> Frank Warmerdam schrieb:
> > Hedwig Matl wrote:
> >> Hello!
> >>
> >> I'm new to mapserver and already somewhat at a loss.
> >> If I try to access a .mdb file (via map file and ogrinfo) I get 
> >> following error:
> >>
> >> msOGRFileOpen(): OGR error. Open failed for OGR connection 
> >> `c:\..\test.mdb'. File not found or unsupported format.
> > 
> > Hedwig,
> > 
> > Is this the literal error you are seeing, or have you edited the path
> > out replacing it with ".."?  If this is the literal error then it seems
> > that the path to the file is being constructed improperly.  It may be
> > that mapserver is trying to apply a SHAPEPATH relative path.  I would
> > suggest you use an absolute path tot he file.  What does your CONNECTION
> > string look?
> > 
> > Best regards,
>