Tuesday, March 20, 2012

connection manager in SQL 2005

I am writing a new Ole DB connection thru connection manager in Visual
Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I
specify a database path as d:\temp\database.dbf and set up the extended
proporties in advance tab to dBase 5.0 and when I click "test connection"
button, I gives me an error:
"Test connection failed because of an error in initializing provider.
'd:\temp\database.dbf ' is not a valid path. Mare sure that path name is
spelled correctly and that you are connected to the server on which the file
resided. "
I used browser button to get the file and path and therefore I am sure it is
correct. Can anyone please help to fix this problem? Many thanks.Hi
"00EricClapton" wrote:

> I am writing a new Ole DB connection thru connection manager in Visual
> Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I
> specify a database path as d:\temp\database.dbf and set up the extended
> proporties in advance tab to dBase 5.0 and when I click "test connection"
> button, I gives me an error:
> "Test connection failed because of an error in initializing provider.
> 'd:\temp\database.dbf ' is not a valid path. Mare sure that path name is
> spelled correctly and that you are connected to the server on which the fi
le
> resided. "
>
> I used browser button to get the file and path and therefore I am sure it
is
> correct. Can anyone please help to fix this problem? Many thanks.
>
Are you sure that the file has the correct permissions and is not locked by
another application?
John

No comments:

Post a Comment