×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

ODBC Microsoft Paradox Driver "Net Dir" will not accept a mapped drive

ODBC Microsoft Paradox Driver "Net Dir" will not accept a mapped drive

ODBC Microsoft Paradox Driver "Net Dir" will not accept a mapped drive

(OP)
ODBC Microsoft Paradox Driver "Net Dir" will not accept a mapped drive, has anyone ran into this before?

Hi, I am new to these forums. I posed this question in the ODBC section because it is not related to any specific language. However, if you must know the company I work for uses primarily CFML / Coldfusion / OpenBD / Railio.

I am interfacing with a proprietary Paradox software through ODBC. I am able to access the table structure while no other client is using the software. However, I am not able to access the software while another client is using the software.

Firstly a bit of background to the problem. The paradox PDOXUSRS.NET and PARADOX.NET (one or the other not both) files are what hold the key to the locked files (*.lck). If using a network setup with paradox/BDE (which this application does use BDE 3.2), you must access the PDOXUSRS.NET file from the same mapped drive on each client connection. So what I have done is install openBD (web CFML language like Coldfusion) on the server, and then setup an ODBC connection to the paradox tables. I then mapped a loopback network drive to the pdoxusers.net file (\\127.0.0.1\$i). I have set in the registry key for the ODBC DSN .net file location (after reading this post: http://www.thedbcommunity.com/index.php?option=com_content&task=view&id=236&;Itemid=44), this location is supposed to interface with the pdoxusers.net file and the .lck files respectively. I have tried the following values in the registry .net path setting to no avail:
1. i:\
2. i:
3. \\127.0.0.1\$i

The mapped network drive was not working. So I then searched out other way to map a network drive and possible make the drive appear to be local instead of mapped. I came up with the windows command subst to make the network loopback appear local, and this also did not work. I searched why and people say that subst is not a good way to map drives, so i gave up on subst.

I cannot figure out how to make this .net location a mapped drive or the likes. I spent 12 hours today at work, and no avail? anyone have a better way I am open to suggestions.

Thanks in advance,
-Alex

P.S. this was using the default 32bit version of microsoft's odbc driver (.db) for paradox.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close