On Mon, 19 Jul 2010 17:12:33 -0700, Gene Wirchenko <genew (AT) ocis (DOT) net>
wrote:

And, if I do have what is required, how exactly to install it? I
would love a good tutorial. I did find a tutorial, but it did not
work.

Sincerely,

Gene Wirchenko

Gene Wirchenko wrote:

I installed this package: SQLEXPRWT_x86_ENU.exe
The name tells me it's different from the SQL Server 2008 with Advanced
Services.
Before that I installed both the Framework 3.5 and the Windows Installer 4.5
as you did, same versions, since I was reading the page about SQLServer 2008
with Advanced Services, but I did not install the PowerShell when I realized
we had this package.
Here's some explanation of the 2 packages:
http://social.msdn.microsoft.com/For...e-8959e59e2a3c

All the softwares I installed simply required clicking on "Next" button,
apart from agreeing to the EULAs, so I didn't modify anything.
--
Vilco
And the Family Stone

On Wed, 21 Jul 2010 15:56:59 +0200, "ViLco" <villiber (AT) tin (DOT) spam> wrote:

[snip]

Well, I had to specify some accounts. I hope I got that right.

Now what?

Sincerely,

Gene Wirchenko

Gene Wirchenko wrote:

Use it
I don't know what you did install it for, you know why. For testing?
Exporting data to/from VFP and SQL? Upsizing your VFP data to SQLserver?
I mainly use it to extract data coming from customers who move from third
party products to our products, and we have to convert theyr data into our
structure. This way I have seen many versions of SQLserver, Oracle, SQLbase,
SQLAnywhere, Cobol files, C-iSAM, Access, Excel, csv...
It's nice to get in touch with different RDBMS's.
--
Vilco
And the Family Stone

On Fri, 23 Jul 2010 10:05:39 +0200, "ViLco" <villiber (AT) tin (DOT) spam> wrote:

I would like to set up a simple database using SQL Server
features and get comfortable with it. Then, I want to see about
having VFP talking to such a database.

Anything else is extraneous for now. Well, maybe you will tell
me that I should also look at <something I wot* not of>.

*wot: a word to use when "know" is too long.

Sincerely,

Gene Wirchenko

Gene Wirchenko wrote:

Launch SQLserver Management Studio Express (MSE) and see the tree structure
on the left, see databases. Create a new one and then connect to it. I
usually connect via ODBC, due to what I usually do with RDBMS, you can do as
you please.
Then once you're connected you can start working with SQLEXEC()
If yoy choose the ODBC way, the SQLServer ODBC wizard will ask you some info
as the server, I used MyPCname\SQLEXPRESS, then you'll be asked for the
database name, use what you've inserted when creating it in MSE. After this,
you should be ready to go.
--
Vilco
And the Family Stone

On Tue, 27 Jul 2010 15:57:38 +0200, "ViLco" <villiber (AT) tin (DOT) spam> wrote:

I have no SQLserver Management Studio Express (MSE) in my SQL
Express installation. I have SQL Server Management Studio.

How do I connect to the new database?

Are you referring to use within SSMS? If yes, then I have
figured out how to do that. At least, I can switch between databases
creating tables in each.

If not, I have no idea what is involved in connecting. I have
been using VFP's internal tables only.

As you can see, I am not at the ready-to-go point yet and could
use some help getting there.

Sincerely,

Gene Wirchenko

Gene Wirchenko wrote:

I have added "express" involuntarily, it's as you say.

Yes, I meant that, in this stage.

So you have created some databases? OK

FInd a guida telling how to setup an ODBC Data Source for the SQLexpress
server, it's very long to write down here and you can find a ton on the net.
Then you'll have your SQLserver ODBC data source. During the odbc data
source wizard, select "Windows Authentication" for ease of use. If you
don0't find the server in the "Server: " combobox, type
YOURPCNAME\SQLEXPRESS as the server.
With VFP just do

hnd = SQLCONNECT("DataSourceName")

? SQLEXEC(hnd, "SELECT SOMEFIELDS FROM SOMETABLE WHERE SOMECONDITION",
"SQLDATA")

And you'll have a VFP cursor containing the data from that table, filtered
as you asked with SQLEXEC().
The same SQLECEC() command can be used to INSERT, UPDATE, DELETE and so on.
Other nice commands are SQLTABLES and SQLCOLUMNS. On VFP's guide you should
check the various commands/ functions whose name starts with "SQL", you'll
find a lot more.
This is just the basics, then there's a nice thing in VFP called
CursorAdapter, which can be used to simplify more complex things as
updateable views and so on.
HTH
--
Vilco
And the Family Stone

This webs:

http://www.vitus.com/vfpcs.html
http://www.connectionstrings.com/

can be useful for you.

Dne 27.7.2010 23:07, Gene Wirchenko napsal(a):