Enterprise Foxpro Database connectivity problem

[danjausten]

Hi,

I'm having problems connecting to a Microsoft Visual Foxpro database on Enterprise 10 using ODBC. I have created a DSN that connects to the database and have then created a business view based on the DSN which works fine in the Report Designer. When I save the report to Enterprise I get the following message :

There was an error retrieving data from the server: The database logon information for this report is either incomplete or incorrect.

The database properties are all blank apart from the server which is the DSN name. I guess this is the problem but the Foxpro DB doesn't have a user/password. I've tried putting the physical filename of the DB in database name box but to no avail.

I have even created the Business View on the Enterprise server so the DSN must be ok.

Any thoughts?

Cheers,

Dan Austen

 

[Lochbel]

Are you using a UNC path in yr ODBC connection to the database?

Lochbel

 

[danjausten]

Hi Lochbel,

Yes, I am using a UNC path in my ODBC connection.

Dan