[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 948
  • Last Modified:

Problems converting existing report locations to UNC

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
WJM
Asked:
WJM
  • 7
  • 5
1 Solution
 
mnyeCommented:
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
 
WJMAuthor Commented:
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
 
mnyeCommented:
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
WJMAuthor Commented:
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
 
mnyeCommented:
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
 
WJMAuthor Commented:
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
 
WJMAuthor Commented:
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
 
mnyeCommented:
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
 
WJMAuthor Commented:
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
 
WJMAuthor Commented:
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
 
mnyeCommented:
did it not work when with the proper spelling?  I feel your pain.  Its always somehting minor.

good luck,
matt
0
 
WJMAuthor Commented:
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now