Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing MSDE via VFP
Message
From
08/12/2001 22:47:31
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00591131
Message ID:
00591781
Views:
21
>To all,
>
>Has anyone actually managed to *get* to MSDE from VFP? Everything I've seen describes getting to MSDE from Access. If VFP is mentioned at all, its only to say "oh, by the way, MSDE also ships with VFP".
>
>I can't even get something as basic as the VFP Upsizing Wizard to work.

Since it's really a SQL server without the graphic interface, you can simply write TSQL scripts in text files and run them line by line from Fox:

nHandle=SqlConnect(cString)
=sqlexecute(nHandle, cCommand1)
=sqlexecute(nHandle, cCommand2)

...etc, where cCommandx would be lines from your script (filetostr(), alines() and then for...endfor).

Yes it's pretty much back to dot prompt, you have to do everything manually, but it's doable.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform