I'm confused. What is the data type on the backend? I don't think it is a Windows 2000 issue at all. For instance, I am on a Windows 2000 pro workstation and if I want to open a table on a windows 2000 server in a shared directory I can issue the following in VFP and it works:
USE \\192.168.2.2\development\profiler\data\insured
works the same as:
USE \\NCSERVER\development\profiler\data\insured
with no problems.
I would have to substitute the correct ip address for the server of course. So, it must be a vfpoledb issue? Why are you using vfpoledb? What is the backend?
>I am accessing folder on a Win2K system using the foxpro Oledb provider. As this has to go through a firewall in the live version I have to use the Network Address option in the connect string e.g
>provider=vfpoledb; Newwork Address=xxx.xxx.xxx.xxx; Data source=folder;
>I am opening the connection with a valid user id and password for the server machine and I have set up a share on the folder with full permissions for that user's group.
>
>If I use the network name (e.g Data source=\\computer\folder) then the connection is set up with no problem, but when I use the IP address the connection fails.
>
>I am wondering if I have to set up additional permissions because I am accessing the data using an ip address. But I don't know enough about Win2k to know where to look.
>
>For testing the data us held on a Win2k Professional machine but in real life it will be held on a Win2k server.
>
>Any advice would be much appreciated
>
>Andrew Fell-Gordon
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"