I have a linked server to DBase III through SQL Server 2005.  I am
developing a Web App that pulls data from this connection to a
gridview.  Everything works fine when i login and use the connection,
or another domain admin.  But when a domain user logs in it give me:

Cannot initialize the data source object of OLE DB provider
"Microsoft.Jet.OLEDB.4.0" for linked server "PROJECTS".


I am sure that there is something simple to resolve this and that it
probably has to do witht  sp_addlinkedsrvlogin, but i guess i don't
understand the connection well enough to properly troubleshoot.   this
is my connect query:


EXEC sp_addlinkedserver 'PROJECTS',
                        'Jet 4.0',
                        'Microsoft.Jet.OLEDB.4.0',
                        'c:\shared\projectw\data',
                        NULL,
                        'dBase III'
GO


EXEC sp_addlinkedsrvlogin
                        @rmtsrvname='PROJECTS',
                        @USESELF=FALSE,
                        @LOCALLOGIN=NULL,
                        @RMTUSER=NULL,
                        @RMTPASSWORD=NULL
GO


And here is the connecton properties:


Authentication Method:  Windoes Authentication
User Name:  mydomain\myusername


THANKS FOR ANY HELP YOU CAN PROVIDE ME!!!!!

column dataType
Joining 2 select statement with like fields
Views and CTEs performance problem
Adding a space in a field
Case statement question