Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Vfp9 and Msde
- Thread starter dotnik
- Start date
Mike Lewis
Programmer
Hi Nicola,
Welcome to the forum.
MSDE is basically the same as SQL Server. Whatever works with SQL Server will work (more or less) with MSDE.
You should start by reading the Help file, on topics such as "Programming for remote access". Also, look at remote views and SQL pass-through.
If you have any specific questions, come back and we will do our best to answer them.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)
Nicola
I am also finishing up on a small multi-user application written with VFP 8. I started with MSDE. I recomend looking at SQL 2005 Express. It is Microsoft's replacement for MSDE. In theory, there are a few places where you may prefer MSDE, but I'm leaving MSDE and going with SQL 2005 Express. Express has a graphic interface where MSDE is command line only. Also, finding the instructions for MSDE is not easy. Here is a brief summary of how to get SQL 2005 installed and running.
Here is the URL to read up on SQL 2005 Express
1) instal WINDOWS INSTALLER 3.0 I you have XP, you
already have it.
2) install Framework 2.0
3) install SQL Express
4) Install "Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP) November 2005"
Here's the catch. The default instalation is for LOCAL use only. You have to configure it to recieve remote connections.
Step 1 of 2. Start the Management Studio. Log on to the database. Right click on the database name in the object explorer. It should be the first item in the list in the left window. Click on CONNECTIONS. Click on ALLOW REMOTE CONNECTIONS TO THIS SERVER. Close Management Studio.
Step 2 of 2 Start SQL Server 2005 Surface Area Configuration. Click on SURFACE AREA CONFIGURATION FOR SERVICES AND CONNECTIONS. CLick on SQL SERVER BROWSER. Set STARTUP TYPE to AUTOMATIC.
There are other ways to set it up and I'm sure there are pro's and cons to how I've done it. But that's the quick way that took me 2 days to learn. That will get you started with SQL Express.
The UPSIZING wizard can take your tables and send them to SQLExpress via ODBC. It can also make a remote view for retieving tha data.
I hope this helps
Jim Rumbaugh
I am also finishing up on a small multi-user application written with VFP 8. I started with MSDE. I recomend looking at SQL 2005 Express. It is Microsoft's replacement for MSDE. In theory, there are a few places where you may prefer MSDE, but I'm leaving MSDE and going with SQL 2005 Express. Express has a graphic interface where MSDE is command line only. Also, finding the instructions for MSDE is not easy. Here is a brief summary of how to get SQL 2005 installed and running.
Here is the URL to read up on SQL 2005 Express
1) instal WINDOWS INSTALLER 3.0 I you have XP, you
already have it.
2) install Framework 2.0
3) install SQL Express
4) Install "Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP) November 2005"
Here's the catch. The default instalation is for LOCAL use only. You have to configure it to recieve remote connections.
Step 1 of 2. Start the Management Studio. Log on to the database. Right click on the database name in the object explorer. It should be the first item in the list in the left window. Click on CONNECTIONS. Click on ALLOW REMOTE CONNECTIONS TO THIS SERVER. Close Management Studio.
Step 2 of 2 Start SQL Server 2005 Surface Area Configuration. Click on SURFACE AREA CONFIGURATION FOR SERVICES AND CONNECTIONS. CLick on SQL SERVER BROWSER. Set STARTUP TYPE to AUTOMATIC.
There are other ways to set it up and I'm sure there are pro's and cons to how I've done it. But that's the quick way that took me 2 days to learn. That will get you started with SQL Express.
The UPSIZING wizard can take your tables and send them to SQLExpress via ODBC. It can also make a remote view for retieving tha data.
I hope this helps
Jim Rumbaugh
- Thread starter
- #4
Hi,
I am developing a small application founded on SQL server with interface visual fox for 9.
I have just finished a programs of test that has correctly developed the following operations:
1) opening connection to the sql server database;
2) select of all the records of the table customers;
3) setup parameters on local cursor through SQLSETPROP;
4) updating record on local cursor and physical table on database;
5) close connection.
* -
Now I would like to begin to develop the whole rest.
Does the initialization of the environment date for every form it owes somehow it should elaborate the footsteps 1,2,3 as suitable above?
It would be useful to have a function that performs the operations from the point 1 to the point 3.
1000 Thanks to everybody
Nicola Francione
Ferrandina(MT), Italy
I am developing a small application founded on SQL server with interface visual fox for 9.
I have just finished a programs of test that has correctly developed the following operations:
1) opening connection to the sql server database;
2) select of all the records of the table customers;
3) setup parameters on local cursor through SQLSETPROP;
4) updating record on local cursor and physical table on database;
5) close connection.
* -
Now I would like to begin to develop the whole rest.
Does the initialization of the environment date for every form it owes somehow it should elaborate the footsteps 1,2,3 as suitable above?
It would be useful to have a function that performs the operations from the point 1 to the point 3.
1000 Thanks to everybody
Nicola Francione
Ferrandina(MT), Italy
- Status
Similar threads
