Cetin

Ref. to my first message thread again.

Cetin after reinstalling WINDOWS + VFP on my machine i havent tested this problem but i will surely do it today and will get back to you on UT .
Thankyou for discussing this topic, it is helping me to see things which were a little murky.




>Over the network it'd fail naturally if exe is local. That pathing is a relative pathing. ie:
>set path to data
>means set path to 'data' folder under current folder (which is typically the exe 'start in' folder - users might fix it themselves changing the start in folder to server's app folder).
>
>set path to \\myServer\myFolder\Data
>
>would explicitly set path to server's data path no matter the exe is and 'start in' folder is set to.
>However if form's used DE and there is a data folder that matches developer's pathing then tables from that folder would be used no matter the pathing is. ie:
>During development you had a c:\MyApp\Data folder and tables were used from this folder. In delivered box also there is a folder 'c:\MyApp\Data' with tables in it (test install or something like that). In that case no matter the pathing is forms use c:\MyApp\Data tables.
>
>Cetin



>
>>Hi Cetin
>> The Database WORLD.DBC and its tables are all in the DATA folder.
>>The pathing given by me in the APP is
>>
>> SET PATH TO temp;progs;DATA;reports;FORMS;MENU;libs;CURSORS;pics;DLL
>>
>>over the network this path fails. (look at the err msg below it references the client machines C Drive for the data)
>>
>>all this works fine on the APPLICATION SERVER but it gives the error when u try to run the app from the client machine. Last night i have reformatted my hdd and re-installed windows and VFP7 without the sp1 patch, i havent tried running the app on the new installation but will let you know when i have done.
>>
>>
>>
>>
>>
>>>>Hi
>>>>
>>>> I have a stange problem and i figure this could be a BUG (not sure).
>>>>
>>>>Earlier I had put the problem on UT but i didnt get satisfactory reply and I havent seen this problem being posted on UT.
>>>>
>>>>Following is my machine configuration -
>>>> W2K Adv Server with SP4 installed.
>>>> VFP 7.0 With VFP70SP1.MSP + VFPODBC.MSI
>>>> CR 8.5 with SP1
>>>>
>>>>
>>>>Following is my network application setup -
>>>> Machine A (NETBIOS name of the machine is SRV) - Main application Server . The application database (WORLD.DBC) with the tables is installed in the share WORLDAPP
>>>>
>>>> CLIENT MACHINES - are configured to start the application locally on their machine but the database is accessed across the network via the following path \\SRV\WORLDAPP
>>>>
>>>>The problem i face now is that when the application is started from a client machine the following error is popped to the user (this never happened to me before applying the VFPSP1)
>>>>
>>>>*------------------------------------------------------------------------------------------
>>>>c:\WORLDAPP\Data\WORLD.DBC : Cannot Link tabe '\\... \database\user.dbf' to this database:
>>>>duplicate or missing fields. Would you like to try to locate the owning database or
>>>>delete the link (and free the table)?
>>>>
>>>> LOCATE DELETE CANCEL
>>>>*-------------------------------------------------------------------------------------------
>>>>
>>>>
>>>>If i configure my client machines to work in the following manner than the app works fine and there is no error reported.
>>>>
>>>> CLIENT MACHINES - are configured to start the application on the server
>>>> TARGET : \\SRV\WORLDAPP\WORLD.EXE
>>>> START IN : \\SRV\WORLDAPP
>>>>
>>>>
>>>>Another interesting thing is this only happens with the DATABASES i have created on this configuration (VFP7.0+SP1+VFPODBC.MSI). My earlier applications works fine and doesnt show any backlink error (possibly bcoz i had not applied vfp70sp1.msp patch).
>>>>
>>>>Does anybody have a similar problem !
>>>
>>>Sanjay,
>>>I've been working with VFP7+SP1 almost since its release. I've never seen such a problem.
>>>I suspect it's your pathing.
>>>In your message :
>>>
>>>"c:\WORLDAPP\Data\WORLD.DBC" shows as database but .dbf is from another path. Probably during development you had the data in 'data' folder and form DE's now find a world.dbc from a 'data' subfolder. Try renaming the data folder to something else (ie:datax).
>>>Cetin