?
Solved

Problems converting existing report locations to UNC

Posted on 2003-11-20
12
Medium Priority
?
907 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 1000 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
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

 

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses

765 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