Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem With EXE on Server
Message
From
16/11/2003 13:41:53
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
 
To
13/11/2003 10:48:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00849530
Message ID:
00850462
Views:
19
It may be that the form is "finding" the wrong database. Try...

1) In the DE BeforeOpenTables method for each cursor object add...

This.CursorObjectName.Database="\\serverpath\dbcname.dbc"

2) Set the cursor's NoDataOnLoad property to .T.

3) Then when you need the data, set the paramaters and the issue a

lcParam1 = whatever1
lcParam1 = whatever2
=REQUERY('CursorAlias')

HTH,
Larry Long


>Hi
>
>Heres my problem.. I have an app that uses 2 remote sql server views to display some data in a grid.If i run the EXE locally it works fine however trying to run it from a mapped network drive it errors out loading the form with a 2005 error loading the data environment. So I know it has something to do with loading the view but not sure why. If I open the database on the server i can open and browse the remote view without any problem.
>
>Thanks,
>
>Paul
L.A.Long
ProgRes
lalong1@charter.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform