[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Problems converting existing report locations to UNC

Posted on 2003-11-20
12
Medium Priority
?
929 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

650 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