Crystal Report 10 and MS Visual FoxPro DB

[pnad]

Hello all,

I have a Crystal Report that use MS OLEDB provider for ODBC drivers to connect to a FoxPro DB that is on another server. When I run the Crystal Report, I get an error saying:

Error Occurred Reading Records: -2147189176: Logon failed. Details: ADO Error Code: 0x80004005 Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed SQL State: IM006

Any help will be appreciated. Please let me know if you need more info.

Thanks.

 

[satinsilhouette]

Error Occurred Reading Records: -2147189176: Logon failed

You must need permissions or a user id to get into that database.

Thanks so much!
satinsilhouette

 

[pnad]

Thank you for your response.

The userID and password that is used to connect to the DB does have access to the DB.

I set up the DSN against a .dbc file and have referenced it using the UNC path because the datasource is on a Novell network. Does the userID also need to have access to the network folder.

 

[synapsevampire]

Yes, the account needs permission to access the file itself.

-k