Solved

Problems converting existing report locations to UNC

Posted on 2003-11-20
12
850 Views
Last Modified: 2008-02-01
I have created numerous reports and set the data location to a mapped drive on my hard drive.  I need to change this location to a UNC source so I go into Database > Set Location and then click on "Convert to UNC" and nothing happens.  The location stays locked on the original mapped drive.  

How do I change my database location to a UNC path?  Thank you.

The database is a FoxPro database and I have set up an ODBC connection through the mapped drive on my computer as the database resides on a server which I do not have direct access to.

My computer is a Windows 2000 machine and I'm running Crystal Reports Developer version 8.5.  The server where the database resides is a Windows 2003 Server box.
0
Comment
Question by:WJM
  • 7
  • 5
12 Comments
 
LVL 7

Accepted Solution

by:
mnye earned 250 total points
ID: 9789892
set up the ODBC on the local machine where the report is running from and reference the UNC from there, then "set location" to that ODBC and "verify on every point".

Is there a specific reason you have the ODBCsitting on a shared drive?

hth
matt
0
 

Author Comment

by:WJM
ID: 9789952
I went into ODBC Datasource Administrator under "Administrative Tools" in control panel and choose to Add a new system datasource.  I choose the Microsoft Visual FoxPro Driver which brings up the ODBC Visual FoxPro Setup window.  This allows me to enter a Datasource Name, Description and Type and then I can enter the path to the datasource; however, when I try to type in the UNC location for path, I get an error message saying "Invalid Free Table Directory Specification".

Our database resides on a server which I cannot directly access so a share has been set up for me to access the database, that is why the ODBC points to the shared drive.

Bill
0
 
LVL 7

Expert Comment

by:mnye
ID: 9790011
you " cannot directly access" it?  is the computer you are executing the report from trusted by the server (same network)?

What is the syntax you are using for the UNC?
ie.
myDBServer.domianname.com

you cant point to a mapped drive.

What "type" is ticked when setting up the System DSN?  You should have the .DBC option ticked I believe.


hth
matt
0
 

Author Comment

by:WJM
ID: 9790310
Yes, the computers are on the same network.

I am using \\servername\path as my syntax

I can point the ODBC to a mapped drive (Q: in this case), but instead of Q: I want to point to the UNC that anyone can use regardless of mapping.
0
 
LVL 7

Expert Comment

by:mnye
ID: 9790450
make sure you have the latest ODBC driver for FoxPro:

http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

are you trying to connect directly to a specific table or just VFP db file?
0
 

Author Comment

by:WJM
ID: 9790554
I followed your link and found the following warning on the site:

"Customers running Windows Millennium and Windows 2000 should not install this driver."

I am running Windows 2000, should I ignore this warning and download the update anyway?

The ODBC datasource points to the location where there are numerous tables, for most of my reports I am just trying to link to one or two tables.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:WJM
ID: 9790661
I am still curious why the "Convert to UNC" button doesn't work in Crystal Reports.  Or maybe I don't understand how it works?
0
 
LVL 7

Expert Comment

by:mnye
ID: 9790706
is there anyway to logon the the database server and open the report from there?  you may not be getting the full UNC when you try to convert remotly.  The "Convert to UNC" should work just the way you were attempting to use it.  

Another thing that could be causing issues is if this db server is behind a firewall.  youd need to enable NetBOIS if this is the case in order to communicate with VFP.


hth
matt
0
 

Author Comment

by:WJM
ID: 9790926
No, there is no way for me to open the report from the server, I can only open it from my machine as our IT group does not allow me access to the server as a whole, only to certain shares where our data resides.

I will ask about the firewall issue
0
 

Author Comment

by:WJM
ID: 9791768
Well don't I feel like a fool.  I was entering the wrong UNC for the ODBC datasource, once I got it right (off by one character) it linked up just fine.

I still want to know why the "convert to UNC" button wouldn't work...
0
 
LVL 7

Expert Comment

by:mnye
ID: 9791884
did it not work when with the proper spelling?  I feel your pain.  Its always somehting minor.

good luck,
matt
0
 

Author Comment

by:WJM
ID: 9791941
Now, does anyone know how the "Covert to UNC" button is supposed to work, this seems like it should have made life much simpler...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now