Solved

Problems converting existing report locations to UNC

Posted on 2003-11-20
12
888 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

 

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
 

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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

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. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

688 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