please help: .mdb access problem

[Delfos, Jacob]

Hedwig,

I think you have to put the tablename behind the path, like:

CONNECTION "c:\ms4w\apps\test2\mdb\Abtenau.mdb,theTable"

Hope that helps.

Regards,

Jacob

> -----Original Message-----
> From: UMN MapServer Users List 
> [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of Hedwig Matl
> Sent: 8 May 2006 16:12
> To: MAPSERVER-USERS at LISTS.UMN.EDU
> Subject: Re: [UMN_MAPSERVER-USERS] please help: .mdb access problem
> 
> 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,
>