----- Original Message -----
> From: Pid <p...@pidster.com>
> To: Tomcat Users List <users@tomcat.apache.org>
> Cc:
> Sent: Thursday, December 15, 2011 1:47 PM
> Subject: Re: Access dbf files outside context/docbase
>
> On 15/12/2011 20:56, David kerber wrote:
>> I am trying to figure out how to access .dbf files that are on a
>> networked drive from my TC 5.5.xx server. I have no trouble with the
>> coding; it all works fine from my Eclipse dev environment. I believe
>> the issue is tomcat's contexts on the production server. I've seen
>> plenty of suggestions for just reading and streaming files from outside
>> the docbase, but nothing for accessing them for database purposes. I'm
>> using the Microsoft DBF driver.
>>
>> As I said above, it all works fine in my dev environment through
>> Eclipse, connection to the dbf files in their real home on the network.
>> However, when I try to do it from my production server, I get the
>> following log entries:
>>
>> 2011-12-15 14:47:53: debugValue = 32: In WraDbfJdbc: Connect params:
>> urlPrefix=jdbc:odbc:DRIVER={Microsoft dBase Driver (*.dbf)};DBQ=,
>> databaseName = //172.17.47.9/dbase/customer/delta
>>
>> Thu Dec 15 14:47:53 EST 2011: Exception in class:
>> com.wra.websira.WraDbfJdbc, Msg: 'Creating database:
>> //172.17.47.9/dbase/customer/delta', Exception: java.sql.SQLException:
>> [Microsoft][ODBC Driver Manager] Data source name not found and no
>> default driver specified
>>
>>
>> I belive that means it can't get to the UNC name listed as the
> database.
>>
>> Any hints? I've been googling and reading for a couple of hours now,
>> and haven't come up with anything.
>
> Obvious first question: file permissions?
>
>
> p
I'm going to expand on Pid's question and make some assumptions.
if you're running this on a Windows server (assumption 1) as a service
(assumption 2), using the Service account (assumption 3), you will not have
access to UNC paths or network drives.
There are several games you can play here.
1. Run the service under an account that has network and UNC privileges.
2. Try some ways to map drives so that a Service account can see them
See the following for example:
http://stackoverflow.com/questions/182750/how-to-map-a-network-drive-to-be-used-by-a-service
Disclaimer - I'm not a Windows person, so it's best to do research before
trying any of these suggestions.
just my two cents . . . .
/mde/
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
