System.Data.OleDb.OleDbException '\\landfill\e\payload\db' is not a valid path

[Dermot O'Loughlin]

Hi all,

I am trying to do what I thought would be a simple task: connect to a
paradox database, that resides on another machine on our network,
through .Net.

I get the following error:

System.Data.OleDb.OleDbException: '\\landfill\e\payload\db' is not a
valid path. Make sure that the path name is spelled correctly and that
you are connected to the server on which the file resides

Now this path is definitly a valid one.

The code is:

System.Data.OleDb.OleDbConnection conn = new
System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\\\landfill\\e\\payload\\db;Extended Properties=Paradox 5.x");

conn.Open();


Any ideas?

Thanks,
Dermot.

 

[Paul Clement]

On 2 Nov 2004 08:48:53 -0800, (e-mail address removed) (Dermot O'Loughlin) wrote:

¤ Hi all,
¤
¤ I am trying to do what I thought would be a simple task: connect to a
¤ paradox database, that resides on another machine on our network,
¤ through .Net.
¤
¤ I get the following error:
¤
¤ System.Data.OleDb.OleDbException: '\\landfill\e\payload\db' is not a
¤ valid path. Make sure that the path name is spelled correctly and that
¤ you are connected to the server on which the file resides
¤
¤ Now this path is definitly a valid one.
¤
¤ The code is:
¤
¤ System.Data.OleDb.OleDbConnection conn = new
¤ System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
¤ Source=\\\\landfill\\e\\payload\\db;Extended Properties=Paradox 5.x");
¤
¤ conn.Open();
¤
¤
¤ Any ideas?

The connection string Data Source should only contain the path to your Paradox files. It should not
contain the database file name. The file name is specified in the SQL statement as a table.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Dermot O'Loughlin]

Paul,

the filename is not specified. 'db' is a folder.

Dermot.

 

[Paul Clement]

On 3 Nov 2004 06:11:40 -0800, (e-mail address removed) (Dermot O'Loughlin) wrote:

¤ Paul,
¤
¤ the filename is not specified. 'db' is a folder.
¤
¤ Dermot.

I don't see any problem with using a UNC path. I've tested it and it works fine.

Could there be a security issue with respect to the file resource? Does the user have access to this
resource?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Dermot O'Loughlin]

Paul, this may be the case. I'll investigate further. Thanks for your help.

Dermot.