Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is this a VFP7+SP1 BUG ?
Message
De
16/10/2003 06:13:04
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
16/10/2003 00:47:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00838754
Message ID:
00839156
Vues:
25
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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform