ODBC connection set up problem???

[bRycie]

Hi All,

Thank you very much for your assistance in advance.

I have encountered with an issue which I am unable to figure out the solution. The senario is that I am uanble to create the ODBC connection from one of our Production Servers (I call this here as PROD) to a database which is located on a different server. There are few issues related to this but the main one is the abilitity to complete the drive mapping. With the security measure applied to PROD, the drive mapping procedure has been disabled. I thought that applying the UNC path would solve the issue but this is not the case, as the ODBC administration on PROD would not allow this to occur.

Are there any solutions for this case?

Thank you.

-bRyce

 

[foxdev]

Can you tell us the nature of the server to which you want to connect (SQL Server? Oracle? Excel?) and the client you hope to use with the connection (Access? Excel?) -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com

 

[bRycie]

Both servers (PROD and SAMPLE) are running on NT Server. I am attempting to connect to an application which is located on SAMPLE using one of our report writer applications. This application has DBASE as the database backend.

NOTE:
PROD = Production Server/Main Server
SAMPLE = Other Server

 

[foxdev]

Are both servers in the same NT domain?
Are you using an older ODBC driver (say, an old dBase .DBF driver) that may not support UNC? If so, you might be able to get away with using a Visual FoxPro driver. -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com

 

[bRycie]

Yes, both servers are in the same NT domain.
Yes, the application is using an ODBC dBase IV driver to connect to the database. Should I try to get Visual FoxPro driver installed on both servers in order to create a connection?

 

[Guest_imported]

Can ODBC works in windows 2000 instead of windows 98 for Microsoft Server 7.