Accessing Paradox DB files from Crystal

[basil3legs]

I have a paradox Database which I am trying to write a report on. If I use the URL path to the file, Crystal Reports can't see the memo fields. If, however I set up an ODBC link to the file it can.

The problem is that the file is not on the report server so when I try to run the report from Crystal Enterprise on the same server, it can't open the database and gives a failure message of "Cannot open SQL server".

Crystal is running on an NT 4 box which (as far as I'm aware!) doesn't have SQL Server on it. I would assume this is a very vague Crystal message saying Enterprise doesn't have access rights to the file on the other server via the ODBC link.

Does anyone have any ideas of how to set the correct rights up if this is the case, or alternatively, a way round this problem, e.g. being able to see the memo fields without using ODBC?

Thanks in advance.

 

[basil3legs]

By the way, this is Crystal Reports 8.5 with Enterprise 8.

 

[synapsevampire]

Your ODBC connection should be able to connect to another machine, can't you just map a drive or use Network to point to it?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[basil3legs]

My ODBC connection sees the file fine when running the report from Crystal Reports. However, ODBC will not let me map to the Network address but only to a mapped drive. It is when I try to schedule the report through Enterprise that I get the problems as it doesn't like mapped drives.

I had similar problems when mapping direct to database files in that Enterprise wouldn't use mapped drives but required the Network URL address for the files so it could log in to them. This was easily resolved but similar options do not appear for ODBC and Crystal will not see the Memo fields without ODBC.

I have tried both System DSN and File DSN which both have a username box but no mention of a password although I feel the solution may lie somewhere here.