Service vs. Application Using ODBC That Uses A Network Share



I have a service that is responsible for retrieving data from a database.
The database type is DBF's in a free directory. To connect to the database,
I have an ODBC DSN setup that points to the database on a Network Share on a
different machine. When the service tries to connect to the database
through the ODBC, it cannot. As a work around, I created a desktop
application to perform the same tasks. It has no issue connecting to the
database when required to, using the same ODBC DSN. I am sure that this is
some security issue, but I do not know how to solve it. The only way I can
really query these DBF's is through an ODBC? Does anyone know why the
service cannot connect to the DB? I have tried to have the service logon as
a domain administrator just to see if it works, and it does not.

Any ideas? Need more info?

Thanks for any input you have!!

Seth


.



Relevant Pages

  • Querying MS SQL database
    ... I have configured an ODBC DSN to connect to a SQL database on our ... network and populate records in the local Access database. ... deployed in our environment (HP P4 2.8GHz desktop PCs). ...
    (microsoft.public.access.queries)
  • Querying MS SQL database in Access
    ... I have configured an ODBC DSN to connect to a SQL database on our ... network and populate records in the local Access database. ... deployed in our environment (HP P4 2.8GHz desktop PCs). ...
    (microsoft.public.access.queries)
  • Re: (0x80004005) Data source name not found
    ... ' Open Connection to the database ... This is not the connection string to use for an ODBC DSN. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • DB problem in Win 32 app
    ... I have two databases created on the same default instance of SQL Server 2K. ... In each database, there is a user name called "demo" with a same password ... I can retrieve data from one database but not from the ... I set the ODBC DSN point to the first database "DB_1". ...
    (microsoft.public.vc.database)
  • Re: Database type independence
    ... > independent of the database type. ... > about database type independance is one of the main reasons that EJB ... > demand for relational database vendor independant applications. ... > Relational databases have proven to be the superior database type. ...
    (comp.object)