I access dbf file located on non shared harddisk partition

[adcounsel1]

Dear All

How can I access dbf file located on non shared harddisk partition.

Thanks

Hashim

 

[Mike Gagnon]

Map to it first.

oNet = CreateObject('WScript.Network')    
oNet.MapNetworkDrive('I','\\myserver\myFiles',.T.,'mike','password')

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[adcounsel1]

will it show temporary map drive in explorer or we have to shut down the map connection.


Hashim
If raising children was going to be easy, it never would have started with something called LABOR! --
Smile, it confuses people!

 

[adcounsel1]

I have pass that code and found that error:

oNet = CreateObject('WScript.Network')
oNet.MapNetworkDrive('I','\\asi\endcap',.T.,'ijaz','')

OLE Idispatch code 0 from wshnetwork.mapnetworkdrive the specified device name is invalid



Hashim
If raising children was going to be easy, it never would have started with something called LABOR! --
Smile, it confuses people!

 

[mkrausnick]

You don't need to map the drive. You can use the UNC filename convention to open the file:

USE \\servername\physicaldrive\directory\filename.dbf

or

USE \\servername\sharname\filename.dbf

Mike Krausnick
Dublin, California

 

[Mike Gagnon]

Mike Krausnick

My understanding is that if you don't have admin right and the folder id not a shared folder {"on non shared harddisk partition"), your suggestion will fail.



Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[adcounsel1]

Dear Gagnon

You are right, without admin right we can map the drive.

But guide me to resolve my problem, I have use ur provided code and found that error:

oNet = CreateObject('WScript.Network')
oNet.MapNetworkDrive('I','\\asi\endcap',.T.,'ijaz','')

OLE Idispatch code 0 from wshnetwork.mapnetworkdrive the specified device name is invalid

Thanks

 

[Mike Gagnon]

oNet = CreateObject('WScript.Network')
oNet.MapNetworkDrive('I[red]:[/red]','\\asi\endcap',.T.,'ijaz','')

Missing the two little dots?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[adcounsel1]

I have put the exact code as u define, but same message OLE Idispatch code 0 from wshnetwork.mapnetworkdrive the the network path not found.

I have winxp pro, vfp 6 installed on workstation.
server to i m connecting is on workgroup os win2000 adv.server. server user name IJAZ, password nill, desired files is resided on C drive with $share name.

do i have to install wsh for this, if so from where i have to download it.

Thanks

 

[Mike Gagnon]

What is the server name? ASI?
oNet.MapNetworkDrive('I','\\[red]asi[/red]\endcap',.T.,'ijaz','')

do i have to install wsh for this, if so from where i have to download it.

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/webdev.asp

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[mkrausnick]

Mike G:
I don't think it's true that Administrator privilege is required to access a folder on a remote hard drive. The user DOES have to have permission to access the folder, but they would in any case, right?

I have applications being run by users on my LAN without the drive where the application resides being mapped. The first-level folder APPS that contains all the applications is shared, so maybe that's why it works, but the individual application folders are not shared.

Adcounsel1, you indicate that there is a share :

desired files is resided on C drive with $share name

If that's true, make sure the user has permission to access the folder, then try the UNC convention. If it works, it's a better choice because you don't have to worry about mapping a drive and then unmapping it when you're done.



Mike Krausnick
Dublin, California

 

[Mike Gagnon]

Mike

You right, but I have a feeling the story is changing here. If I look at the quote you are mentionning and the title of the thread, there is confusion.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[adcounsel1]

Thanks Mgagnon

It works fine.

Now further, i want to place dbf in a specific folder on the non shared drive, i have change the script but it dosent work, (message: network path not found) where i have to change the syntex:

file is resided at : c$\canttg\malbot.dbf

oNet = CreateObject('WScript.Network')
oNet.MapNetworkDrive('n:','\\asi\c$',.T.,'ijaz','')

Thanks

 

[adcounsel1]

Thanks Mgagnon

It works fine.

Now further, i want to place dbf in a specific folder on the non shared drive, i have change the script but it dosent work, (message: network path not found) where i have to change the syntex:

file is resided at : c$\canttg\malbot.dbf

oNet = CreateObject('WScript.Network')
oNet.MapNetworkDrive('n:','\\asi\c$',.T.,'ijaz','')

Thanks

 

[adcounsel1]

I want to place dbf in a specific folder on the non shared drive, i have change the script but it dosent work, (message: network path not found) where i have to change the syntex:

file is resided at : c$\canttg\malbot.dbf

oNet = CreateObject('WScript.Network')
oNet.MapNetworkDrive('n:','\\asi\c$',.T.,'ijaz','')

Thanks