please help: .mdb access problem

[Hedwig Matl]

Hello Jacob!

Thanks for your mail.
I tried this out, but no - it doesn't work.

With best regards
Hedwig


Delfos, Jacob schrieb:
> 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,
> 


-- 
Mag. Hedwig Matl • Forschungsassistentin

Universitätszentrum Rottenmann (UZR)
Technologiepark 2, A-8786 Rottenmann
www.uni-z-rottenmann.at • www.uzr.at

T: +43 (3614) 21021-19
E: matl.hedwig at uzr.at