ftp connection in crystal reports.

[Former Member]

Hi Experts,

I have a file located in FTP Server location. I have to use that file and create a report. how can i create a connection between FTPserver and Crystal reports.

Advanced thanks

Swetha

[Former Member · Accepted solution]

Hello Swetha,

Please go to the database expert--->Create New Connection---->Select Database Files option and specify your network path.

Hope this helps.

Regards,

Chinmay

[former_member11696]

Create a VPN connection to the server first, then you have access to the file. I don't believe CR will pass the user name and password on a single line. Connection security must be established first.

[Former Member]

If it's a CSV file then simply create a new connection of type "Access/Excel (DAO)" and select that file with a path like "ftp://username:password@server:port/path/data.csv" for "Database Name".

It should work but I haven't tested it - please kindly tell me the result.

Thanks,

Ray

[Former Member]

HI Ray,

Thank you for the good information. i tried this "ftp://username:password@server:port/path/test.txt" for "Database Name". but it's giving error.

Logon Failed

Details:DAO Error Code: 0xe43

Source:DAO.Workspace

Description: Invalid Internet access

Please help me on this.

I am accesing txt file from the ftp location.

Advanced thanks

Swetha

Edited by: swetha11 on Aug 17, 2010 5:55 PM

Edited by: swetha11 on Aug 17, 2010 8:37 PM